Hello everybody.
Imagine that you need to have implementation of several tables with possibility to update them all.
Also you want to implement by the Acumatica side rather than by the database.
You know that Joined tables in Acumatica are read-only and you cannot update fie...
Hello everybody,
take a loot at the following picture:
Let's say that you would like to have two Acumatica instances connected to the same database. Is it possible? Definetely yes, just with pointing both of them to the same connection string and you'll get some kind of scalability.
But im...
Hello everybody,
today I want to describe how to extend Stock Item screen IN202500 in Acumatica. Imagine that you need to add to tab General settings two selectors. Suppose that you need to have two selectors:
as you can see following need to be achieved:
To tab General Settings it is...
Hello everybody,
today I want to write a few words about operator in which was presented in SQL for long ago, but weren't available in Acumatica BQL. But time goes on and now you can use it. For example like this:
Object[] values = new String[] { "BXW000004", "B...
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...