用友T6软件财务通现存量不准确
技术咨询，有偿服务！
复制微信号
财务通现存量不准确
原因分析：见答案
问题解答：财务通的现存量是没办法保证准确的，因为其没有库存管理的模块和现存量整理工具。您可以用我下面的语句试下：if exists (select * from tempdb..sysobjects where type='u' and name='forcurrentsyz')drop table tempdb..forcurrentsyzgoselect cwhcode,cinvcode,sum(iquantity) as iquantity into tempdb..forcurrentsyz from (select cwhcode,cinvcode,iaInquantity as iquantity from ia_subsidiary where cvoutype='34'union allselect 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 godelete from currentstockGoinsert into currentstock (cwhcode,cinvcode,iquantity) select cwhcode,cinvcode,iquantity from tempdb..forcurrentsyzgo
如果您的问题还没有解决，或者在百度上找不到答案可以到右上角搜索中进行搜索。