Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Invoices stuck between open/history tables

Posted on by 90

Over past couple weeks, my nightly invoicing has crashed and I needed to restart it.  When I restart the invoice that I left off on before crashing gets stuck between live and history.

It attaches to the order is associates with but remains open in GP.  

Any suggestions to get it to go to history?

Categories:
  • Suggested answer
    Andrea Melroe Profile Picture
    Andrea Melroe 3,437 on at
    RE: Invoices stuck between open/history tables

    Hello,

    It sounds like you experienced a posting interruption of some kind. I’m not sure if you are referring to Sales Order Processing or Purchase Order Processing.

    If you’re referring to Sales Order Processing, we have a good blog one of our engineers wrote that talks about how to troubleshoot SOP documents that have not moved to history as expected:

    How to troubleshoot a Microsoft Dynamics GP Sales Order Processing that did not move to history when it was fully invoiced. - Microsoft Dynamics GP Community

    We don’t have similar blog yet for Purchase Order Processing (if that’s where your problem is).

    All in all though, for us to determine best steps to ensure your data is accurate, we’d have to review how the problem document/data is sitting on the backend. Depending on how the data is sitting, sometimes the answer is to remove the history records so you can re-post. Sometimes, the answer is to remove work records that are stuck, and sometimes specific fields need to update updated as well. I wish there were an easy button for this, but there’s not.

    If your problem is in SOP, I hope you find the blog above helpful!

    While this type of troubleshooting is not something my support team can assist with via forums, we’re happy to assist you with this via a support case Microsoft Dynamics Support.

    Warmest Regards,

    Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP

  • MATTGUO Profile Picture
    MATTGUO 22,306 on at
    RE: Invoices stuck between open/history tables

    Moved to GP forum.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans