Unapplied Payments aging incorrectly

[Former Member]

Hello Experts,

One of our Companies has brought a situation to our attention. When they post customer payments, of course, there are times when there will be open balances that are not applied. These balances are posted to the customer's account as a Document Type DZ.

The issue is that these payments are aging, and throwing off the results in the Aging reports.

The configuration seems to be set up correctly in OBA3 that sets the Fixed Payment term to "Z023" which would be correct, rather than having the box checked for Payment Term from Invoice.

However, when I look into BSID, the PayT field (ZTERM) is blank for these open payments.

I need to get the payment terms on the unapplied payments to Z023 to they will not age.

[sanilbhandari]

Hi

The payment terms are applied from OBA3, only if you have residual payments created during cash application. Eg, if you have an invoice of $ 100 and you have a cash application of $ 70, than transaction FBL5N should show only one open item of $ 30. The other customer items of $ 100 and $ 70 should appear as cleared. If however, you are doing partial clearing the payment terms would not be copied from OBA3. You should check on how the items are being cleared during cash application.

Regards

Sanil Bhandari

[Former Member]

Sanil,

Thank you for replying, but how would a $100 invoice be cleared by a $70 payment? The way our AR staff does non-clearing payments is to simply post the entire payment as unapplied.

Is there a way to prevent these open payments from aging?

Thank you again.

[sanilbhandari]

Hi

The payments could be both over and under payments, so my figures were more of arbitary examples. As I mentioned earlier as well, please use Transaction F-32 to perform residual clearing for the customer, if the incoming payments which are not matching are posted as on account payments.

The residual items, which will be created by this clearing will inherit the payment term from configuration of OBA3. if your cash application team is using F-28 or FB05 transaction, than also they would see a similar screen to create a residual transaction, while posting customer payments itself in the system.

Thanks & Regards

Sanil Bhandari