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
Hi, Can you provide me the script. I am having the same issue and I want to know how to get it fixed.
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............
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
In Manufacturing Order Receipt Entry window, can you reverse this MO receipt?
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.............
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,104 Most Valuable Professional
nmaenpaa 101,156