用友U8 修改未关联生产订单入库异常数据

生产订单已完成数量修改

SELECT QualifiedInQty,* FROM mom_orderdetail a WHERE a.MoDId ='1000006817'

UPDATE mom_orderdetail SET  QualifiedInQty =20 WHERE MoDId ='1000006817'

产成品入库单主表

SELECT  cMPoCode ,
        cSource ,
        *
FROM    rdrecord10
WHERE    cCode IN ( ''  );

UPDATE  rdrecord10
SET     cMPoCode = '' ,
        cSource = '生产订单'
WHERE   cCode IN ( '' );

产成品入库子表

UPDATE  rdrecords10
SET     isoseq = 1 ,
        csocode = '' ,
        isotype = 1 ,
        isodid = '' ,
        iordertype = 1 ,
        iorderdid = '' ,
        iMPoIds = '' ,
        cmocode = '' ,
        imoseq = 1
WHERE   ID IN ( '' );

SELECT id,imergecheckautoid , isoseq , csocode , isotype , isodid ,  iordertype ,iorderdid , iMPoIds ,cmocode,    imoseq,
         iNQuantity ,iQuantity ,* 
FROM rdrecords10
WHERE   cName = ''
        --AND id = ''