T+12.1 会计期间建错

客户建立帐套期间是10月实际是11月,现在想更改成11月.10月没有业务单据只有11月又业务单据。

问题回复：

请备份数据后执行脚本，然后重新启动服务：

use UFTData664804_000001;update SM_Period set begindate=CONVERT(DateTime,'2016-01-01 00:00:00',120),enddate=CONVERT(DateTime,'2016-01-31 00:00:00',120),BizTerminalState=3,FiTerminalState=3 where currentyear ='2016' and currentperiod='1';update SM_Period set begindate=CONVERT(DateTime,'2016-02-01 00:00:00',120),enddate=CONVERT(DateTime,'2016-02-29 00:00:00',120),BizTerminalState=3,FiTerminalState=3 where currentyear ='2016' and currentperiod='2';update SM_Period set begindate=CONVERT(DateTime,'2016-03-01 00:00:00',120),enddate=CONVERT(DateTime,'2016-03-31 00:00:00',120),BizTerminalState=3,FiTerminalState=3 where currentyear ='2016' and currentperiod='3';update SM_Period set begindate=CONVERT(DateTime,'2016-04-01 00:00:00',120),enddate=CONVERT(DateTime,'2016-04-30 00:00:00',120),BizTerminalState=3,FiTerminalState=3 where currentyear ='2016' and currentperiod='4';update SM_Period set begindate=CONVERT(DateTime,'2016-05-01 00:00:00',120),enddate=CONVERT(DateTime,'2016-05-31 00:00:00',120),BizTerminalState=3,FiTerminalState=3 where currentyear ='2016' and currentperiod='5';update SM_Period set begindate=CONVERT(DateTime,'2016-06-01 00:00:00',120),enddate=CONVERT(DateTime,'2016-06-30 00:00:00',120),BizTerminalState=3,FiTerminalState=3 where currentyear ='2016' and currentperiod='6';update SM_Period set begindate=CONVERT(DateTime,'2016-07-01 00:00:00',120),enddate=CONVERT(DateTime,'2016-07-31 00:00:00',120),BizTerminalState=3,FiTerminalState=3 where currentyear ='2016' and currentperiod='7';update SM_Period set begindate=CONVERT(DateTime,'2016-08-01 00:00:00',120),enddate=CONVERT(DateTime,'2016-08-31 00:00:00',120),BizTerminalState=3,FiTerminalState=3 where currentyear ='2016' and currentperiod='8';update SM_Period set begindate=CONVERT(DateTime,'2016-09-01 00:00:00',120),enddate=CONVERT(DateTime,'2016-09-30 00:00:00',120),BizTerminalState=3,FiTerminalState=3 where currentyear ='2016' and currentperiod='9';update SM_Period set begindate=CONVERT(DateTime,'2016-10-01 00:00:00',120),enddate=CONVERT(DateTime,'2016-10-31 00:00:00',120),BizTerminalState=3,FiTerminalState=3 where currentyear ='2016' and currentperiod='10';update SM_Period set begindate=CONVERT(DateTime,'2016-11-01 00:00:00',120),enddate=CONVERT(DateTime,'2016-11-30 00:00:00',120),BizTerminalState=0,FiTerminalState=0 where currentyear ='2016' and currentperiod='11';update SM_Period set begindate=CONVERT(DateTime,'2016-12-01 00:00:00',120),enddate=CONVERT(DateTime,'2016-12-31 00:00:00',120),BizTerminalState=0,FiTerminalState=0 where currentyear ='2016' and currentperiod='12';update EAP_AccInformation set idEnablePeriod=(select id from SM_Period where currentyear ='2016' and currentperiod='11') where OptionType ='1' and idEnablePeriod is not null;update EAP_AccInformation set Value=N'11' where Name=N'EnablePeriod';update UFTSystem..EAP_Account set iDuration=N'11' where DsName=N'UFTData664804_000001';