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 无效
各位高人请帮忙啊

cderpll

打过最新补丁没？ 要说仔细些？

jackrom

哎，对这个论坛有点失望，没什么高人，我自己已经把问题解决了

nazi8888

在存货管理的总账表中有NULL值，应该是这样的，看一下IA_SUBSIDIARY表记录中是不是有null值