旗舰版4.0,自制入库核算出现问题
金蝶云社区-麦加66
麦加66
0人赞赏了该文章 648次浏览 未经作者许可,禁止转载编辑于2016年09月02日 22:42:40

旗舰版4.0,自制入库核算默认过滤条件 填入单价 核算成功
如果按照[u]部门过滤[/u]条件查询 然后填入价格再核算就会出现错误,错误如下:名称或代码在系统中已经使用
错误代码:3604
microsoft ole db provider for sql server Detail 附近有语法错误

数据库跟踪后的一部分语句
t1.FItemID=t2.FItemID and t3.FItemID=t1.FUnitID AND (Case WHEN t2.FTrack=80 or t2.FTrack=20308 Or t2.FTrack=20309 THEN t1.FBatchNo ELSE '' END)='' AND t1.FInterID IN ( SELECT FInterID FROM ICStockBill WHERE FTranType = 2 AND FDeptID= AND FDate>='2016/08/01' AND FDate<'2016/09/01' AND (FVchInterID=0 or FVchInterID is null) AND FStatus>0 AND FCancellation=0)
go
select * from UPDATE t1 SET t1.FPrice=,t1.FAmount= t1.FQty * , t1.FAuxPrice=*(isnull(t3.FCoefficient,1)+isnull(t3.FScale,0)) FROM ICStockBillEntry t1,t_ICItem t2,t_MeasureUnit t3 WHERE t1.FItemID= AND t1.FItemID=t2.FItemID and t3.FItemID=t1.FUnitID AND (Case WHEN t2.FTrack=80 or t2.FTrack=20308 Or t2.FTrack=20309 THEN t1.FBatchNo ELSE '' END)='' AND t1.FInterID IN ( SELECT FInterID FROM ICStockBill WHERE FTranType = 2 AND FDeptID= AND FDate>='2016/08/01' AND FDate<'2016/09/01' AND (FVchInterID=0 or FVchInterID is null) AND FStatus>0 AND FCancellation=0)
go
IF @@TRANCOUNT > 0 ROLLBACK TRAN
go

麻烦给看一下 这个问题如何解决!万分感谢!

111111.png(9.77KB)