浪潮软件物流库存漏记账修改SQL

浪潮软件物流库存漏记账修改SQL

软件模块： 库存管理
问题描述：
   没有记上库存明细帐，存货正确。已经月结
产生原因： 不明
解决方法：
   *查询入库单1中记账标志和流水单号
SELECT * FROM KCRKD1 WHERE KCRKD1_SJDH=’06080229′
*修改记账标志（2选一）
UPDATE KCRKD1 SET KCRKD1_KCJZ=’1′ WHERE KCRKD1_SJDH=’06080229′ AND KCRKD1_PJLX=”
UPDATE KCRKD1 SET KCRKD1_KCJZ=’1′ WHERE KCRKD1_LSBH=”

*查询8月份明细账
SELECT * FROM KCCKYE WHERE KCCKYE_KJQJ=’08′ AND KCCKYE_WLBH=’020638′
SELECT * FROM KCCKYE WHERE KCCKYE_KJQJ=’08′ AND KCCKYE_WLBH=’020639′
SELECT * FROM KCCKYE WHERE KCCKYE_KJQJ=’08′ AND KCCKYE_WLBH=’020641′
*修改8月份的本期借方数量
UPDATE KCCKYE SET KCCKYE_JFSL=’30′ WHERE KCCKYE_KJQJ=’08′ AND KCCKYE_WLBH=’020638′
UPDATE KCCKYE SET KCCKYE_JFSL=’30′ WHERE KCCKYE_KJQJ=’08′ AND KCCKYE_WLBH=’020639′
UPDATE KCCKYE SET KCCKYE_JFSL=’10′ WHERE KCCKYE_KJQJ=’08′ AND KCCKYE_WLBH=’020641′
*修改8月份的借方数量累计
UPDATE KCCKYE SET KCCKYE_JSLJ=” WHERE KCCKYE_KJQJ=’08′ AND KCCKYE_WLBH=’020638′
UPDATE KCCKYE SET KCCKYE_JSLJ=” WHERE KCCKYE_KJQJ=’08′ AND KCCKYE_WLBH=’020639′
UPDATE KCCKYE SET KCCKYE_JSLJ=” WHERE KCCKYE_KJQJ=’08′ AND KCCKYE_WLBH=’020641′
*修改8月份的当前数量余额
UPDATE KCCKYE SET KCCKYE_SLYE=” WHERE KCCKYE_KJQJ=’08′ AND KCCKYE_WLBH=’020638′
UPDATE KCCKYE SET KCCKYE_SLYE=” WHERE KCCKYE_KJQJ=’08′ AND KCCKYE_WLBH=’020639′
UPDATE KCCKYE SET KCCKYE_SLYE=” WHERE KCCKYE_KJQJ=’08′ AND KCCKYE_WLBH=’020641′
*修改9-12月份的借方数量累计=8月份（9月取消记账）
UPDATE KCCKYE SET KCCKYE_JSLJ=” WHERE KCCKYE_KJQJ=’09′ AND KCCKYE_WLBH=’020638′
UPDATE KCCKYE SET KCCKYE_JSLJ=” WHERE KCCKYE_KJQJ=’09′ AND KCCKYE_WLBH=’020639′
UPDATE KCCKYE SET KCCKYE_JSLJ=” WHERE KCCKYE_KJQJ=’09′ AND KCCKYE_WLBH=’020641′
*修改9-12月份的当前数量余额=8月份
UPDATE KCCKYE SET KCCKYE_SLYE=” WHERE KCCKYE_KJQJ=’09′ AND KCCKYE_WLBH=’020638′
UPDATE KCCKYE SET KCCKYE_SLYE=” WHERE KCCKYE_KJQJ=’09′ AND KCCKYE_WLBH=’020639′
UPDATE KCCKYE SET KCCKYE_SLYE=” WHERE KCCKYE_KJQJ=’09′ AND KCCKYE_WLBH=’020641′

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