Question Status

Verified
Erica Webb asked a question on 6 Jul 2012 9:13 AM

Hello

I am using GP10.0 and I have a POP invoice that was matched to the correct purchase order however when the invoice was posted, it is sitting in historical instead of open. The invoice was not paid and I need to pay it. I can not apply a credit memo because the orginal invoice is in history and GP will not let me appy it. Can how can I get the invoice to be "open" again so it can get paid?

Any help is appreciated

Erica

Reply
Verified Answer
Richard Wheeler responded on 7 Jul 2012 12:23 PM

If you look at this invoice in history and then  try to zoom back to the payment that was applied to it, do you see anything? If so, just void that payment and the historical invoice will come back to open. Somehow GP thinks it was paid. If that does not work, try voiding the historical document as MaxB suggests and pay attention to the distribution accounts. I would also check your AP TB amount vs the GL AP balance. There may be more to this then just the invoice being on history.

Richard E. Wheeler 2013 and 2014 MVP

Member Microsoft Academic Alliance

www.rbsolutions.com Revered Business Solutions Ballston Lake, NY  518-877-0763 x10

Reply
MaxB responded on 6 Jul 2012 2:29 PM

I don't think there is any way to Open that Invoice from the GP windows. It will require some fixing in SQL tables. You can consider following workaround: Void the historical Invoice in Payables Module and re-enter the Invoice from the Payables Module. It should be tested in test company first.

Reply
Verified Answer
Richard Wheeler responded on 7 Jul 2012 12:23 PM

If you look at this invoice in history and then  try to zoom back to the payment that was applied to it, do you see anything? If so, just void that payment and the historical invoice will come back to open. Somehow GP thinks it was paid. If that does not work, try voiding the historical document as MaxB suggests and pay attention to the distribution accounts. I would also check your AP TB amount vs the GL AP balance. There may be more to this then just the invoice being on history.

Richard E. Wheeler 2013 and 2014 MVP

Member Microsoft Academic Alliance

www.rbsolutions.com Revered Business Solutions Ballston Lake, NY  518-877-0763 x10

Reply
Erica Webb responded on 10 Jul 2012 7:09 AM

GP would not let me void it because it does not recognize that it is open. But I did take a look at the distribution accounts and say that one of my collegues voided the invoice in error. I will re-enter the invoice. Thanks for your help on this.

Reply
Erica Webb responded on 10 Jul 2012 7:15 AM

Sorry- my grammar was horrible. GP would not let me void the invoice because GP does not recognize the invoice as being open. So I took a look at the distribution accounts under the general ledger and I saw that the invoice had been voided. I ran a smartlist to see who voided the invoice and it was one of my collegues. I will re-enter the invoice.- ok that is better grammar. ;-)

Reply