Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

系统管理——系统设置——系统配置——账套参数——是否勾选了【启用业务与财务独立开账】如果是,查看下面的业务期间和财务期间是否一致,如果不一致结存到一致后再做年结存。

非总账的话,备份数据后,执行下面语句,将年份和期间修改成客户需要的执行:



update MonthProc set StartDate='2022-12-01',period=12,Year=2022 where MonthNo='本期'
update Ac_AccountsPeroid_Stype set FYear=2022,FPeriod=12,SFYear=2022,SFPeriod=12
update SType_UserConfig set SFPeriod=12,SFYear=2022非总账的话,先让客户自己将月结存这里的所有分支机构结存到同一个期间(未开账的除外)。所有分支机构结存期间相同后,然后再执行这个脚本把总账期间改到业务相同的月份,执行时不需要修改语句中的内容

Image Added

UPDATE [a] SET [a].[FYear] = [r].[Year] , [a].[FPeriod] = [r].[period]
FROM [MonthProc] AS r
INNER JOIN [Ac_AccountsPeroid_Stype] AS a ON a.[Stypeid] = [r].[STypeID]
WHERE r.[MonthNo] = '本期' AND [a].[IsUse] = 1
AND ( [r].[Year] <> a.[FYear] OR [r].[period] <> a.[FPeriod] )