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