Greetings to everybody,
today I want to document how to make selector in Acumatica.
I had the following use case:
1. Acumatica dropdown, which can have three values ( for example a, b, c) .
1.1 In case if user select option a, I need to show in PXSelector values from Table A with som...
Hello everybody,
today I want to share one simple technic of how to filter inserted items in cache from other objects. I discovered it with reflector, while diffing in code of APInvoiceEntry.
Here it is:
Adjustments.Cache.Inserted - this item will give you which items were inserted in...
Hello everybody,
today I want to share with you information about two functions:
SetValueExt and SetDefaultExt.
Names of them are pretty self-explanatory, which means SetValueExt assigns specific value to field and SeDefaultExt assings default value to a field. But SetValueExt method...
Hello everybody,
today I want to note how to use PXDataBase.Update in Acumatica.
Two use-cases.
1. Imagine, you need to set APSubID = 80 in APRegister with APAccountID = 5:
you can use the following:
PXDatabase.Update<APRegister>(new PXDataFieldAssign<...
Hello everybody,
Today I want to note web.config properties, which took for me some time to discover. It is possible to add two options in connection string of web.config.
1. Timeout=60
2. Connect Timeout=300
What is difference between those two parameters?
The first one set for how long you...
Hello,
I want to share with you how to block some columns in Acumatica.
You can do it with the PXUIFieldAttribute.SetEnabled method.
Let's say you have DAC PRTran with column earningType and values of PRTran you get from PaySlipDetails view. Then you can block whole column wit...
Hello everybody,
today I want to share with everybody how to find all items in view in Acumatica.
Suppose you have View declared in the following way:
public PXSelectJoin<PRPayrollDetails,
InnerJoin<EPEmployee, On<EPEmployee.bAccountID, Equal<PRPayrollDetails.employeeID>>,
Inn...
Hello everybody,
today I want to share how to fight with error like
Error 22 An object reference is required for the non-static field, method, or property 'PX.Data.PXSelectBase<Acumatica DAC>.Select(params object[])' bla bla bla
As usually it means that you try to use this in selector...
Hello everybody,
today I want to share results of my investigations of two similar pieces of functionality in Acumatica.
Have you ever wondered which Insert in cache works faster this:
a) var temp = (PRPayrollDetails)PayRollsDetails.Cache.Insert();
or this:
b) va...
Hello readers,
today I want to share hwo it is possible to read from stored procedure in Acumatica. Keep in mind, that reading from sp is against best practices of Acumatica, because if you read from sp, then you'll reading will not be cached and other side effects, but sometime you don't have a...