3104 的成本金额错误, 成本单价*数量不等于 成本金额
修改办法

修改841800 和 1070 中的 成本金额


--1070
SELECT A.costingmoney FROM bms_sa_dtl A WHERE salesdtlid = 75131748;
--841800
SELECT A.costingmoney ,A.* FROM cqyyprod.srqr_sa_dtl A WHERE  salesdtlid = 75131748;


SELECT A.costingmoney FROM bms_sa_dtl A WHERE salesdtlid = 74954607;
SELECT A.costingmoney ,A.* FROM cqyyprod.srqr_sa_dtl A WHERE  salesdtlid = 74954607;


UPDATE bms_sa_dtl SET costingmoney = '304.12'  WHERE salesdtlid = 74954607;
UPDATE cqyyprod.srqr_sa_dtl SET costingmoney = '304.12'  WHERE salesdtlid = 74954607;

UPDATE bms_sa_dtl SET costingmoney = '3483.19'  WHERE salesdtlid = 75131748;
UPDATE cqyyprod.srqr_sa_dtl SET costingmoney = '3483.19'  WHERE salesdtlid = 75131748;
文档更新时间: 2025-04-01 18:18   作者:admin