在金蝶采购合同金额明细表中付款单号与开票号一致
添加时间:2022-6-2
估计是生成过付款单,但删除了,而关联信息又没有删除完整。找出不为0的那条信息,把相应字段修改成0就行了。(如果重新付款了,就查找与实际核销金额不一致的信息)
SELECT FCheckStatus,FChildren,FUnReceiveAmountFor,FUnReceiveAmount,FReceiveAmountFor,FReceiveAmount,* FROM dbo.ICSale WHERE FBillNo='销售发票单号'
(FCheckStatus,核销状态,0-未核销,1-部分核销,2-完全核销;
FUnReceiveAmountFor,原币未核销金额;FReceiveAmountFor,原币核销金额;
FUnReceiveAmount,本币未核销金额;FReceiveAmount,本币核销金额)