Hello - I am creating a GI to show all payments and documents applied. It seems to working smoothly except for Credit Memos that have been applied by Invoices rather than payments are not appearing. Is there a way to show these as well? Here are the tables and joins:
Best answer by Laura02
View original
+18
Hello,
I recommend starting with ARInvoice table and from there connect to ARAdjust on Doctype = AdjdDocType and RefNbr = AdjdRefNbr.
Once these two tables are connected, you will find that the ArAdjust table contains all kinds of payments in the “adjusting” fields. Fields beginning with ADJG represent payments. Those fields in ARAdjust that begin with ADJD represent invoices or debit memos, the documents that are being paid.
For more examples, joins, details, etc. search the community for aradjust.
HTH,
Laura
Hi Laura - thank you for your help! So the credit memos still do not appear under the adjdRefNbr but I noticed they are under the Payment refNbr instead. This makes sense since the credit memos are essentially the “payment”. In this case, there is no way to see the credit memos under the adjdRefNbr, is there?
+18
Hello,
You are correct when you say the credit memos are like payments. In ARAdjust, credits are included; they are Adjusting reference numbers, field name AdjgRefnbr.
Your GI will include payments and credits that reduce the unpaid balance of the invoices.
Laura
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
