update IA_Subsidiary set iOutCost = 1 Where autoid=(Select Max(Autoid) from IA_Subsidiary Where bRdFlag=0 and cWhCode='2' And cInvCode='hszzg(s)' and not iOutCost is Null and cVouType<>'33')
查找出有问题的语句:成本价格为0为空的
通过事件探查器找到最后一行的
Execute IA_AddSubsidiary '2020-11-30',11,'hszjb','demo','demo',1,0,0,'普通销售','0000006388','32','0000008327',15339,84888,Null,Null,'2020-11-30',Null,Null,'2',Null,Null,Null,Null,Null,Null,Null,Null,Null,0,Null,Null,Null,Null,Null,Null,Null,Null,Null,'21',Null,'00',Null,'hdjsksx',Null,52848,Null,Null,'0203',Null,24.4,12314681833993.8,300478236749449.00,Null,Null,Null,0,Null,Null,Null,Null,'',''
对应的存货编码是什么然后执行上述的update代码进行更新修复
单据类型字段(cvoutype)