Loading ...

How To Download DAC Schema Browser

Hello everybody, here is just short post on how to download DAC Schema browser which I recently opensourced. You'll need two steps: 1. Navigate in your browser to link https://github.com/YuriyZaletskyy/DacSchemaBrowser 2. Click on Star as displayed on screenshot (this is optional step): &nb...

How To Get List Of All Acumatica Tables

Hello everybody, today I want to share single line of code, which I found recently while digging Acumatica source code with reflector. Sometime you may need to know if there is some or antoher Acumatica table available. For example if you create some customization plugin. How to find out if there...

How To Call Action Cancel In Acumatica

Hello everybody, Today I want to leave a short notice on how to call Cancel button of Acumatica from inside C# code: graph.Clear(); That is it, Clear method is binded to button Cancel in Acumatica. Besides that Clear method will reload current data record from database and rolls back changes of C...

Pxuirequired Attribute Usage In Acumatica

Hello everybody, today I want to say a bit more about usage of attribute PXUIRequired as previous article on my blog wasn't very easy to follow by some of my readers. Take a look on presented code sample: public class sOOrderType : Constant<string> { public const&n...

One More Definition Of Group By For T Sql

Hi everybody, today I want to give one more definition of Group by of SQL language which for me is very explanatory. Group by statement produces a record for each unique combination of group by columns list and ommiting other columns of tables. Also you can apply aggregate functions to other colu...

How To Extend Persist Of Your Own Graph In Acumatica

Hello everybody, here I want to leave a short line on how to extend Perist method of your own graph. I described once long time ago how to override Save action in your extension, but sometime it can be needed to override Persist in your own graph. Sometime it can be necessary. Below goes sample o...

Closest Possible To Database Approach In Acumatica

Hello everybody, today I want to leave another post about internals of Acumatica, about which you may heard something like "Never try it at home". In another words, sometime you may need to do the following in Acumaitca: Insert directly into database ( for this purpose I'd recommend you to use P...

Submition Types In Acumatica

Hello everybody, today I want to leave a really short notice on how you can submit data into Acumatica. There are three ways: Contract-based REST API Contract-based SOAT API Screen-based SOAP API Historically the first was screen based SOAP API, and with time two others were added. Later on I h...

How To Refresh Cache Of Acumatica

Hello everybody, today I want to leave a comment on how to refresh cache of Acumaitca. As usually I start with this method:   ViewName.View.RequestRefresh();   But I found that it not always work. For my surprise RequestRefresh not works for some reasons. I think reason for this ma...