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...
Helllo,
today I want to share how to get extension of basic DAC class iin Acumatica. Lets say you have class ARTran, and extenstion for it ARTranExt and you want to get it in the code of ARTran_RowUpdated event
Then you can get extenstion in the following way:
prot...
Hello everybody,
today I want to share how to find current company id in Acumatica:
Here it is:
int? companyid = PX.Common.PXContext.GetSlot<Int32?>("singleCompanyID")
for me it was long way to find it
Ready to take your Acumatica experience to the next level? If you’ve been s...