Loading ...

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

How To Display Images In Grid Of Acumatica

Hello everybody, today I want to leave a short post on how to display images in grid of Acumatica.  I'll demonstrate it on sample of Sales Orders pages, which is known as SO301000. End result will look like this:   In order to make it work, I've done the following: Created extension to...

Most Useful Git Commands

Hello everybody, today I want to make post about most useful IMHO commands. Honestly speaking as usually I prefer to use tortoise git with it's gui. But quite often it happens that even the best gui tool can't give you necessary flexibility. For this purpose git commands come on your rescue. In t...

How To Deal With Read Commited Snapshot Error Message In Acumatica

Hello everybody, today I want to leave SQL fix for error message: "There are problems on database server side: READ_COMMITTED_SNAPSHOT is not set for current database. On your Acumatica instance it may look liike this: For fixing run this SQL: ALTER DATABASE Saddleback_staging SET READ_COMMITTED...

How To Debug Acumatica With Dnspy

Hello everybody, today I want to share with you few words about debugging of Acumatica. There are plenty of wonderful posts for doing this with help of already provided PDB files of existing graphs and first of all I definetely recommend to use them. But there are scenarios when default pdb provi...

How To Create Unique Index In Ms Sql That Will Allow Null

Hello everybody, today I want to leave a post about the following case: you need to index rows in your database by some unique value, which can be null. And you don't want index to include those values which are null.  How to achieve it? Following T-SQL can do this: CREATE UNIQUE INDEX idx_s...