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.
rwagner (Rich Wagner) #1
AndyGHA (Andy Wilson) #2
Hi, had a quick look, ERP.CheckHed contains the CheckNum, which is linked to APTrans which holds the InvoiceNum
rwagner (Rich Wagner) #3
Thanks, I was thinking it would be directly related to ApInvHed.