Announcements
We use a third-party software called Willow Ware to create MOs. If the process gets interrupted, I see a status of 9999 in the W7158MOHdr table and the the MO has a status of "Released". In the past, Willow Ware has told us to run the MO Close on these items. However, the past few times accounting has complained about items stuck in finished goods (I've never been sure what they mean by this). How should I be handling these stuck MOs?
Here's what the MO looks like:
Here's what it looks like when I go to MO close:
Here's the message I get when I click Process:
In the past, I've been told to click Yes, but that's when accounting says somethings stuck in finished goods.
----------------------------------------------------------------------------------------------------------------------------
Update - 10/31/22 11:11 a.m.
Here's the picklist I found (Transactions>Manufacturing Orders->Picklist):
You can delete the records out of the MOP1025 for the MO and then run an inventory reconcile to correct the item allocations.
If you have questions regarding doing this, I would suggest you open a support ticket.
Thank you for your reply. Unfortunately, it's mostly Greek to me. I'm a programmer by training (C#, .Net, SQL), so this GP stuff is foreign to me. I wrote a macro to open GP and run the MO Generator so this makes me responsible when the MOs don't go into GP the way they should. I ran the queries you suggested. Script 1 showed me all the items that I know are on the BOM, but the QTY_BACKFLUSHED_I is double the MRPAMOUNT_I. Script 2 produced nothing. For the MOP queries, the 1st and 3rd ones produced nothing, but the 2nd one produced a list of the BOM items; the quantities were equal to MRPAMOUNT_I in the Script 1 results. Not sure what those MOP tables are; does this perhaps mean that the processing got stuck in the MOP1025 table? If so, how do you get it out? Or does that mean something else?
At Mo Close there is a Calculated Option field. It defaults to None if the received to date quantity equals the end quantity, otherwise it defaults from the MO preference Defaults. The choices are None, Start Quantity, or Total Quantity Received. The system calculates the additional component quantity to backflush based on the Calculation Option and the total backflushed to date quantities.
There is a calculation option expansion button ( - opens the MO close backflush quantities window where you can view the items and quantities that are backflushed by the MO Close process. If you do not want the close process to backflush any additional quantity, which would result in a variance you should decrease the picklist required quantity before you close the MO.
The close process backflushes additional components if the Quantity Received-to-date is less than the MO's Ending Quantity, and uses the selected Calculation Option method to calculate the Additional Backflush Quantity.
If the Calculation Option is "Total Quantity Received", a components’ Additional Backflush Quantity equals the Planned Quantity to Backflush minus the Backflushed to Date Quantity.
The Additional Backflush Quantity is set to zero when the calculation would result in a negative value.
If the Calculation option is "None", there are no additional component quantities backflushed.
If the Quantity Received to Date equals the MO Ending Quantity, the close process backflushes additional component quantities if their Backflushed to Date Quantity is less than the Picklist Required Quantity.
If you base the default quantities for the backflushed components on the original start quantity, the transaction to handle backflushing when you close the manufacturing order is based on the theoretical quantity of components per finished item
Based on what your screenshots, change the calculation method of None is selected. That should allow the MO to close without issue as long as nothing is listed in the Backflush Quantities window (click the arrow -> next to Calculation option). To research this issue further can you gather the following for this specific MO:
1. The results of the following scripts:
Script 1:
select LOCNCODE,ITEMNMBR,QTY_BACKFLUSHED_I,MRPAMOUNT_I from PK010033 where MANUFACTUREORDER_I= 'enter your MO number here' and BACKFLUSHITEM_I=1
and QTY_BACKFLUSHED_I <> MRPAMOUNT_I
Script 2:
select * from MOP1110 where QTYPLANNEDTOBACKFLUSH <> QTYTOBACKFLUSH
and MOPRCTNM in (select MOPRCTNM from MOP1100 where MANUFACTUREORDER_I = 'enter the MO number here')
2. I have seen before where a lot had a negative allocation that caused the issue. Could you provide the results of the following to see if this is the case:
select ITEMNMBR,LOTNUMBR,QTYRECVD,QTYSOLD,ATYALLOC from IV00300
where ITEMNMBR in (select ITEMNMBR from PK010033 where MANUFACTUREORDER_I = 'MO0002')
I think we should also verify there are no pending quantities for the MO in the MFG table. Please run the below scripts for this MO.
Select * from MOP1020 where MANUFACTUREORDER_I = 'enter the MO number here'
Select * from MOP1025 where MANUFACTUREORDER_I = 'enter the MO number here'
Select * from MOP1026 where MANUFACTUREORDER_I = 'enter the MO number here'
I don't see anything that obviously looks like an error. I went back and posted the picklist in my original question so you can see it. Can you tell if something is wrong from that?
Does the picklist of the items on the MO show any kind of warnings or errors?
Joe
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156