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