Hello everybody,
today I want to share one interesting piece of information about horizontal scaling of Acumatica. I mean as usually for majority of people it is clear that Acumatica can work on one machine when DB, IIS and Acumatica lives on one machine.
One more variant of scaling can be...
Hello everybody,
today I want to describe interesting feature of Acumatica related to back ups of database. Imagine the following: you've restored database from back up at your dev environment. And let's say you have automation schedule that every hour you should send to each contact some emails....
Hello everybody,
today I want to make a short notice on how to change default time zone in Acumatica.
In my case such need appeard when it was needed to modify default time zone of Acumatica that I've restored from database backup. In order to do this you'll need to go to screen that is nam...
Hello everybody,
today I want to describe one behaviour of Acumatica processing screen.
So, once upon a time I created processing screen. Purpose of that screen was simple: take data from some external source and insert it into Acumatica.
As that processing screen worked fine, it was...
Hello everybody,
recently friend of mine gave me wonderful question:
In PXSelect command, I saw Search, Search2, Search3… keywords, please explain the difference.
Thats really good question which shows his attentiveness to details.
So, no let's go part by part.
Targets
First of all, Search statem...
Hello everybody,
today I want to share some knowledge about interesting feature of Acumatica: Approve and Reject actions in Purchase orders screen.
When I was asked how long it will take to modify behaviour of Approve and Reject actions, I've thought it will be easy task. Find appropriate Actions...
Hello everybody,
today I want to write few words about interesting feature of Acumatica: column DeletedDatabaseRecord. As you may know plenty of ERP systems have strategy of holding everything that ever passed through them, and even if user has huge desire to ask ERP system to forget somethi...
Hello everybody,
today I want to say a few words about my practice of usage Multithreading in Acumatica. I have a dedicated server which has 40 cores. And I have a need to read plenty of records from some other system. General schema is like this:
Create some graph instance.
Fill created graph i...
Hello everybody,
today I want to write few words about buttons usage in Acumatica.
So, first of all, if you just need to add button at your form, you can use following syntax:
public PXAction<PrimaryDACClass> SomeAction;
[PXButton(CommitChanges = true)][PXUIField(DisplayName = "Some...
Hello everybody,
today I want to document one useful sql query that can be beneficial for cases if you need to dig in Acumatica tables, and need quickly to find type of some particular column.
Here it is:
select * from information_schema.columns where table_name = 'SOLine' and COLUMN_NAME...