浪潮ERP软件ps6.x、8.0,年结后未核销的暂估入库单没有结转过来
软件版本: 8.0 软件模块: 年结问题
问题描述:
ps6.x、8.0,年结后未核销的暂估入库单没有结转过来
产生原因:
解决方法:
该问题有补丁,但是已经年结的单据可以通过如下语句进行更正:
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
原创文章,转载请注明: 转载自浪潮888博客
文章的脚注信息由WordPress的wp-posturl插件自动生成