How To Download Dac Schema Browser


Hello everybody,

here is just short post on how to download DAC Schema browser which I recently opensourced.

You'll need two steps:

1. Navigate in your browser to link 2. Click on Star as displayed on screenshot (this is optional step):

       4. Right mouse click

       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.


How To Get List Of All Acumatica Tables


Hello everybody,

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:

using PX.Api.Soap.Screen;


var acumaticaTables = ServiceManager.Tables;

Variable acumaticaTables will have a list of Acumatica tables.


Configuration Error For Acumatica T100 Training


Hello everybody,

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.

Configuration Error

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 MySqlSiteMapProvider

Source Error:

Line 283:    <siteMap>
Line 284:      <providers>
Line 285:        <add name="MySqlSiteMapProvider" type="MySql.Web.SiteMap.MySqlSiteMapProvider, MySql.Web, Version=, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionStringName="LocalMySqlServer" applicationName="/" />
Line 286:      </providers>
Line 287:    </siteMap>

Source File: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config    Line: 285

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.3282.0



Very puzzling honestly speaking. You've just installed something, and right from the start it doesn't work. 

After some Research I have found, that following some additions should be added to node siteMap section providers:

			<siteMap enabled="true" defaultProvider="PXDatabaseSiteMapProvider">
			            <remove name="MySqlSiteMapProvider" /> <!-- add this line --> 
			            <remove name="PXWikiProvider" />


After those additions I was able to open Training sample T100.


How To Call Action Cancel In Acumatica


Hello everybody,

Today I want to leave a short notice on how to call Cancel button of Acumatica from inside C# code:


That is it, Clear method is binded to button Cancel in Acumatica. Besides that Clear method will reload current data record from database and rolls back changes of Cache objects.


Pxuirequired Attribute Usage In Acumatica


Hello everybody,

today I want to say a bit more about usage of attribute PXUIRequired as previous article on my blog wasn't very easy to follow by some of my readers.

Take a look on presented code sample:

public class sOOrderType : Constant<string>
	public const string SOOrderType = "SO";
	public sOOrderType() : base(SOOrderType)
public class SOOrderExt : PXCacheExtension<SOOrder>
	[PXMergeAttributes(Method = MergeMethod.Append)]
	public virtual string CustomerOrderNbr { getset; }

As you can see, besides attribute PXUIRequired it has declaration of constant value "SO". With that declaration before class you may get validation only for SO Order type "SO".

And now as you see on screenshot, field Customer Order got it's star. Take notice that color of that star is also differnet, it become red.

One more point which I want to underline, attribute PXUIRequired will work in connection with PXDefault attriubute. Without PXDefault attribute you'll get another error message, so as as summary, use PXUIRequired attribute with PXDefault.


How To Extend Persist Of Your Own Graph In Acumatica


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 of code for this purpose:

public override void Persist()
	//Some other custom business logic

Here you go.


