k3wise订单bom审核提示输入的字符格式不正确原创
7人赞赏了该文章
289次浏览
编辑于2022年05月19日 10:07:18
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
推荐阅读