Here I document some issues for searching of which I spent more then 15 minutes
today I want to leave a post on how to restore Acumatica snapshots with help of Acumatica Wizard.
Before creating snapshot you may need to switch Acumatica to maintenance mode. Below are the steps for achieveing it:
1. Go to System --> Management --> Apply Updates, click on the button "Schedule Lockout" and specify the reason for lockout 2. Don't forget to remove the lockout after you'll restore Snapshot.
Steps are the following:
1. Create a snapshot of the tenant you wish to back up
2. Export that snapshot (I recoment xml format).
3. In the folder where the corresponding Acumatica Wizard is installed (usually c:\program files\Acumatica ERP\), find the folder … more
today I want to leave a short note for the following situation:
Imagine that you need to enable some control in Acumatica ( for example Mark for PO ) on page Sales orders ( SO301000 ).
As usually for enabling control there are two ways:
Recently I found third option, when neither 1 nor 2 did work. After spending some time I found third option: Cache has property AllowUpdate. After I've set it to true, I was able to modify lines in Document details.
In your code it may look like this:
protected void SOLine_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected del)
if (del != null)
del(cache, e) … more
today I want to write a few words about changes of PXUIFieldAttribute.SetVisibility method.
In the past, if you wanted to turn on some column, you could write in RowSelected event something like this:
PXUIFieldAttribute.SetVisibility<APRegister.finPeriodID>(Documents.Cache, null, true);
If you want to turn it off, then this:
PXUIFieldAttribute.SetVisibility<APRegister.finPeriodID>(Documents.Cache, null, false);
But for quite a long time ( even in 2017 version ), Acumatica team introduced PXUIVisibility enum. In code it looks like this:
public enum PXUIVisibility
Undefined = 0,
Invisible = 1,
Visible = 3,
SelectorVisible = 7,
today I want to leave a post on how to change all emails, which are contained in Acumatica. For this purpose you may use script below:
UPDATE contact SET email = email + '.ts' UPDATE socontact SET email = email + '.ts' UPDATE apcontact SET email = email + '.ts' UPDATE pocontact SET email = email + '.ts' UPDATE crcontact SET email = email + '.ts' UPDATE arcontact SET email = email + '.ts' UPDATE fscontact SET email = email + '.ts' UPDATE crcasecontacts SET email = email + '.ts' UPDATE crcontact SET email = email + '.ts' UPDATE pmcontact SET email = email + '.ts'
If you wonder, what can be the usage of such SQL, consider following … more
today I want to describe how analogue to Required works in Acumatica Framework.
For example, in the past ( before 2019 R1 ) you may read something from Acumatica with help of Required:
var contact = PXSelect<Contact, Where<Contact.displayName, IsNotNull, And<Contact.displayName, Contains<Required<Contact.displayName>>>>>.SelectWindowed(graph, startIdx, 1, ' ').First();
Now, you can use @P.AsString, as shown on code sample below:
var contact = SelectFrom<Contact>.Where<Contact.displayName.IsNotNull.And<Contact.displayName. Contains<@P.AsString>>>.View.SelectWindowed(graph, startIdx, 1, ' ').First();
Also take a note, that … more
today I want to document one important class in Acumatica: PXInstanceHelper.
I have found it long time ago, but finally time arrived to show how it works and what features it has. So, PXInstanceHelper include such methods:
In code it looks like this:
var result = PXInstanceHelper.AppDataFolder;
Screenshot of it's execution may give you additional hint of what it does:
This method returns physical path to folder App_Data inside of Acumatica instance. As you can see from the screenshot, on my dev machine App_Data folder lives at
2. Method CurrentCompany.
In code looks like this: … more
today I want to leave a short note on how to use F-BQL version of PXSelect in Acumatica.
In past it was common to have this line of code in your graph:
public PXSelect<Student1> Students;
In new F-BQL introduced new construction, SeleftFrom. Proper way of using it is this:
public SelectFrom<Student2>.View Students;
Take notice of suffix .View. Without that suffix you'll not get proper F-BQL view. And Acuminator will give you this warning:
So if to summarize, don't forget to add suffix .View
here is just short post on how to download DAC Schema browser which I recently opensourced.
You'll need two steps:
Navigate in your browser to link https://github.com/YuriyZaletskyy/DacSchemaBrowser
Click on Star as displayed on screenshot (this is optional step):
4. Right mouse click AcumaticaTablesFixed19x100x0122.zip
5. Save customization wherever you wish
6. Publish on your local instance
That particular file is intended for Acumatica version 2019 R1 build 0122, but it should work on higher versions as well. Later on I'll add lower versions as well. more
today I want to share single line of code, which I found recently while digging Acumatica source code with reflector. Sometime you may need to know if there is some or antoher Acumatica table available. For example if you create some customization plugin. How to find out if there is some table? You can use following line of code for this purpose:
var acumaticaTables = ServiceManager.Tables;
Variable acumaticaTables will have a list of Acumatica tables.
once upon a time Acumatica requires for certified developers to pass over certification again.
As obedient person I decided to install T100 sample application over Acumatica Framework Configuration ( don't mix with Acumatica ERP Configuration ). Then I navigated to just installed application, and here is what I've seen:
Server Error in '/T100a' Application.
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: The connection string name is missing for the … more