I created a UDF in ARRegister called UsrInvParent (datatype INT), in the ARRegister table.
What I want to do is save the ParentBAccountID of the customer BAccount on the invoice to this new UsrInvParent UDF upon the “Release” of the invoice.
So, using customization what is the best way to code this in Acumatica? (if someone could provide an example, I would greatly appreciate that also.)
(The reason for the new UDF is that our customers quite often change parent accounts due to acquisitions and we need to capture the parent account at the time of invoice for historical reporting.)
I hope I am being clear as to what I am wanting to do.
Thank you so much!
I am trying to do in Acumatica with an Invoice Release what I can do in SQL with the following command.
SET AR.UsrInvParent = Cust.ParentBAccountID
FROM [dbo].[ARRegister] AR
ON AR.CustomerID = Cust.BAccountID
WHERE AR.[CompanyID] = 2
AND AR.[CustomerID] = 26603
Best answer by darylbowmanView original