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'