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
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,564 Super User 2024 Season 2
Martin Dráb 228,651 Most Valuable Professional
nmaenpaa 101,148