BOM中无法参照存货档案-用友T3

BOM中无法参照存货档案

微信号：yyrjlls
技术咨询，有偿服务！
复制微信号

原因分析：通过跟踪发现，是执行查询语句select (Inventory.cInvCode) as cInvCode,cInvAddCode,cInvName,cInvStd,(Inventory.cInvCCode) as cInvCCode,(Inventory.dSDate) as dSDate,(Inventory.dEDate) as dEDate from Inventory left join ComputationUnit on ComputationUnit.cComUnitCode=Inventory.cComunitCode where ((cinvcode like '%cm%' OR cinvname like '%cm%' OR cinvaddcode like '%cm%') and (isnull( iPlanPolicy,0)=1 or isnull( iPlanPolicy,0)=0 or isnull( iPlanPolicy,0)=2) and bService = 0 And bInvType = 0 And isnull(dEDate,'2010-11-16 00:00:00.000') >= '2010-11-16 00:00:00.000' And (1=1) ) and (1=1) Order by cInvCode ASC 时不满足条件，存货档案中默认iPlanPolicy值为-1。

问题解答：将所有存货的iPlanPolicy列修改为0或者1或者2。update inventory setiPlanPolicy=1

本文链接：https://www.bbsufida.com/t3/21646.html