105
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
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.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (