问题版本: |
812-U6普及版3.1 plus1 |
问题模块: |
16-存货核算 |
所属行业: |
0-通用 |
问题状态: |
1-UU通注册用户 |
关 键 字: |
恢复仓库处理时候出错,提示运行时错误13 |
适用产品: |
U6 |
补 丁 号: |
|
开放状态: |
0-UU通注册用户 |
原问题号: |
|
提交时间: |
2008-6-26 22:23:48 |
问题名称: |
恢复仓库处理时候出错,提示运行时错误13 |
问题现象: |
恢复仓库处理时候出错,提示运行时错误13 |
原因分析: |
同解决方法 |
解决方案: |
备份后执行下面语句: Delete from ia_subsidiary where cVouType='21' and cBusType='期末处理' and iMonth=1 and cWhCode='01' Delete from justinvouch where cJVCode in (select justinvouch.cJVCode from justinvouch left join justinvouchs on justinvouch.cjvcode=justinvouchs.cjvcode where autoid is null) Update ia_summary set iDifRate=null,iUnitPrice=null where imonth=1 and cWhCode='01' Update Warehouse set cMonth=200800 Where cWhCode='01' Exec IA_WriSummary 按仓库核算,2,1,'06','30130010J2',0,0,0,-.5,0,0 Update rdrecords set iUnitCost=null,iPrice=Null where autoid=4696 Update ia_subsidiary set iOutCost=null,iAOutPrice=Null where Autoid=9030 Exec IA_WriSummary 按仓库核算,2,1,'06','30130010J2',0,0,0,-.5,0,0 Update rdrecords set iUnitCost=null,iPrice=Null where autoid=4698 Update ia_subsidiary set iOutCost=null,iAOutPrice=Null where Autoid=9031 Exec IA_WriSummary 按仓库核算,2,1,'06','30110390J0',0,0,0,-35,0,0 Update rdrecords set iUnitCost=null,iPrice=Null where autoid=4180 Update ia_subsidiary set iOutCost=null,iAOutPrice=Null where Autoid=8647 Delete from ia_subsidiary where iMonth=1 and cWhCode='01' and cVouType='30' AND bFlag=1 | |