lockbox status shows 'Applied' but it is not

[sanjivag]

Hi,

I have been facing a problem with AR lockbox. The details are as below.

-  The file format is BAI2

-  In 'OBAY' transaction, the 'partial payment' flag is NOT checked

-  A customer has two open invoices: Invoice # 1 for $100, Invoice # 2 for $100

-  A lockbox payment comes in for $200.

-  First 4 record has invoice # 1, amount $200

- Second 4 record has invoice # 2, amount is $0

When the file is imported using program RFEBLB00, the status shows 'Applied'. But, only invoice # 1 is cleared and remaining $100 is on account.

Since the status is 'Applied', the users think there is no post processing required. The status should show 'Partially applied' . Is it possible by either configuration or user exit?

Thank you in advance.

Sanjiv Agrawal

[former_member186576]

This message was moderated.

[sanjivag]

Sam,

Thanks for the reply.

I found out that there was a custom preprocessor program in my case. The program was dropping the second "4" record since the payment amount was zero. Therefore, the check was applied to first "4" record only. After bringing the second record in, the lockbox program is applying entire payment on account and making the status "On account" correctly.

Sanjiv