Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

I have a sales order showing as open on my smart list even though it has already been invoiced and posted. How do I remove this from the open orders list?

Posted on by 100

I create a smart list once a month showing open orders to make sure nothing is being missed.    I have a sales order that shows up every time as open.  On the order it shows that it needs to invoice 29 chairs (only part of the whole order).  However, it has been invoiced and does link with the master number.  So why is that showing up and what do I need to do to get this corrected.

*This post is locked for comments

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: I have a sales order showing as open on my smart list even though it has already been invoiced and posted. How do I remove this from the open orders list?

    This occurs sometimes when the invoice is posted by one person but another person has the order open.  Unfortunately, sometimes you cannot tell that another person has the invoice "open"  In the SOP Order Entry Window, if you open a transaction then hit SAVE, the screen clears but the document is not released until the window is closed or another transaction is opened.

    If the transaction appears properly in the History tables and a Reconcile does not fix the issue, use SQL to remove the invoice from the SOP10100 and SOP10200 tables by document number.

    Visit our web site and check out Information Flow and Posting and Confessions of an MS Dynamics GP Consultant!

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: I have a sales order showing as open on my smart list even though it has already been invoiced and posted. How do I remove this from the open orders list?

    Karen,

    Have you tried to reconcile this order?  GP | Tools | Utilities | Sales | Reconcile - Remove Sales Documents, select the order number in the From and To and click Process.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans