Sorry it is not a negative balance invoice - I had a negative invoice I was trying to clear it off with.

Hi Esther, can you not just delete the invoice in the Accounts Payable System? Or is the balance owing made up of several invoices and/or corrections?

Can't delete the invoice if it is older than the second past year end. Indication was that it is from two years ago.

you are right Alwyn.....gonna put on my thinking cap.

Esther what happened when you entered a negative invoice on that vendors sub-ledger? and/or how did you enter it? because the credit one should show up when you want to make that payment so it ends up being a zero cheque.

The invoice is dated May 31, 2015 so maybe I could delete it. However, the way it was entered makes me hesitant to do that plus it would effect prior periods. This was a visa entry and instead of paying it through the payments window or even when it was entered the user added a line with a negative amount to a Visa Payable liability account. They entered the incorrect amount, leaving a balance of $49 unpaid. I just don't understand why the system won't let me pay it.

Because the invoice is 2015 if you enter a credit invoice now, todays date or December 31, 2016 it won't affect prior periods, plus when you go to enter payment it should show the credit you entered and the debit. It should then let you put a zero payment against it. This payment again will not affect prior periods. You cannot go back to 2015 to try and fix this. It won't let you. So do everything as the current date. It will give you a message that it is a zero payment and do you want to continue. Answer yes and it should clear for you. It won't affect prior periods in any way. Make sure you have pick payment method of Visa or Whatever card it was so it doesn't touch your bank.

If the prior person did a manual journal entry to try and fix this you might have to do a reverse journal entry to take it out, but again you need to do it as of current date. Then everything should balance out for you.

Okay I just tried and it definitely won't let me adjust or reverse the original invoice. When I make a credit invoice for that amount and try to select both in the payments window I get the same error message. Whenever I click on the payment amount column for this old invoice the error pops up. I have checked data integrity and it is ok.

what if you changed your payment type to cheque. Use a cheque # something like 9999999999999 so it doesn't interfere with your other cheques. I'm wondering if it has something to do with being a Visa Payment. If that doesn't work you may have to phone Sage 50 Support and get them to fix it for you.

Changing the payment type doesn't have any effect. It was never set up as an actual credit card, just a vendor. I tried cash payment and a different bank account but still got the error. I guess I will have to try Sage support. Thanks