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

[former_member186576]

1.Edit lockbox file and make following two changes.

4001012601 00000000909886340001199000

4001012602900000000909890030001988800

2. SE38- Program name- RFEBKA96 - Execute.

Application-From- 0003- Lockbox To 0003- Lockbox. Execute.

Identify the previously ran file, select and delete it.

3. Run the edited lock box file again and bring a smile on your face.

[former_member186576]

When the bank generated the BAI2 format, through their software, the output might have resulted the way it is indicated in the discussion. However for the lockbox import program to process it correctly, it must appear, like invoice#1-100, invoice #2-100. Is it possible to display the text file portion of only these two payments.Thanks

[sanjivag]

Sam,

The relevant portion of a sample lockbox is as below:

60010120003187800101101154999911    2003137487

4001012601 00000000909886340003187800

4001012602900000000909890030000000000

------------------

Invoice # 90988634  is for $11990.00

Invoice # 90989003  is for $19888.00

Check # 200313748 for $31878.00 is coming in the above lockbox.

After lockbox program is run, the invoice # 90988634 is cleared and a residual item is created for $19888.00. The invoice # 90989003 remains open.Lockbox status is 'Applied'.

Thanks

Sanjiv