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...
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...
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. Later on I h...
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 another article I've descirbed how to use Autofac for resolving interface < -- > class implementation.
But one of my collegues Deebhan Hari pointed that...