I applied a payment to an invoice, but somehow two payments were applied and now my cash has a negative value of a duplicated payment. I looked at the payments that were applied, but it was two different voucher numbers, 570 and 577.
I drilled into that invoice # and find that indeed two payments were applied, but the weird part is that the 570 payment was an old invoice back from 2011.
What would be the best course of action to get rid of the second payment (570)?
Did you try checklink and Reconciliation?
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.
Frank E. Hamelly, MCP, MCITP, MCT, MVP
@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.
Victoria Yudin - Dynamics GP MVP (2005-2013)
Want to use Crystal Reports or SSRS with Dynamics GP? Check out GP Reports Viewer
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13