Unpaid POP invoice posted to history

This question is answered

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

Verified Answer
  • 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

All Replies
  • 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.

  • 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

  • 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.

  • 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. ;-)