用友T6软件进行年度结转时,都提示现存量错误
技术咨询，有偿服务！
复制微信号
进行年度结转时,都提示"现存量错误"
原因分析：原因可能是存货在新年度账被删除，解决方法是在新年度把删除的存货补上，如下语句能查询有哪些是缺少记录的存货select cinvcode as '存货编码' from(select distinct cinvcode from IA_Subsidiary where cinvcode not in (select cinvcode from Inventory)unionselect distinct cinvcode from IA_Summary where cinvcode not in (select cinvcode from Inventory)unionselect distinct cinvcode from RdRecords where cinvcode not in (select cinvcode from Inventory)union select distinct cinvcode from CurrentStock where cinvcode not in (select cinvcode from Inventory)) as a
问题解答：原因可能是存货在新年度账被删除，解决方法是在新年度把删除的存货补上，如下语句能查询有哪些是缺少记录的存货select cinvcode as '存货编码' from(select distinct cinvcode from IA_Subsidiary where cinvcode not in (select cinvcode from Inventory)unionselect distinct cinvcode from IA_Summary where cinvcode not in (select cinvcode from Inventory)unionselect distinct cinvcode from RdRecords where cinvcode not in (select cinvcode from Inventory)union select distinct cinvcode from CurrentStock where cinvcode not in (select cinvcode from Inventory)) as a
如果您的问题还没有解决，或者在百度上找不到答案可以到右上角搜索中进行搜索。