Notifications
Announcements
No record found.
I'm trying to export AP data from Dynamics SL using SQL. How do I connect the AP voucher with the check? What tables are used? What fields?
Thanks for the help -- Dave
*This post is locked for comments
Dear Dave
I recently had to write some update code for a similar situation. The APDoc table contains CK records (DocType) that link back to a record in APAdjust using the AdjgRefnbr to Refnbr in APDoc. In other words the check number. The voucher refnbr is Adjdrefnbr in APAdjust. I think that is the link you are looking for. Be mindful of the fact that there are other DocTypes in APDoc that can also be checks link HC (Hand checks) and in SL 2011 (EP) electronic payments.
Thanks
Don
Can I add a comment to Don's answer.
In APDoc, RefNbr's for cheque-like documents are not necessarily unique.
They are unique for a given Bank Acct & Sub.
When you are joining from an APDoc cheque to APAdjust, I think you need to join on AdjgRefNbr, AdjgDocType, AdjgBank, AdjgSub.
Barry
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
