The pick list reconcile process can’t continue when manufacturing order records are in use

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.

Cheers!