Old invoice posted as payment voucher

Did you try checklink and Reconciliation?

Thanks

Sandip

Can you void the second payment?  If you can, that would be the best course of action, then re-enter the payment and apply it to the correct invoice.

@Sandip Yes, I ran checklinks and a reconciliation, multiple times but no luck.

@Frank I can't void the 570 payment because GP doesn't think it is a payment. On the 2nd picture I attached if you look at the 570 document it is listed as an invoice. I suspect it has to do something with the voucher numbering.

Would voiding the invoice altogether be a good idea? Or would I have a 447k deficit in my cash account due to that 570 "payment".

Yes, I see that but in the Apply window it has a Payment Doc Type. That's why I thought you might be able to void the 'payment'. It appears something really messed this transaction up. You might have to open a support case with MSFT on this one.

I agree with Frank, you will want to work with either MS Support or your GP Partner to look at the data in your tables. It sounds to me like one of these 'payments' is not actually a transaction in GP and is just a phantom apply record. However, before recommending a fix, I would want to check all the data in the related tables to make sure.

As a separate note to clarify something in this thread - a payables voucher number does not have to be unique in GP - it is possible to have 2 different transactions with the same voucher number. The voucher number AND control type together must be unique. Control type 0 includes invoice, finance charge and misc charge. Control type 1 includes return, credit memo and payment. So you could have an invoice (control type 0) with a voucher number 570 and a payment (control type 1) with a voucher number of 570.