Hello everybody,
today I want to speak about one very interesting feature of FBQL, which I don't know if exists in BQL. Function Brackets!
Take a look on following code sample:
var bracketsDemo = SelectFrom<SOOrder>.InnerJoin<SOLine>.On<SOLine.orderNbr.IsEqual<SOO...
Hello everybody,
today I want to leave a short note on how to pass some additional parameters into Processing method of processing page with help of lambda expression. Syntax is pretty simple:
public class SSShipmentDateResetter : PXGraph<SSShipmentDateResetter>
{
publi...
Hi everybody,
today I want to leave a short note on how to deal with Unbounded DAC classes in Acumatica. Unbounded in other words means DACs that doesn't have dirrect persising target in database.
For Unbounded DAC classes to work like this, two steps are needed:
Add attribue [PXVirtualDAC] to P...
Hello everybody,
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:
RowSelected
Automation steps.
Recently I...
Hello everybody,
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&...
Hello everybody,
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&...
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 o...
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:
Insert directly into database ( for this purpose I'd recommend you to use P...
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 titl...
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. Lat...