进行年度结转时,都提示"现存量错误"
- 浏览：841 - 发布时间：2007-07-26 09:47:00.0
| 问题版本: |
2-财务通标准版2005 |
问题模块: |
11-系统管理 |
| 所属行业: |
0-通用 |
问题状态: |
1-UU通注册用户 |
| 关 键 字: |
年结 |
适用产品: |
用友通 |
| 补 丁 号: |
|
开放状态: |
0-UU通注册用户 |
| 原问题号: |
|
提交时间: |
2007-7-26 9:47:00 |
| 问题名称: |
进行年度结转时,都提示"现存量错误" |
| 问题现象: |
进行年度结转时,都提示"现存量错误" |
| 原因分析: |
原因可能是存货在新年度账被删除，解决方法是在新年度把删除的存货补上，如下语句能查询有哪些是缺少记录的存货 select cinvcode as '存货编码' from ( select distinct cinvcode from IA_Subsidiary where cinvcode not in (select cinvcode from Inventory) union select distinct cinvcode from IA_Summary where cinvcode not in (select cinvcode from Inventory) union select 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) union select distinct cinvcode from IA_Summary where cinvcode not in (select cinvcode from Inventory) union select 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 | |
