Lockbox BAI2 duplicate invoice

[Former Member]

Lockbox is currently configured for partial payments. The partial payment checkbox is ticked in OBAY. However, the problem is that when the customer is making a short payment on an invoice, Example $500 invoice. In record 4 invoice number 90123456 payment amount $500. They are then sending another record 4 with same invoice number 90123456 with a payment amount of -$100. This is causing the original invoice to be cleared and leaving an outstanding balance of 100.00 on the customer account. The business would like to keep the original invoice open. Kindly offer any suggestions

Example:

6001001000058710001112223330054320000077777

400100111 090123456 00000500000000000000GH

400100121 090123456 -0000100000000000000GH

Thanks.

madman

[Former Member]

Hi Prithwi -

These record 4s are for the same invoice. It is a 400.00 payment on a 500.00 invoice.

But because the customer/bank is sending us the fle in the following manner, the first record 4 is a 500.00 payment on a 500.00 invoice, the 2nd record 4 is a 100.00 credit on the same invoice. This is causing the original invoice and payment to be cleared and it creates a new open item of 100.00.

6001001000004000001112223330054320000077777

400100111 090123456 00000500000000000000GH

400100121 090123456 -0000100000000000000GH

Thanks

madman

[Former Member]

In this situation 500.00 invoice is cleared and there is a remaining 100.00 debit on the customer account as an open item.

6001001000058710001112223330054320000077777

400100111 090123456 00000500000000000000GH

400100121 090123456 -0000100000000000000GH

However, in this situation the payment for 400.00 is applied to customer account and both the invoice and customer payment remain open. This is what the business would like. Both invoice and payment to remain open.

6001001000058710001112223330054320000077777

400100111 090123456 00000400000000000000GH

The customer and bank can not change they way they are sending the file. What do you recommend?

Thanks,

madman

[Former Member]

Hi ,

Why the first invoice $500 and the second invoice is -$100. This is causing the squaring off and showing the net balance of $400.

Thanks,

Prithwi.