How do I reference an AP Check to the Voucher in a Sql query?

(0) Share

Report

Posted on by Mark Schurmann

I can't believe that I can figure this out.

I need a query of AP Vouchers and their related checks. I am expecting to see a reference in either the APDoc or APTran table of the Check record that references the Voucher RefNbr. ApplyRefNbr seemed like a likely candidate but it always seems to be the same as RefNbr. Clearly some kind of reference exists because the check screen displays the voucher information and I can drill down to the voucher.

What am I missing?

*This post is locked for comments

All responses (2)

Answers (1)

Mark Schurmann 4 on at

Like (0)

Report

RE: How do I reference an AP Check to the Voucher in a Sql query?

That got it. Thanks for the assist.
Verified answer

Mark E 6,451 on at

Like (1)

Report

RE: How do I reference an AP Check to the Voucher in a Sql query?

You have to link in the APAdjust table. The AdjgRefNbr field is the AP Check, the AdjdRefNbr is the Voucher(s) it paid.