Loading ...

How To Make Redirects In Acumatica And Popup Warning

Hello everybody, today I want to write a newer post about how to give an opportunity to user go to some link from Acumatica. As I've mentioned in https://blog.zaletskyy.com/types-of-redirects-in-acumatica, redirections are implemented as exception. Let consider next simple code, by which you can...

Getting Combo Box Values Set For Rest API

Hello everybody, today I want to share idea on how to get getting Combo-box values set for REST API. As usually values of comboboxes values are just hardcoded in web api calls, but sometimes it may be necessary to load them from Rest API, for example for cases if you want to target multiplve...

Create Payment Proc

Hello everybody, today I want to write a few words about method CreatePaymentProc in graph SOOrderEntry. Among different features of this method, want to describe that it have for some reason out parameter! Take a look on it's declaration: public virtual void CreatePaymentProc(SOOr...

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....