【问题描述】
专业版总账期末结账提示:定义的应用程序或对象错误
【原因分析】
原因:反结账时系统没有删除当期科目余额数据,再期末结账时就会导致插入重复键。
此问题出现于无补丁或旧版本补丁的专业版16.0。
已修复的补丁版本:PT156472或之后版本补丁。
【解决方案】
可参考以下脚本执行处理:
declare @FCurrentYear int
declare @FCurrentPeriod int
select @FCurrentYear = FValue from t_SystemProfile where FCategory = 'GL' and FKey = 'currentyear'
select @FCurrentPeriod = FValue from t_SystemProfile where FCategory = 'GL' and FKey = 'currentperiod'
delete from t_Balance Where FYear * 100 + FPeriod > @FCurrentYear * 100 + @FCurrentPeriod
delete from t_ProfitAndLoss Where FYear * 100 + FPeriod > @FCurrentYear * 100 + @FCurrentPeriod
delete from t_QuantityBalance Where FYear * 100 + FPeriod > @FCurrentYear * 100 + @FCurrentPeriod
go

