[概述]

经检查是单据转换流程中部分字段设置异常,初始化采购发票到付款申请单的单据转换流程中,目标单字段[单据分录.申请付款金额]的源单字段为[产品明细.核销前余额],但问题账套的异常为[产品明细.未核销金额],本币字段也同样异常,可参考执行如下语句更正:

select * into ICClassLinkEntry_180206 from ICClassLinkEntry

go

update ICClassLinkEntry set fsourfkey='FAmountFor3'

where FSourClassTypeID =1000503 and FDestClassTypeID=1000040 and fdestfkey in ('FApplyAmountFor')

update ICClassLinkEntry set fsourfkey='FAmount3'

where FSourClassTypeID =1000503 and FDestClassTypeID=1000040 and fdestfkey in ('FApplyAmount')

go

update icclasstype set fid=fid

go

[概述]

数据库操作有风险,请勿随意执行。