Hi, I'm trying to create a report that details payables from Receipt/Invoice to Voucher to Check/Payment but I'm unable to find the link to the check/payment. Please advise which tables and keys to join receipt/invoice/voucher to check/payment. Thank you.
*This post is locked for comments
Thank you! Although what we're trying to accomplish is a bit complex, this really helped to get us started. Appreciate it!
As to the payment, check out a previous post which has a great explanation community.dynamics.com/.../102488
As for the receipt, the POReceipt tabla has an APRefNo and also the APTran table has a RcptNbr. Watch out because there are many-many relations.
#1
André Arnaud de Cal...
291,791
Super User 2024 Season 2
#2
Martin Dráb
230,488
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
