解决方案: |
如果非要进行修改的话,可通过如下方法进行调整修改: 1、成本年结后在当前帐套2006年度库中参照执行如下语句修改相应启用参数: update accinformation set cvalue='2006-01-01' where csysid='ca' and len(cvalue)>9 update ufsystem..ua_account_sub set dsubsysused='2006-01-01 00:00:00.000', dsuboridate='2006-01-01 00:00:00.000' where cacc_id=028 and csub_id='CA' AND iyear=9999 update ca_cbsys set bInitLeft=0 2、登陆成本系统进行修改期初数据即可; 3、修改后在当前帐套2006年度库中参照执行如下语句恢复相应启用参数: update accinformation set cvalue='2004-01-01' where csysid='ca' and len(cvalue)>9 update ufsystem..ua_account_sub set dsubsysused='2004-01-01 00:00:00.000', dsuboridate='2004-01-01 00:00:00.000' where cacc_id=028 and csub_id='CA' AND iyear=9999 update ca_cbsys set bInitLeft=1 注意做好数据备份!! |