浪潮ERP软件年结后未核销暂估入库单没有结转过来

浪潮ERP软件年结后未核销暂估入库单没有结转过来

数 据 库： Syb 11.5网
软件版本： 8.0 软件模块： 存货核算
问题描述：
   年结后未核销暂估入库单没有结转过来
产生原因：  
解决方法：
   执行以下SQL结转，注意，一定要在没有做本年入库单据之前执行，否则在执行SQL时可能会提示单据编号重复：
INSERT INTO KCRKD1 SELECT * FROM KCRKD12006 WHERE KCRKD1_PJLX=’G’ AND KCRKD1_LSBH IN (SELECT KCRKD1_LSBH FROM KCRKD12006 WHERE  KCRKD1_PJLX=’G’ AND KCRKD1_CHJZ=’1′ AND KCRKD1_ZGBZ=’1′ AND (KCRKD1_CXBH IS NULL  OR KCRKD1_CXBH=’ ‘  OR DATALENGTH(KCRKD1_CXBH)=0)  AND (KCRKD1_FPHX=’0′)) AND KCRKD1_LSBH NOT IN (SELECT KCRKD1_LSBH FROM KCRKD1)
go
INSERT INTO KCRKD2 SELECT * FROM KCRKD22006 WHERE KCRKD2_PJLX=’G’ AND KCRKD2_LSBH IN (SELECT KCRKD1_LSBH FROM KCRKD1) AND KCRKD2_LSBH NOT IN (SELECT KCRKD2_LSBH FROM KCRKD2)
go

文章的脚注信息由WordPress的wp-posturl插件自动生成