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...