Hello everybody,
today I want to leave another portion of SQL Server optimization for Acumatica database. In case if your db become huge, and you want to make it smaller, you can try following SQL code:
DECLARE @Table NVARCHAR(128)
DECLARE @Database NVARCHAR(128)
D...
Hello everybody,
today I want to leave a short notice on how to manage order of columns in Selector of Acumatica. Quite often customers has desire to manage default order of columns in selector. That is very easy to achieve with new Type[] parameter added to your selector. Take a look on how I've...
Hello everybody,
in this article I want to describe how filtering in Acumatica work. When I say filtering, I mean following UI part:
In manuals T100 - T300 there is almost nothing about how filters work, so I want to share few bits of development information.
Storage
All information about f...
In this part we implement real automation test for creating POOrder - screen PO301000;
Before to start, please read first part of rhis post.
The main steps:
Create solution and add nedeed components from SDK folder
Add new project (Net library) to solution
Configure generator an...
Hello everybody,
today I want to share one interesting gotcha which took plenty of efforts from mine side in order to understand it.
Recently I got an assignment to modify behaviour of Create Prepayment action at purchase orders.
If to look at CreatePreapyment implementation, it has followi...
If you want to create custom Attribute for autonumbering field you need:
Create Setup page for configuring autonumbering field or maybe you can use existing
Create Attribute which you'll add to your entity
Add attribute to field that you need increment
Create Setup page for co...
Hello everybody,
here I want to document new scope in Acumatica: PXImpersonationContext.
As often is the case try to look at presented code:
var thr = new Thread(
...
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...