精細(xì)管理 · 敏捷經(jīng)營 · 快速應(yīng)用
規(guī)范流程 · 提升效益
規(guī)范管理 · 精細(xì)理財(cái)
| 產(chǎn)品版本: | 1089-T6-企業(yè)管理軟件V6.0 | 適用產(chǎn)品: | T6系列 |
| 產(chǎn)品模塊: | 16-存貨核算 | 提交時(shí)間: | 2012-06-12 |
| 問題現(xiàn)象: |
年度數(shù)據(jù)結(jié)轉(zhuǎn)，提示核算結(jié)轉(zhuǎn)失敗，日志錯(cuò)誤如下： 最后語句：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<>'個(gè)別計(jì)價(jià)法' and Warehouse.cWhvaluestyle<>'先進(jìn)先出法' and Warehouse.cWhvaluestyle<>'后進(jìn)先出法' 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 轉(zhuǎn)換為數(shù)據(jù)類型 money 時(shí)發(fā)生算術(shù)溢出錯(cuò)誤。
| ||
| 原因分析: | 因用戶日常操作沒有注意零成本出庫問題，導(dǎo)致移動(dòng)平均法軟件自動(dòng)計(jì)算的出庫單價(jià)過大（超過1億），無法結(jié)轉(zhuǎn)下年。 | ||
| 解決方案: | 在上年度中使用調(diào)整單調(diào)整結(jié)存成本，使單價(jià)正常后重新年結(jié)。 | ||