解决方案: |
目前出了应收应付升级补丁脚本DATA851_AP.SQL,替换同名脚本,重新升级 如果不想重新升级,可以根据821中的ap_detail中的期初更改852中的ap_detail表中的期初:(001为852帐套,002为821帐套,请根据实际情况更改帐套号和年度) update a set idamount=b.idamount,icamount=b.icamount,idamount_s=b.idamount_s,icamount_s=b.icamount_s, idamount_f=b.idamount_f,icamount_f=b.icamount_f,csign=b.csign from ufdata_001_2005..ap_detail a full join ufdata_002_2005..ap_detail b on a.auto_id=b.auto_id and a.iperiod=b.iperiod where (isnull(a.idamount,0)<>isnull(b.idamount,0) or isnull(a.icamount,0)<>isnull(b.icamount,0)) and a.iperiod=0 |