Customer Aging Report to Include Credit Memos

[Former Member]

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_member583013 · Accepted solution]

Emily,

The Aging Report does include, Credit Memo's. I am not sure where you got this information.

Please let me know

Suda

[Former Member · Accepted solution]

I'm sorry, I wasn't clear. I need the credit memo balance to be displayed in a column. We have large rebates we provide customers as a credit memo and need to track them when assessing credit information. Since we cannot modify the system report I need to create a new one. However the reports I have created only shows outstanding invoices because I do not know how to reference a customer's account instead of pooling it from the customers' invoices. I am thinking it will have to be a crystal report or something, but I was hoping a simple query would do the job.

[former_member583013 · Accepted solution]

The out of the box Aging Report can only display results the way they are and cannot be modified.

If you could share your query I would be able to help you on that

Suda

[Former Member · Accepted solution]

Hi Emily,

The simple query is not available for your goal. Unless you only need a separated Credit Memo Aging report, it will be quite complicated query to bring both Invoice and Credit Memo in different columns.

Thanks,

Gordon

[Former Member · Accepted solution]

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