| 解决方案： |
先恢复的八月份的记账，然后再执行/*调整7月份的5101明细库出错数据*/
UPDATE GL_accass
SET me=0,md=mc
WHERE (ccode LIKE '5101') AND (iperiod = '7')
/*更新5101明细库出错数据*/
UPDATE GL_accass
SET mb=0,me=0
WHERE (ccode LIKE '5101') AND (iperiod = '8') 第三步：记帐，把8月全部凭证记帐
/*备份明细库*/
SELECT * into gl_accassbak2 FROM GL_accass
/*更新510203明细库出错数据*/
update gl_accass set me=0,mb=0 where ccode='510203' and (cdept_id = '0302010201')
update gl_accass set md=mc where ccode='510203' and (cdept_id = '0302010201') and iperiod='7'
/*更新510202,八月明细库余额不等于贷方金额的情况*/
UPDATE GL_accass
SET me=mc
WHERE (ccode = '510202') AND (iperiod = '8')
/*更新510203,八月明细库余额不等于贷方金额的情况*/
UPDATE GL_accass
SET me = mc
WHERE (ccode = '510203') AND (iperiod = '8')
|