Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Customer Aging Report to Include Credit Memos

Hi,

I need a customer aging report that will also include credit memos. This is not available with the system report, but when I write a query it will not reference the customer's account but only the documents in the system. How do I create an A/R aging report that includes credit memos off of the account balance?

Thanks!

Emily

Former Member
Former Member replied

Hi, Emily,

I have made such a Crystal report; actually I have 2 versions;

one is purely made in Crystal report: if your credit memos are copied from AR Invoice totally.

another is made with stored procedure and Crystal report, that includes AR Invoice Credit memo, and internal reconciliation.

Which one you need?

Suppose you need the former one, it's easier: just link tables: OINV - INV1 - RIN1;

The join keys: OINV to INV1 is 'Docentry'; INV1 to RIN1 is "inv1.docentry = rin1.baseentry and inv1.linenum = rin1.baseline". and also "Rin1.basetype = '13' and inv1.targettype = '14'.

Hope this helps.

~Michelle

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question