k3订单bom审核提示输入的字符格式不正确
服务热线：400-665-0027
新购有特价、金蝶老客户升级金蝶云产品可以享受5折优惠，送手机、送话费，好礼不断！
K3wise 15.1
订单bom审核提示输入的字符格式不正确
跟踪数据库
select FDeleted,FName,FNumber from ICOrderBOM t1
Inner Join ICOrderBOMChild t2
ON t1.FInterID = t2.FInterID
And t1.FInterID =1000000917
left Join t_ICItem t3 on t3.FItemID = t2.FItemID
发现这条语句有问题
找到null的行 记住是第几行 然后ICOrderBOMChild表 对应行的物料id查下是否存在 不存在的话删除
select * from ICOrderBOMChild where FInterID =1000000917
select * from ICOrderBOM where FInterID =1000000917
select * from ICOrderBOMChild where fentryid=75152
select * from T_icitem where fitemid= 8729
备份账套后删除有问题的行
delete from ICOrderBOMChild where FInterID =1000000917 and
fentryid=75151