👨💻
Custom SQL views are a powerful way to extend Acumatica's reporting capabilities. They let you pre-join complex data, perform aggregations, and presen...
🧩
In Parts 1 and 2 of this series, we covered logical, text, mathematical, and date functions. In this final part, we'll explore aggregate functions, co...
🗄️
In Part 1 of this series, we covered logical functions (IIf, IsNull), text concatenation (Concat), and basic date calculations (DateDiff). In this par...
🔌
Generic Inquiries are one of Acumatica's most powerful reporting tools, and their true potential lies in the ability to use predefined functions withi...
📱
Generic Inquiries are one of Acumatica's most powerful reporting tools, but their true potential lies in grouping and aggregation. Whether you need to...
☁️
The Acumatica contract-based REST API provides comprehensive capabilities for creating and managing sales invoices programmatically. Whether you're au...
🚀
The Acumatica contract-based REST API provides powerful capabilities for programmatically creating and managing shipments. Whether you're fulfilling o...
🧠
Acumatica's contract-based REST API provides a powerful way to create sales orders programmatically. Whether you're integrating an e-commerce platform...
👨💻
Welcome to the final part of this series. Over the previous four parts, we've covered everything from the fundamentals of PXCache to complex productio...
🧩
In the first three parts of this series, we explored the foundations, advanced techniques, and performance optimization strategies for persisting data...
🗄️
In Parts 1 and 2, we explored the foundations of data persistence and advanced techniques for working with events in Acumatica. In this final part, we...
🔌
In Part 1, we explored the foundations of data persistence in Acumatica: the PXCache object, its primary data modification methods, and the persistenc...
📱
In Acumatica, data persistence within events is a critical concept that every developer must understand. The framework provides multiple ways to modif...
☁️
The Acumatica 2026 R1 release brought many enhancements, but it also introduced a significant regression affecting ISV solutions that rely on multi-pa...
🚀
For businesses expanding and managing more than one company, setting up a new company in Acumatica ERP is an important step. This includes configuring...
🧠
Generic Inquiries are one of Acumatica's most powerful features. They allow users to create custom queries and reports without extensive programming s...
👨💻
For years, the promise of AI in ERP has been discussed in boardrooms and tech conferences. But for the operations manager, finance lead, or purchasing...
🧩
Enterprise applications face unique challenges: changing business requirements, multiple platforms, system integrations, and the need for modular, tes...
🗄️
.NET MAUI Custom Controls Bindable Properties
Custom Controls and Bindable Properties in .NET MAUI
Building reusable, flexible, and dynamic UI compo...
🔌
The Model-View-ViewModel (MVVM) pattern is the foundation of modern .NET MAUI development. It separates the user interface from the business logic, ma...
📱
Performance is critical for mobile and desktop applications. Poor performance leads to frustrated users, bad reviews, and abandoned apps. This guide c...
☁️
Markup extensions in XAML are powerful tools that allow you to extend the XAML language with custom functionality. They enable you to create complex, ...
🚀
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...
🧩
Building robust, maintainable, and secure Web APIs in .NET requires more than just knowing the syntax. It demands adherence to established patterns, u...
🗄️
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...
📱
Understanding Acumatica Events
A comprehensive guide to graph events, field events, and execution sequences
The Acumatica Framework provides a r...
☁️
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...
🚀
What's New in .NET 11 Preview 6
A developer's first look at the latest features and improvements
The .NET ecosystem continues to evolve at a rem...
🧠
🙏 Credit & Inspiration: This solution is based on the work of Dmitry Naumov , Solution Architect at Acumatica. His contributions to the Acumatica De...
👨💻
When customizing Acumatica ERP, there are times when you need to modify the behavior of standard processing screens. One common requirement is to filt...
🧩
When building customizations for Acumatica ERP, providing clear and immediate feedback to users is essential for a good experience. The PXSetPropertyE...
🗄️
Dapper is a lightweight, high-performance micro-ORM that sits right on top of ADO.NET. It gives you the best of both worlds: the speed of raw ADO.NET ...
🔌
Repository Pattern with Entity Framework Core
A comprehensive guide to implementing the Repository pattern using Entity Framework Core with async met...
📱
Async/Await in Production: The Mental Model That Matters
The async and await keywords make asynchronous C# code look almost synchronous. That is th...
☁️
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...
🚀
Mastering C# in 2026: 10 Features Every .NET Developer Should Know
C# has consistently evolved into one of the most productive and modern programmi...