Page History

...

非总账的话，先让客户自己将月结存这里的所有分支机构结存到同一个期间（未开账的除外）。所有分支机构结存期间相同后，然后再执行这个脚本把总账期间改到业务相同的月份，执行时不需要修改语句中的内容

Image RemovedImage 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] )