T3财务通查询现存量不准确

结转年度账以前一切正常,结转年度账以后,客户自行在系统管理中,升级了一下SQL数据. 结果各种账表均为正常,但期初余额全部为空,在开销售单时商品的现存量出现问题.如:001商品收发存表中期初结转为500个.开销售单时001商品的现存量为0.经查对,所以商品的数量都只是没有加上期初数.客户操作到现在,所以商品出现负数. 请问以上问题是什么引起的？

财务通的现存量是没办法保证准确的，因为其没有库存管理的模块和现存量整理工具。

您可以用我下面的语句试下： if exists (select * from tempdb..sysobjects where type=’u’ and name=’forcurrentsyz’) drop table tempdb..forcurrentsyz go select cwhcode,cinvcode,sum(iquantity) as iquantity into tempdb..forcurrentsyz from ( select cwhcode,cinvcode,iaInquantity as iquantity from ia_subsidiary where cvoutype=’34′ union all select cwhcode,cinvcode,( case when brdflag=1 then iquantity else -1*(iquantity) end) as iquantity from rdrecord left join rdrecords on rdrecord.id=rdrecords.id ) a group by cwhcode,cinvcode go delete from currentstock Go insert into currentstock (cwhcode,cinvcode,iquantity) select cwhcode,cinvcode,iquantity from tempdb..forcurrentsyz go 。