In many Acumatica customization projects, developers encounter scenarios where multiple DACs (Data Access Classes) need to be updated in nearly identical ways. Often, the only difference is the table name and field name being updated — yet developers end up writing dozens of separate methods for...
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.
I want to share if you need to execute stored procedure in Acumatica how to achieve it.
It's simple.
1. Create Stored procedure in db.
2. Use in your code PXDatabase.Execute.
For example let's say you created stored procedure which has name DeletePrTranByPrPayroll...