AP Invoice

rwagner · April 9, 2018, 2:13pm

I want to write an AP report that shows both the invoice number and check number but I can’t figure out how I can link the APInvHed and CheckHed tables together.

AndyGHA · April 9, 2018, 3:22pm

Hi, had a quick look, ERP.CheckHed contains the CheckNum, which is linked to APTrans which holds the InvoiceNum

rwagner · April 9, 2018, 6:45pm

Thanks, I was thinking it would be directly related to ApInvHed.