The picklist reconcile process can’t continue when manufacturing order records are in use, error message pops up when inventory reconciliation is done at GP Environment where manufacturing module is installed.
Execute the script against the company data base, locate the manufacturing record which is in use and have it closed.
SELECT * FROM mop10223 WHERE manufactureorder_i IN (SELECT DISTINCT a.manufactureorder_i FROM mop1400 b, wo010032 a WHERE a.manufactureorderst_i <> 8 AND a.manufactureorder_i = b.manufactureorder_i AND b.itemnmbr IN (SELECT DISTINCT itemnmbr FROM pk010033 WHERE ( ppn_i >= '' AND ppn_i <= 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' ) OR ( itemnmbr >= '' AND itemnmbr <= 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' ) AND locncode <> '') AND b.locncode <> '' AND a.manufactureorder_i <> '')
EEYORE :: Don’t bother … delete the record.
Christopher Robin :: Just makes sure all users are out of the system.