By using this website, you agree to our Terms of Use (click here)
How would I join the APInvoice table to the APPayment table?
Hi Jake,
The APAdjust table is needed.
You can join APAdjust to APPayment on APAdjust.AdjgDocType=APPayment.DocType and APAdjust.AdjgRefNbr=APPayment.RefNbr.
You can join APAdjust to APInvoice on APAdjust.AdjdDocType=APInvoice.DocType and APAdjust.AdjdRefNbr=APInvoice.RefNbr.
I like to think of it this way: "Adjg" stands for "adjusting" and "Adjd" stands for "adjusted". Since the payment is the initiating document, it's the "adjusting" document. Since the invoice is the document getting adjusted, it's the "adjusted" document.
Hey Tim,
Does APAdjust have all invoices in it, even before any payments? Or is it APInvoices -> APAdjust -> APPayments? But if there are multiple payments on one invoice, then do we have many-to-many issues (in some or all configurations)? Thanks! Joni
Hey Joni,
I just did a test and it looks like there is no APAdjust record until a Payment has been created and applied to the AP Bill.