AP Invoice

(Rich Wagner) #1

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.

(Andy Wilson) #2

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

(Rich Wagner) #3

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