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...
Hello everybody,
today I want to write a few words with code samples on how to work with Screen based web API in Acumatica.
Stage preparation
Before you go, first step that is needed is to have Acumatica instance ready. So install Acumatica with sales demo database.
As mentioned in the titl...
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. Lat...
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...
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...
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...
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...
Hello everybody,
today I want to leave a short notice on how to use Autofac in Acumatica, but with single registration. In this article I've descirbed how to use Autofac for resolving interface < -- > class implementation.
But one of my collegues Deebhan Hari pointed that with my...
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...
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...