customer aging report - receipts also displayed

[former_member187989]

hi all,

Customer aging report is showing all outstandings &

also receipts from customer,

we want only customer outstanding in intervals of days ?

Jeyakanthan

[K_Pauquet · Accepted solution]

Hi Jeyakanthan,

I take it you are using a version prior to 2007.

When you run your ageing report by journal entries, B1 will show you the full amount as due for all partially paid invoices & also, in another row, the actual partial payment. This is due to the 2 different reconciliation engines. You need to manually reconcile the invoices with the partial payments, then they will no longer appear in the ageing by journal entry.

To determine which payments belong to which invoice, you could run the report by marketing documents. There B1 will show you the remaining outstanding amounts only, from which you can deduct the payment(s) & thence reconcile the correct documents.

As a rule, SAP recommends to only run the ageing reports by journal entry.

If you are looking for more info on reconciliation, please have a look at the IRU landing page:

http://service.sap.com/~sapidb/011000358700000380562007E

All the best,

Kerstin

[former_member187989]

kirsten,

Thanks for your reply.

Problem is we tick marked Payment on account

while doing incoming payments,thats why

customer receipts also appears in customer aging report.

We internally reconcilled invoices.

Jeyakanthan