Closest Possible To Database Approach In Acumatica


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:

  1. Insert directly into database ( for this purpose I'd recommend you to use PXDatabase.Insert )
  2. Alter Table
  3. Alter Schema of Table
  4. Create column
  5. Drop column
  6. Drop Table
  7. .... this list is not exhaustive

and any other system level activities. By default and for SOLId SOLID SOLID reasons you can't achieve it. But sometime you may need it. 

Below goes sample of code, which you can use for setting identity insert to on, and then execute some update onf the table, and then assign some value to it:

using System.Collections;
using System.Collections.Generic;
using PX.BulkInsert.Installer;
using PX.Data;
using PX.DbServices.Commands;
using PX.DbServices.Commands.Data;
using PX.DbServices.Points;
using PX.DbServices.Points.DbmsBase;
using PX.DbServices.Points.MsSql.Commands;
using PX.DbServices.QueryObjectModel;
using PX.Objects.PO;
using PX.Objects.SO;
namespace SomeSqlDemo
	public class POOrderEntryExt : PXGraphExtension<POOrderEntry>
		public IEnumerable ExecuteSomeSql(PXAdapter adapter)
			string tableName = "SOShipLineSplit";
			int companyId = 2;
			PointDbmsBase point = PXDatabase.Provider.CreateDbServicesPoint();
			ScriptExecutor scriptExecutor = new ScriptExecutor(point);
			ExecutionContext executionContext = new ExecutionContext(new SimpleExecutionObserver());
			point.executeCommands(new List<CommandBase>()
					new CmdIdentityInsert(true) { TableName = tableName },
					new CmdUpdate(tableName)
						Condition = Yaql.companyIdEq(companyId, point.getCompanies(), point.Schema.GetTable(tableName).HasCompanyMask(), 
						AssignValues = { { "UsrUniqueID"Yaql.constant(777) } }
			return adapter.Get();

Besides that take a look on this screenshot:

as you can see from the screenshot I didn't mention even third part of available methods, which you can try sometimes in case if you really need to go hard core. Deeply hardcore.

As I mentioned already Yaql is not something, where you should go straight away. Mainly you can use that features as some kind of latest resort, which will migrate data of your customization/plugin between different versions of Acumatica or if you want to preinit tables of your customization with some data in C# code etc. For other cases I'd rather recommend to use BQL with SQL Scripts for this purpose.


How To Call Recordccpayment Action From Screen Based Web Api Call In Acumatica For Payments And Applications Screen


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 title of the article, I'm going to work with "Payments and Applications" screen ( AR302000 ) and with Action Record CC Payment: 

As usually in cases of WEB API calls in .Net, you'll need somehow to create Web Reference. 

For Record CC Payment following sequence of Actions is needed.

  1. In Acumatica instance navigate to page AR302000, and click there on Help -> Web Service:

2. Copy into clipboard url, of the opened window. 

3. Go to Visual Studio and create there some Application. For example console app.

4. Then click on References with right mouse click and in pop up choose Add Service Reference:

5. In window that will appear click on Advanced

6. In next window click on "Add Web Reference... " which will cause appearing one more window:

Initially left window will be opened, and then window at the right will be opened.

After all of those steps, you can type following code for your Main function:

		static void Main(string[] args)
			ServicePointManager.ServerCertificateValidationCallback += new System.Net.Security.RemoteCertificateValidationCallback(
				(s, c, ch, pe) => { return true; });
			using (Screen scr = new Screen())
				scr.CookieContainer = new CookieContainer();
				var lr = scr.Login("admin""123");
				if (lr.Code == ErrorCode.OK)
						var schema = scr.GetSchema();
						var commands = new Command[]
							new Value()
								Value = "BESTYPEIMG",
								LinkedCommand = schema.PaymentSummary.Customer
							new Value()
								Value = DateTime.Now.ToString("yyyy/MM/dd hh:mm:ss"),
								LinkedCommand = schema.PaymentSummary.Description
							new Value()
								Value = "770",
								LinkedCommand = schema.PaymentSummary.PaymentAmount
                                                        // if configured to prompt, then must set DialogAnswer
                                                        new Value()
                                                                 Value = "paymentreffdsafas",
                                                                 LinkedCommand = schema.PaymentSummary.PaymentRef
                                                        new Value()
								Value = "xxx",
								LinkedCommand = schema.RecordCCPaymentCCPaymentData.PCTranNumber
							new Value()
								Value = "xxx",
								LinkedCommand = schema.RecordCCPaymentCCPaymentData.AuthNumber
							new Value()
								Value = "OK",
								LinkedCommand = schema.PaymentSummary.ServiceCommands.DialogAnswer,  // Base code shows that it is PaymentSummary (Document.Ask())
                                                                Commit = true
						var status = scr.GetProcessStatus();
						while (status.Status == ProcessStatus.InProcess)
							status = scr.GetProcessStatus();
						if (status.Status == ProcessStatus.Completed)
							commands = new Command[] {
							var data = scr.Submit(commands);


In presented code I want to point your attention to those details:

1. This line Snippet

using (Screen scr = new Screen())


will help you to make efficient memory usage, especially for cases when you need to submit a lot of payments

2. try/finally combination or try/catch/finally combination will help you to track error messages

3. This line


while (status.Status == ProcessStatus.InProcess)


will help you necessary amount of time for request result.

4. In case if status.Status will be equal to aborted, or something similar, you can use status.Message and check what is there. 

5. Quite often it is needed to know some values, that was created during process. For this purpose you may use commands list one more time with sycn request as done in the block


if (status.Status == ProcessStatus.Completed)


6. Always, I repeat always call Logout method. Otherwise you'll get error message that you've riched maximum allowed connections for your account.

Submition Types In Acumatica


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 hope to add description of others as well.


How To Refresh Cache Of Acumatica


Hello everybody,

today I want to leave a comment on how to refresh cache of Acumaitca.

As usually I start with this method:




But I found that it not always work. For my surprise RequestRefresh not works for some reasons. I think reason for this may be that Acumatica has two caches: caching of data and caching of queries.  

If that is the case, I use another approach ( more hardcore ) 


ViewName.View.Cache.Clear(); // clearing cached data

ViewName.View.Cache.ClearQueryCache(); // clearing cached queries.


Second approach works a bit better, because it clears not only data, but also clears cached queries, and as outcome clearing results