【问题描述】

旗舰版采购入库（或委外入库）下推发票后供应商显示异常，保存报错：“单据未能正确保存，原因如下：数据传递到应收应付系统有误”？

【原因分析】

原因为关系表 ICSelbills 数据异常导致。

【解决方案】

可参考以下脚本执行处理：

delete from ICSelbills where FID='I02' AND FFieldName='FInStockInterID' and FColName = 'FSettleDate' and FSelType = 2 and FDK = 0

insert into ICSelbills (FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias,FAction,FROB,FAllowEdited)

values('I02','FInStockInterID','FSettleDate',2,0,'FSettleDate','FSettleDate','ICStockBill','v1','',0,0)

GO

delete from ICSelbills where FID='I03' AND FFieldName='FInStockInterID' and FColName = 'FSettleDate' and FSelType = 2 and FDK = 0

insert into ICSelbills (FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias,FAction,FROB,FAllowEdited)

values('I03','FInStockInterID','FSettleDate',2,0,'FSettleDate','FSettleDate','ICStockBill','v1','',0,0)

GO

delete from ICSelbills where FID='I02' AND FFieldName='FWWInStockInterID' and FColName = 'FSettleDate' and FSelType = 2 and FDK = 0

insert into ICSelbills (FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias,FAction,FROB,FAllowEdited)

values('I02','FWWInStockInterID','FSettleDate',2,0,'FSettleDate','FSettleDate','ICStockBill','v1','',0,0)

GO

delete from ICSelbills where FID='I03' AND FFieldName='FWWInStockInterID' and FColName = 'FSettleDate' and FSelType = 2 and FDK = 0

insert into ICSelbills (FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias,FAction,FROB,FAllowEdited)

values('I03','FWWInStockInterID','FSettleDate',2,0,'FSettleDate','FSettleDate','ICStockBill','v1','',0,0)

GO

【注意事项】

正式账套执行脚本前请先做好备份，建议待在测试账套中核实无误后再在正式账套中执行。