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

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) / GP Manufacturing MO St...
Microsoft Dynamics GP (Archived)

GP Manufacturing MO Status not updated

(0) ShareShare
ReportReport
Posted on by PaulaCam1 1,005

I have an MO Status that is showing as 'released'.  We have received 98 of the 100, so the status should have updated to 'partially received'.  I there some utility (or some function) that I can run to update the MO status?  the system did freeze while receiving this transaction

*This post is locked for comments

I have the same question (0)
  • Bron Profile Picture
    Bron 4 on at

    I have had same situation with a couple of  different clients. In all cases, I had to update the MO Status in  the SQL tables (not just a single table - it's multiple tables).

    Be certain to verify that the GL entry was created for the 98 items that were posted into inventory. In some cases I had to manually update GL in addition to fixing the status.

    Do you or someone on your team have good SQL Skills - Updating tables in a LIVE database is not for the novice or faint of heart............I can probably find the scripts I used if you want me to look......

    Good Luck.............

  • Zhigang Lu Profile Picture
    Zhigang Lu 795 on at

    In Manufacturing Order Receipt Entry window, can you reverse this MO receipt?

  • PaulaCam1 Profile Picture
    PaulaCam1 1,005 on at

    Bron,

    It would be appreciated if you had the script and would pass along.  Not many know all the Mfg tables that I would need to update

  • Bron Profile Picture
    Bron 4 on at

    Before I send scripts - you need to check the MO Variance screen. There is a field on the screen for 'Quantity Received' - in my scenario - the Quantity Received was showing '0' even though I was absolutely certain the system had created and posted a FG Receipt...........

    In my scenario - I had to update status (of MO) and update the quantity received (as displayed on MO Variance) in SQL.

    Please check and then I'll post the scripts I used............  

  • DavidG Profile Picture
    DavidG 15 on at

    Hi, Can you provide me the script. I am having the same issue and I want to know how to get it fixed.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans