Loading ...

Acumatica Application Architecuture

Hello everybody, today I want to leave a short note about Acumatica Architecture. Take a look on this picture: As you can see from the schema business logic controllers is kind of single source of truth. Acumatica doesn't have dependencies between UI and Web services. Also it means, if you hide...

How To Speed Up Database Of Acumatica With RAID 10

As a seasoned Acumatica developer with over 11 years of hands-on experience, I've seen how performance improvements in your ERP system can make a significant difference. One effective strategy I've come across is implementing RAID 10 (Redundant Array of Independent Disks) for Acumatica’s infrastr...

Property From Cropportunity Is Not Loaded

Hello everybody, today I want to leave short note on issue with CROpportunity DAC class. For quite a few times I've noticed that someone adds field to CROpportunity, but later notices that field is lost either on moment of loading from database, or lost during persisting record to data...

Moving To Another Hosting

Hello everybody, as you probably noticed, I didn't have many blog posts recently during months of November and December. Reason for such idling from my side was issues with hosting provider. For some weird reason hosting provided behaved not very decently, and for me it become necessary  to...

New Sql Server 2016 Features To Use In Acumatica

Hello everybody, today I want to write about new additions for SQL Server T-SQL language, which are there starting from 2016. It is create or alter syntax. In the past, if you've made some custom SQL view, it was needed to have constructions like this ( pseudo code ): if view ( stored procedure,...

LastModifiedDateTime Has Wrong Datetime Information

Hello everybody, today I want to share interesting use case which raised recently when dealt with syncrhonization of records between Magento and Acumatica. I had following declaration: #region LastModifiedDateTime [PXDBDateAndTime()] [PXUIField(DisplayName = "Last Modified&nbs...

SelectFrom For Usage In View Select

Hello everybody, I want to leave a short note on how to use SelectFrom for legacy code, and pass it in View.Select for Acumatica newer versions.  var cmd = new SelectFrom<PartsCatalog>.     InnerJoin<INSiteStatus>.On<Use<PartsCatalog....

How To Overrde Authorize Cc Payment Action In Acumatica

Hello everybody, as it was mentioned in one of my previous blog posts, regarding overriding base actions of Acumatica graphs, family of graph extensions grows and grows.    Today I want to share one more code snippet which you can use for extending modification of Acumatica actions...

How To Override Shoprates Action In Sales Orders Form

Hello everybody, today I want to leave a short post on how to override Shop rates Action in Acumatica.  I mean this button: Below goes C# code, with which you can achieve it: public class SOOrderEntryExt : PXGraphExtension<SOOrderEntry.CarrierRates, SOOrderEntry&...

PXLongOperation Cleans Everything How To Avoid

Hello everybody, today I want to write a few words about interesting behavior of PXLongOperation.StartOperation in Acumatica. On the glance that looks pretty simple and straightforward. You have something processing of which will take a long time? Use PXLongOperation.StartOperation. So imagi...