web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SO has been removed fr...
Microsoft Dynamics GP (Archived)

SO has been removed from Sales Order Processing

(0) ShareShare
ReportReport
Posted on by Renee Leung 6,775

Hello,

GP was force closed during an SO entry. When GP was launched again, when you try to access the SO, the SO is indicated as posted. We ran Check Links on Sales Work and it removed the SO, which is what we wanted. However, when you drill down to the Inventory Inquiry, the items from the SO are still allocated to the SO.

If Reconcile and Check Links for SOP & Inv do not correct this, how would you fix this in SQL? Which tables would you look into?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Before you resort to SQL, have you used the reconcile utilities? The SQL table holding the allocated amount is the item Quantity Table: IV00102. If you are using multibin, you also need to change the IV00112 table.

  • Renee Leung Profile Picture
    Renee Leung 6,775 on at

    We ran Check Links on Sales Work and then Inventory Trx Work. Then we ran Inventory Reconcile for the specific item and the item still remained allocated to the sales order. We did not run a Reconcile for SOP documents because the sales order had already been removed.

    In Item Inquiry, you can see the sales order that the item is allocated to. But when you try to zoom in on this sales doc., a message appears saying 'SO has been removed'

  • Renee Leung Profile Picture
    Renee Leung 6,775 on at

    Re-ran routines in this order and it worked for this specific SO

    1. checklinks sales work

    2. inventory rec.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans