Share
ReportI am looking to understand what is in the following 2 tables and how they 'play' together'
PM_Payment_Apply_WORK
PM_Apply_To_WORK_OPEN
*This post is locked for comments
You’re offline. This is a read only version of the page.
I am looking to understand what is in the following 2 tables and how they 'play' together'
PM_Payment_Apply_WORK
PM_Apply_To_WORK_OPEN
*This post is locked for comments
The PM_Apply_To_WORK_OPEN - PM10200 is the apply table which contains all Payables Apply details. Payments to invoices, credits to invoices, etc. These transaction can be unposted (WORK) or posted (OPEN).
The PM_Payment_Apply_WORK - PM10201 shows only the intended application of an unposted payment. The payment record exists in the PM_Payment_WORK - PM10300 table.
After a payment is posted the transactions will no longer appear in the PM_Payment_Apply_WORK table.
When a payment and associated invoices are fully applied and posted, it will move to HIST tables - PM_Paid_Transaction_HIST - PM30200 and PM_Apply_To_HIST - PM30300
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (