I am trying to create a BAQ which shows what invoices are paid on which cheque number.
I have successfully pulled in Invoice Date, amount, dates but there is no field that references which payment it is posted on.
Try joining APTran table to APInvHead; in the APTran table, there is a field called CheckNum
Amazing - worked like a charm. Thank you!!
1 Like