Lockbox error: Difference too large to clear F5 263

[Former Member]

Hello

I am stuck with yet another lockbox problem. The payment is posting on account due to error F5 263 (Difference too large to clear). Here are the checks already performed:

OBA3= Tolerance is set to 99 days.

OBA4= The group is blank so I understand this to be applicable to all users

Payment terms for the customer allows 2% discount.

All incoming invoice payments are eligible for 2% (based on Inv date) and the payment amount reflects the discount for most of the invoices

The file also contains deductions, some invoices which were already cleared and some invoice #s that don't exist in SAP. None of these should be the reason for the file to fail, it should apply payments for legit invoices and post the docs they can't find on the customer account as credits. There are a few customer credit memos in the file as well and not sure if that could be issue but when I tested same scenario in Quality everything posted fine. This incident is isolated to Production and we are not being able to replicate it. This impacts year end. Anyone have any ideas?

Note: The BAI2 file is manually loaded through a "preprocessor" program which internally calls FLB2 for the actual load. There is no direct transmission with the bank.

[Former Member]

This is a clearing related tolerence issue, i have faced the same problem in past, but after finding the difference in payment you should maintain the tolerence levels appropriately or should not maintain tolerence to allow any amount of partial postings,

Check your business process weather they like to post partial payments which keeps the original line item open or they like residual posting which clears the original line item and post a new balance line item.

Please mark points if helpful.

[Former Member]

Thanks Pankaj. As mentioned in my original post itself, the tolerance is set for 99 days up to 10% or $25. Tolerance for employees if open for all. The customer is eligible for 2% discount (based on the invoice dates) and the payment difference in the file Vs open item amount in SAP is exactly 2% (or less for some). So I don't think it has to do anything with the tolerance levels. I have checked all the obvious things, file format, tolerance for customer, tolerance for users, payment terms, account assignment for cash discount.

I saw a couple of notes available for "wrong error messages in FLB2", however since I have not been able to replicate this at all in test environments, I am not sure if the notes are going to be any help. This is a high priority issue now due to its impact on year end. Any ideas?

[former_member221187]

Hi,

This links useful you,

https://scn.sap.com/thread/869080

https://scn.sap.com/thread/943413

Thanks,

G Rajendhar.

[Former Member]

Thanks. I had already checked all available threads on SCN prior to creating mine. None of those apply as all the tolerances are set correctly, the customer number is correct.