Using SQL Views with Generic Inquiries and Reports in Acumatica
Generic Inquiries are one of Acumatica's most powerful features. They allow users to create custom queries and reports without extensive programming s...
Search articles on .NET, Acumatica customization, SQL Server, APIs, integrations, architecture, and practical software development.
total.results: 21
Page 2 of 3
Generic Inquiries are one of Acumatica's most powerful features. They allow users to create custom queries and reports without extensive programming s...
INNER JOIN is often used to find matching rows, but it can create duplicate results if the matching table has multiple records. Semi-joins and anti-jo...
Standard SQL struggles with hierarchical data like org charts, multi-level product categories, or comment threads. Recursive Common Table Expressions ...
Window functions are a game-changer for analytical queries. They let you perform calculations across a set of rows related to the current row, without...
Common mistakes developers make and how to avoid them Acumatica's customization framework is one of its greatest strengths—but also one of its bi...
Advanced techniques for implementing restrictions with subqueries and Foreign Keys The PXRestrictor attribute is a powerful tool for implementing...
Program.cs vs. Startup.cs One of the first decisions you make when starting a new ASP.NET Core project is the structure of your application start...
This website is my personal space to share the software I build, the problems I solve, and the lessons I learn while working with modern business appl...
Async/Await in Production: The Mental Model That Matters The async and await keywords make asynchronous C# code look almost synchronous. That is th...