| 產品版本: | 1089-T6-企業管理軟件V6.0 | 適用產品: | T6系列 |
| 產品模塊: | 16-存貨核算 | 提交時間: | 2012-06-12 |
| 問題現象: |
年度數據結轉，提示核算結轉失敗，日志錯誤如下： 最后語句：SELECT IA_Subsidiary.cWhCode,'34',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,4) 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.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將 expression 轉換為數據類型 money 時發生算術溢出錯誤。
| ||
| 原因分析: | 因用戶日常操作沒有注意零成本出庫問題，導致移動平均法軟件自動計算的出庫單價過大（超過1億），無法結轉下年。 | ||
| 解決方案: | 在上年度中使用調整單調整結存成本，使單價正常后重新年結。 | ||