
I am working with SL 2011 and I would like to know what tables are affected by a accounts receivable invoice which has been created, posted, and released. Any help would be very appreciated. Thanks
*This post is locked for comments
I have the same question (0)John
A lot of tables are affected.
On the AR side of things - Batch, ARDoc, ARTran, AR_Balances, ARHist, HistDocSlsTax (and probably other sales tax tables).
The Customer table may be affected - not sure offhand.
When a payment or CM is applied to the invoice, ARAdjust will be affected.
On the GL side of things - Batch (the same batch record as before), GLTran, AcctHist, CuryAcct
I'm sure I've missed some.
Barry