T6存货核算年结时出错

jackrom

T6 年结
-----------------------------------------------------------------
错误提示为：
时间：2015-01-28--21:18:53
帐套：101
年度：2015
程序名： clsCHTonextYear: TurnOver : AccSummary1
模块：存货管理-总帐数据
最后语句：SELECT IA_Subsidiary.cWhCode,'34',IA_Subsidiary.cDepCode,IA_Subsidiary.cInvCode,IA_Subsidiary.cInvHead,1 as PZID,cfree1,cfree2,cfree3,cfree4,cfree5,cfree6,cfree7,cfree8,cfree9,cfree10, cast(str(Sum(IsNull(IA_Subsidiary.iAInQuantity,0)-IsNull(IA_Subsidiary.iAOutQuantity,0)),20,3) as float) AS SumQ,  Sum(ISNULL(IA_Subsidiary.iAInPrice,0)-ISNULL(IA_Subsidiary.iAOutPrice,0)) AS SumM  FROM (IA_Subsidiary inner join warehouse on IA_Subsidiary.cwhcode=warehouse.cwhcode) WHERE Warehouse.cWhvaluestyle<>'个别计价法' and Warehouse.cWhvaluestyle<>'先进先出法' and Warehouse.cWhvaluestyle<>'后进先出法' And (IA_Subsidiary.iMonth>0 or (IA_Subsidiary.iMonth=0 and IA_Subsidiary.cVouType='34'))  GROUP BY IA_Subsidiary.cWhCode,IA_Subsidiary.cDepCode,IA_Subsidiary.cInvCode,IA_Subsidiary.cInvHead,cfree1,cfree2,cfree3,cfree4,cfree5,cfree6,cfree7,cfree8,cfree9,cfree10 having Sum(IsNull(IA_Subsidiary.iAInQuantity,0)-IsNull(IA_Subsidiary.iAOutQuantity,0))<>0 or  Sum(ISNULL(IA_Subsidiary.iAInPrice,0)-ISNULL(IA_Subsidiary.iAOutPrice,0))<>0
错误信息： 使用 Null 无效
各位高人请帮忙啊

nazi8888

进SUBSIDIARY这个表看一下是不是有NULL空值的