Why is Aging Report showing paid Invoice?

[Former Member]

Hi All

I have a paid A/P invoice being shown in vendor liability aging with the balance due is blank. Please see attached screenshots for reference. With this selection criteria, I do not expect this BP to be displayed in the report.

I have tried restore BP balance and even the system reports but do not help.

Please kindly assist. Thank you

SAP version: 8.82 PL 14    

Regards

Yvaine

[kothandaraman_nagarajan]

Check SAP note 800294
- Generating an Aging Report with a past date.

[Former Member]

Thank your for your reply. I checked the journal entry for the reversal, it was on the same date as the initial payment posting date which has been canceled. Is they any other possible cause? Moreover I put the aging date on 31.12.14 which is after the reversal journal date.

[kothandaraman_nagarajan]

Need time to check. For direct communication, please follow under my name, if necessary.

[Former Member]

Hi Nagarajan,

Please find below reconciliation details for your further investigation

1) Initial Payment

2) Cancellation of payment

3) Automatic reversal journal entry

4) Correct payment done

5) Aging cut off date

6) Result

[kothandaraman_nagarajan]

Please share invoice document here. Tks.

[julie_jamieson2]

Try doing an internal reconciliation for the Business partner & ticking the "Display SC only" tick box.

Generally there is a System currency component that needs reconciling

[Former Member]

Hi Julie

You hit the bull's eye. The invoice was displayed only when I ticked “display LC transaction". If i unticked, it wouldn't appear. What does it imply? The LC in the system is USD, SC is SGD, and this invoice is in SGD.

Later I realized the BP currency has a balance in SC amount. So I did the conversion difference. But still it didn't change the aging report, and the internal reconciliation is still showing this invoice.

PS: JE 7062 was the conversion difference I just did. Now my cumulative balance in LC, SC, and FC are all zero.

Also I do not understand why after doing the exchange rate difference in system (JE 7005), the LC amount became zero.

[kothandaraman_nagarajan]

Hi,

Please refer SAP note:

1735957 - Closed Invoices are displayed in Aging reports.

Thanks & Regards,

Nagarajan