on 2015 Aug 03 6:39 PM
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
Request clarification before answering.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
116 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.