--检查下期间 是否是12期  还是13期 或自定义 以下是按正常12期间执行

UPDATE t_Voucher SET FChecked=0 WHERE FDATE<='2018-12-31'

UPDATE t_Voucher SET FCHECKERID=-1 WHERE FDATE<='2018-12-31'

UPDATE t_Voucher SET FPOSTED=0 WHERE FDATE<='2018-12-31'

UPDATE t_Voucher SET FPosterID=-1 WHERE FDATE<='2018-12-31'

UPDATE t_Voucher SET FInternalInd='NULL' FDATE<='2018-12-31'

UPDATE t_Voucher SET FParameter='NULL' FDATE<='2018-12-31'

DELETE FROM t_Voucher WHERE FDATE<='2018-12-31'

DELETE FROM t_VoucherEntry WHERE FVoucherID NOT IN (select  FVoucherID FROM t_Voucher)

DELETE FROM T_BALANCE WHERE FYear<'2019'

--删除财务数据

UPDATE ICStockBill SET fstatus=0 WHERE FDATE<='2018-12-31'

UPDATE ICStockBill SET FCHECKERID=NULL  WHERE FDATE<='2018-12-31'

UPDATE ICStockBill SET FPOSTED=0 WHERE FDATE<='2018-12-31'

UPDATE ICStockBill SET FPosterID=NULL WHERE FDATE<='2018-12-31'

DELETE FROM ICStockBill WHERE FDATE<='2018-12-31'

DELETE FROM ICBal WHERE FYear<'2019'

DELETE FROM ICINVBal WHERE FYear<'2019'

--删除库存单据

UPDATE ICSale SET fstatus=0 WHERE FDATE<='2018-12-31'

UPDATE ICSale SET FCHECKERID=NULL  WHERE FDATE<='2018-12-31'

UPDATE ICSale SET FPOSTED=0 WHERE FDATE<='2018-12-31'

UPDATE ICSale SET FPosterID=NULL WHERE FDATE<='2018-12-31'

DELETE FROM ICSale WHERE FDATE<='2018-12-31'

--删除销售发票

UPDATE ICPurchase SET fstatus=0 WHERE FDATE<='2018-12-31'

UPDATE ICPurchase SET FCHECKERID=NULL  WHERE FDATE<='2018-12-31'

UPDATE ICPurchase SET FPOSTED=0 WHERE FDATE<='2018-12-31'

UPDATE ICPurchase SET FPosterID=NULL WHERE FDATE<='2018-12-31'

DELETE FROM ICPurchase WHERE FDATE<='2018-12-31'

--删除采购发票

UPDATE T_SYSTEMPROFILE SET FVALUE='2019' WHERE FKEY='StartYear' 

UPDATE T_SYSTEMPROFILE SET FVALUE='1' WHERE FKEY='StartPeriod'

--修改启用期间

--如果提示游标 错误 执行以下语句

close Cur

deallocate Cur