问题

关联采购订单生成采购入库单,但采购入库单进入了2次流程,导致连续反写2次入库数量,采购订单的累计入库数量与实际入库数量不符

解决方案

后台脚本更新采购订单分录累计入库数量相关字段;

UPDATE T_SM_PurOrderEntry SET

FTotalReceiptQty=75060,

FTotalReceiptBaseQty=75060,

FTotalUnReceiveQty=14940,

FTotalUnReceiveBaseQty=14940  

WHERE  fid ='qkwvjbqHSfSUPepZZr5/CiYEHMU='

(FTotalReceiptQty、FTotalReceiptBaseQty这2个字段要减去多入库的数量,其他字段加上多入库的数量)

相关的文章



0 Comments

You are not logged in. Any changes you make will be marked as anonymous.