问题
关联采购订单生成采购入库单,但采购入库单进入了2次流程,导致连续反写2次入库数量,采购订单的累计入库数量与实际入库数量不符
解决方案
后台脚本更新采购订单分录累计入库数量相关字段;
UPDATE T_SM_PurOrderEntry SET
FTotalReceiptQty=75060,
FTotalReceiptBaseQty=75060,
FTotalUnReceiveQty=14940,
FTotalUnReceiveBaseQty=14940
WHERE fid ='qkwvjbqHSfSUPepZZr5/CiYEHMU='
(FTotalReceiptQty、FTotalReceiptBaseQty这2个字段要减去多入库的数量,其他字段加上多入库的数量)
Add Comment