Technical articles, implementation notes, deployment ideas, and practical engineering insights from Amit Ranjan.
In Acumatica, data persistence within events is a critical concept that every developer must understand. The framework provides multiple ways to modify and persist data, each with its own use cases, advantages, and pitfalls. This multi-part...
Six tiny specialists covering .NET development and Acumatica customization.
Writes .NET codes and only argues with null sometimes.
Builds ASP.NET MVC pages that behave better than most meetings.
Joins tables, tunes queries, and politely ignores bad indexes.
Connects APIs, integrations, and services without duct tape. Mostly.
Builds cross-platform apps and pretends every device is normal.
Crafts Acumatica packages, GIs, reports, and screen magic.
Fresh technical writing with fewer production surprises.
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...
ACU