If you have unexplained allocations from Manufacturing, the first thing you need to do is run an Inventory Reconcile.

If this does not correct the issue, establish the status of the MO in Manufacture Order Entry. If it I closed, there should be no allocations, if it is completed or any other status, it can have valid allocations.

If it is closed or if you are unsure of the MO number, remove all the records for closed MOs by running the below scripts and then you will need to run an Inventory reconcile.

DELETE MOP1400 where manufactureorder_i in (select manufactureorder_i from wo010032 where manufactureorderst_i=8)
DELETE MOP1410 where manufactureorder_i in (select manufactureorder_i from wo010032 where manufactureorderst_i=8)
DELETE MOP1000 where manufactureorder_i in (select manufactureorder_i from wo010032 where manufactureorderst_i=8)
DELETE MOP1020 where manufactureorder_i in (select manufactureorder_i from wo010032 where manufactureorderst_i=8)
DELETE MOP1025 where manufactureorder_i in (select manufactureorder_i from wo010032 where manufactureorderst_i=8)
DELETE MOP1026 where manufactureorder_i in (select manufactureorder_i from wo010032 where manufactureorderst_i=8)

If it is any other status other than closed. Run the allocation script and see if there is a pending document that has not been posted. Remove the items from the documents within GP. This should give you the offending MO number.

Run the below script to see if these are any pending documents for the MO.
Select PICKNUMBER from MOP1210 where MANUFACTUREORDER_I = 'XXXX'
and MANUFACTUREORDER_I in (select MANUFACTUREORDER_I from MOP1400
where MANUFACTUREORDER_I in (select MANUFACTUREORDER_I where PENDING_REV_ISS_QTY_I > 0
or PENDING_ISSUE_QTY_I > 0 or PENDING_SCRAP_QTY_I > 0 or PENDING_REV_SCRAP_QTY_I > 0))
and TRX_TYPE in (1,2,5,6) and PICKNUMBER in (select PICKNUMBER from MOP1200 where POSTED = 0)

Note In this script, you must replace the XXXX placeholder with the manufacturing order number.
If this script returns results, post the document, or remove the item from the document.

If this script does not return results, run the below scripts and run the Inventory Reconcile.
Update MOP1400 set PENDING_ISSUE_QTY_I = 0 where MANUFACTUREORDER_I = 'XXXX' and PENDING_ISSUE_QTY_I > 0 
Update MOP1400 set PENDING_REV_ISS_QTY_I = 0 where MANUFACTUREORDER_I = 'XXXX'  and PENDING_REV_ISS_QTY_I > 0
Update MOP1400 set PENDING_SCRAP_QTY_I = 0 where MANUFACTUREORDER_I = 'XXXX' and PENDING_SCRAP_QTY_I > 0
Update MOP1400 set ATYALLOC= 0 where MANUFACTUREORDER_I = 'XXXX' and ATYALLOC > 0
If there are records in the MOP1020, MOP1025, MOP1001, or MOP1026 without any other pending documents from step 3, delete the records from these tables and run a reconcile.
Select * from MOP1020 where itemnmbr=’enter your item number’
select * from MOP1025 where itemnmbr=’enter your item number’
select * from MOP1025 where itemnmbr=’enter your item number’
Delete MOP1020 where itemnmbr=’enter your item number’
Delete MOP1025 where itemnmbr=’enter your item number’
Delete MOP1025 where itemnmbr=’enter your item number’
If this does not correct your issue, contact the support desk.