Skip to Content
0
Former Member
Jul 01, 2009 at 03:04 AM

Customer Receivables Ageing Report

193 Views

Hi experts,

Our SAP version is 2005B PL 43.

The Customer receivable Ageing Report has two tabs- By Journal entries tab and By sales Documents tab.

1. We find that all Payments, Credit notes and Invoices appear in the Customer Ageing Report By Journal Postings.

This happens in case where an invoice has been partly paid alongwith few other invoices which have been fully paid which we are unable to knock off, limitation in this version of SAP.As a result the Incoming payment and The Invoices both are seen as open in the Ageing Report - By jounal Postings whereas the Ageing Report by Sales Documents shows the net values.

There are cases where if an incoming payment is cancelled, the cancelled entry is not knocked off,again a limitation in this version,as a result the Ageing Report by Jounal postings shows both the wrong payment received as well as the cancelled entry.This does not appear in the Ageing Report by Sales documents.

2. The customer Statement Report if printed from the Customer Receivable Ageing Report - By Jounal Postings displays the payment entries alongwith the Credit notes and Invoices, which is very difficult for the customer to understand.

Instead can we use the Ageing Report by Sales Documents to print the Customer Statement Report?

3. Lastly The Ageing Report by Journal Postings can match the Ageing Report by Sales documents only if partly paid invoices, advance payments and cancelled payments are knocked off.

We are currently not planning to upgrade to 2007B as we are waiting for the 8.8 version which will be rolled out in end of Dec, as informed to us by the SAP regional office.

Our question is which settings will give us the correct Ageing for a customer?

Regards,