固定资产计提折旧报错,怎么处理,急!!!
金蝶云社区-全能用户@呱呱洗车(北京)有限公司
全能用户@呱呱洗车(北京)有限公司
0人赞赏了该文章 815次浏览 未经作者许可,禁止转载编辑于2016年02月01日 20:57:01

5.0+ PT102061
计提固定资产折旧报错:
不能将值 NULL 插入列 'FSHOULDDEPR',表 'tempdb.dbo.#TM_FA_ASSERTDEPRENTRY______________________________________________________________________________________________00000001CCD4';列不允许有 Null 值。UPDATE 失败。
语句已终止。
[{"operation":"FA_DEPR.BClick.FDEPR."}]
发生时间: 2016-02-01 08:52:37
错误编号: BOS_ExecuteNonQuery
错误信息: 不能将值 NULL 插入列 'FSHOULDDEPR',表 'tempdb.dbo.#TM_FA_ASSERTDEPRENTRY______________________________________________________________________________________________00000001CCD4';列不允许有 Null 值。UPDATE 失败。
语句已终止。
Sql语句: UPDATE M SET M.FCardDepr = CASE WHEN (L.FAssetCurStatus >= '3') THEN ISNULL(D.FDisposeDepr, 0) ELSE L.FDepr END, M.FShouldDepr = CASE WHEN (L.FAssetCurStatus >= '3') THEN (CASE L.FCLEARDEPRPOLICY WHEN 1 THEN 0 WHEN 4 THEN 0 ELSE (((ISNULL(L.FDepr, 0) * E.FDisposeqty) / E.fquantity) + ISNULL(D.FMANUALDEPR, 0)) END + ISNULL(D.FDisposeDepr, 0)) ELSE L.FShouldDepr END, M.FDisposeDepr = CASE WHEN (L.FAssetCurStatus >= '3') THEN (CASE L.FCLEARDEPRPOLICY WHEN 1 THEN 0 WHEN 4 THEN 0 ELSE (((ISNULL(L.FDepr, 0) * E.FDisposeqty) / E.fquantity) + ISNULL(D.FMANUALDEPR, 0)) END + ISNULL(D.FDisposeDepr, 0)) ELSE L.FDepr END, M.FMANUALDEPR = ISNULL(D.FMANUALDEPR, 0), M.FDepr = CASE WHEN (L.FAssetCurStatus >= '3') THEN (CASE L.FCLEARDEPRPOLICY WHEN 1 THEN 0 WHEN 4 THEN 0 ELSE (((ISNULL(L.FDepr, 0) * E.FDisposeqty) / E.fquantity) + ISNULL(D.FMANUALDEPR, 0)) END + ISNULL(D.FDisposeDepr, 0)) ELSE L.FDepr END, M.FFORMULACONTENT = CASE WHEN (L.FAssetCurStatus >= '3') THEN (((((CONVERT(VARCHAR(8000), '处置单折旧:') + CASE L.FCLEARDEPRPOLICY WHEN 1 THEN '0.00' WHEN 4 THEN '0.00' ELSE (((((CONVERT(VARCHAR(8000), '本期计提折旧额') + LTRIM(RTRIM(STR(ISNULL(L.FDepr, 0), 38, 2)))) + CONVERT(VARCHAR(8000), '*处置数量')) + LTRIM(RTRIM(STR(E.FDisposeqty, 38, 2)))) + CONVERT(VARCHAR(8000), '/总数量')) + LTRIM(RTRIM(STR(E.fquantity, 38, 2)))) END) + CONVERT(VARCHAR(8000), '+手工调整折旧额')) + LTRIM(RTRIM(STR(ISNULL(D.FMANUALDEPR, 0), 38, 2)))) + CONVERT(VARCHAR(8000), '+卡片折旧:剩余卡片承担折旧额')) + LTRIM(RTRIM(STR(ISNULL(D.FDisposeDepr, 0), 38, 2)))) ELSE CONVERT(VARCHAR(8000), L.FFORMULACONTENT) END FROM #TM_FA_ASSERTDEPRENTRY M, #TM_FA_ASSERTDEPRENTRY L INNER JOIN t_fa_card C ON C.Falterid = L.FAlterID LEFT OUTER JOIN T_FA_DISPOSALENTRY E ON ((E.FAlterID = L.FAlterID AND C.FIsNewRec = '0') OR (E.FNewAlterID = L.FALterID AND C.FIsNewRec = '2')) LEFT OUTER JOIN T_FA_DISENTRYDETAIL D ON (D.FEntryID = E.FEntryID AND D.FPolicyID = L.FACCTPOLICYID) WHERE ((M.FTempEntryID = L.FTempEntryID AND L.FYear = L.FCurrentYear) AND L.FPeriod = L.FCurrentPeriod)
===================================================
调用堆栈:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteBatch(Context ctx, List`1 lstSqlObj)
在 Kingdee.K3.FIN.FA.App.Core.DeprAdjustService.InsertDeprAdjustEntry(String tempTableName, DataRow dr, Int64 FID, String tempLastAdjustEntry)
在 Kingdee.K3.FIN.FA.App.Core.DeprAdjustService.BuildDeprAdjust(String tempTableName, Boolean bIsSave)
在 Kingdee.K3.FIN.FA.App.Core.AssetDeprService.BuildDeprAdjust(Context ctx, String tempTableName, Boolean bIsSave)
在 Kingdee.K3.FIN.FA.App.Core.AssetDeprService.AssetDepr(Context ctx, List`1 lst, Dictionary`2 dParam)
在 Kingdee.K3.FIN.FA.ServiceHelper.AssetDeprServiceHelper.AssetDepr(Context ctx, List`1 lst, Dictionary`2 dParam)
在 Kingdee.K3.FIN.FA.Business.PlugIn.AssetDepr.AssetDeprMain()
在 Kingdee.K3.FIN.FA.Business.PlugIn.AssetDepr.ButtonClick(ButtonClickEventArgs e)
在 Kingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormViewPlugInProxy.FireButtonClick(ButtonClickEventArgs e)
在 Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.ButtonClick(String key, String menuKey)
在 Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.ButtonClick(String buttonKey, String menuKey, JSONArray postDatas)