科目修改核算维度后报错
金蝶云社区-广西尚贤李勇
广西尚贤李勇
0人赞赏了该文章 705次浏览 未经作者许可,禁止转载编辑于2015年11月09日 17:32:02

cloud5+10月15日补丁
对科目2202.01 暂估应付款,已经生成过凭证,
添加核算维度,供应商、费用项目,都是必录,保存。
删除已经生成的凭证,将核算维度的供应商、费用项目的必须修改为可选,保存后报错!

发生时间: 2015-11-09 05:23:36
错误编号: BOS_ExecuteNonQuery
错误信息: 违反了 PRIMARY KEY 约束“PK_GL_BALANCE_101202”。不能在对象“dbo.T_GL_BALANCE_101202”中插入重复键。重复键值为 (101202, 2015, 1, 4098, 1, 0, 0)。
语句已终止。
Sql语句: IF EXISTS (SELECT 1 FROM T_GL_BALANCE_101202 WHERE (FACCOUNTID = 4098 AND FDETAILID = 0))
BEGIN
INSERT INTO T_GL_BALANCE_101202 (FACCOUNTBOOKID, FYEAR, FPERIOD, FACCOUNTID, FDETAILID, FCURRENCYID, FBEGINBALANCEFOR, FBEGINBALANCE, FDEBITFOR, FDEBIT, FCREDITFOR, FCREDIT, FYTDDEBITFOR, FYTDDEBIT, FYTDCREDITFOR, FYTDCREDIT, FENDBALANCEFOR, FENDBALANCE, FADJUSTPERIOD) SELECT FACCOUNTBOOKID, FYEAR, FPERIOD, FACCOUNTID, 1 fdetailid, FCURRENCYID, FBEGINBALANCEFOR, FBEGINBALANCE, FDEBITFOR, FDEBIT, FCREDITFOR, FCREDIT, FYTDDEBITFOR, FYTDDEBIT, FYTDCREDITFOR, FYTDCREDIT, FENDBALANCEFOR, FENDBALANCE, FADJUSTPERIOD FROM T_GL_BALANCE_101202 WHERE (FACCOUNTID = 4098 AND FDETAILID = 0)
END
===================================================
调用堆栈:
Server stack trace:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.ExecuteBatch(Context ctx, List`1 lstSqlObj)
at Kingdee.K3.BD.App.Common.ServicePlugIn.Account.Save.UpdateAcctFlexItemData(DynamicObject[] dyObjs)
at Kingdee.K3.BD.App.Common.ServicePlugIn.Account.Save.EndOperationTransaction(EndOperationTransactionArgs e)
at Kingdee.BOS.App.Core.PlugInProxy.OperationServicePlugInProxy.FireEndOperationTransaction(EndOperationTransactionArgs e)
at Kingdee.BOS.App.Core.AbstractOprerationService.CallOperation(DynamicObject[]& objs)
at Kingdee.BOS.App.Core.AbstractOprerationService.CallOperatinTransaction(DynamicObject[] objs)
at Kingdee.BOS.App.Core.AbstractOprerationService.DoExcete()
at Kingdee.BOS.App.Core.AbstractOprerationService.Excute(DynamicObject[] dataEntities)
at Kingdee.BOS.App.Core.SaveService.Save(Context ctx, BusinessInfo info, DynamicObject[] dataEntities, OperateOption option, String operationNumber)
Exception rethrown at [0]:
at Kingdee.BOS.ServiceHelper.BusinessDataServiceHelper.Save(Context ctx, BusinessInfo businessInfo, DynamicObject dataObject, OperateOption option, String operationNumber)
at Kingdee.BOS.Model.Bill.BillModel.Save(OperateOption option)
at Kingdee.BOS.Business.Bill.Operation.Save.ExecuteBillOperation(OperateOption option)
at Kingdee.BOS.Core.DynamicForm.AbstractDynamicFormOperation.Operation(CallBackWfAfterOperation callbackwf, IOperationResult result)

您的鼓励与嘉奖将成为创作者们前进的动力,如果觉得本文还不错,可以给予作者创作打赏哦!

请选择打赏金币数 *

10金币20金币30金币40金币50金币60金币
可用金币: 0