2012/12/31 09:39
备份好账套,执行如下语句:
---脚本意思,修改期初冗余记录coutno_id的只为null值。
update GL_accvouch set coutno_id=null where (coutsysname='IA' or coutsysname='PU' )
and GL_accvouch.coutno_id IN
(Select distinct cPzid from ia_subsidiary inner join inventory on ia_subsidiary.cinvcode=inventory.cinvcode
where not cPzid is null and ( iMonth=8)) and (iflag<>1 OR (iFlag is null )) and iperiod <>8
此问题一般不通用,很少碰到,若遇到相关问题可以参照此问题的解决思路。