You’re offline. This is a read only version of the page.
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
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............
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.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,104
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (