Issues in the aging report

[Former Member]

Dear Experts,

I have a scenario wherein we clear partially a vendor open item with debits or with payments, but system shows both line item as open by which our aging report is not correct.

Can we clear open item to the extent of partial payment and show only the remaining balance as open item and still the baseline date as per original document but for the remaining amount in FBL1N.

Please advice.

Thanks,

Lokesh

[former_member229069 · Accepted solution]

Hello,

As you are using the partial method of clearing, this will show both the items as open. For ageing report to show the outstanding amount you have to develop it manually as per my knowledge.

Thanks

[former_member206852]

Dear Lokesh

Your report will be correct only when you follow the 'Residual' method for partial payments.

Secondly, your remaining open item should also reflect the correct aging..right?

For this, you need to do the below mentioned configuration.

Here for each selected company code and currency combination, you have to do this setting;

This will solve your problem.

Regards

Syed Zia Abbas

[former_member198650]

Hi Lokesh,

If you do partial clearing, system will show both invoice and payment document as open. Better you have to do residual clearing. Here system will clear the invoice & payment document and create a new item for the difference.

Regards,

Mukthar

[ricardo_bellashermida]

Hi,

Please, you could see the note  1758888 - Correction on aging calculation in AR/AP report.

Regards,

[sanilbhandari]

Hi

If you perform the residual clearing rather than partial clearing, the new item created will derive the baseline date from the original item.

regards

sanil