Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

GP Manufacturing MO Status not updated

Posted on by 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

  • DavidG Profile Picture
    DavidG 15 on at
    RE: GP Manufacturing MO Status not updated

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

  • Bron Profile Picture
    Bron 4,887 on at
    RE: GP Manufacturing MO Status not updated

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

  • PaulaCam1 Profile Picture
    PaulaCam1 1,005 on at
    RE: GP Manufacturing MO Status not updated

    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

  • Zhigang Lu Profile Picture
    Zhigang Lu 795 on at
    RE: GP Manufacturing MO Status not updated

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

  • Bron Profile Picture
    Bron 4,887 on at
    RE: GP Manufacturing MO Status not updated

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

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,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,104 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans