固定资产无法取消结帐-用友U8

对应版本:用友U8.52对应产品线：财务系统对应模块：固定资产模块问题现象:固定资产无法取消结帐前状态，提示“恢复结帐失败，请与供应商联系”。问题原因：用户的U852软件是刚刚从U821升级上来的，经过数据跟踪，是因为数据库里缺少一些表。从原来版本升级上来的，可能都存在这样的问题！解决方案：在查询分析器里执行如下语句，问题解决：select*intoUFFA_BAK_fa_Cards_Detail_6fromUFFA_BAK_fa_Cards_Detail_7select*intoUFFA_BAK_fa_Cards_Detail_5fromUFFA_BAK_fa_Cards_Detail_7select*intoUFFA_BAK_fa_Cards_Detail_4fromUFFA_BAK_fa_Cards_Detail_7select*intoUFFA_BAK_fa_Cards_Detail_3fromUFFA_BAK_fa_Cards_Detail_7select*intoUFFA_BAK_fa_Cards_Detail_2fromUFFA_BAK_fa_Cards_Detail_7select*intoUFFA_BAK_fa_Cards_Detail_1fromUFFA_BAK_fa_Cards_Detail_7select*intoUFFA_BAK_fa_DeprTransactions_Detail_6fromUFFA_BAK_fa_DeprTransactions_Detail_7select*intoUFFA_BAK_fa_DeprTransactions_Detail_5fromUFFA_BAK_fa_DeprTransactions_Detail_7select*intoUFFA_BAK_fa_DeprTransactions_Detail_4fromUFFA_BAK_fa_DeprTransactions_Detail_7select*intoUFFA_BAK_fa_DeprTransactions_Detail_3fromUFFA_BAK_fa_DeprTransactions_Detail_7select*intoUFFA_BAK_fa_DeprTransactions_Detail_2fromUFFA_BAK_fa_DeprTransactions_Detail_7select*intoUFFA_BAK_fa_DeprTransactions_Detail_1fromUFFA_BAK_fa_DeprTransactions_Detail_7select*intoUFFA_BAK_fa_EvaluateVouchers_Detail_6fromUFFA_BAK_fa_EvaluateVouchers_Detail_7select*intoUFFA_BAK_fa_EvaluateVouchers_Detail_5fromUFFA_BAK_fa_EvaluateVouchers_Detail_7select*intoUFFA_BAK_fa_EvaluateVouchers_Detail_4fromUFFA_BAK_fa_EvaluateVouchers_Detail_7select*intoUFFA_BAK_fa_EvaluateVouchers_Detail_3fromUFFA_BAK_fa_EvaluateVouchers_Detail_7select*intoUFFA_BAK_fa_EvaluateVouchers_Detail_2fromUFFA_BAK_fa_EvaluateVouchers_Detail_7select*intoUFFA_BAK_fa_EvaluateVouchers_Detail_1fromUFFA_BAK_fa_EvaluateVouchers_Detail_7select*intoUFFA_BAK_fa_Vouchers_Detail_6fromUFFA_BAK_fa_Vouchers_Detail_7select*intoUFFA_BAK_fa_Vouchers_Detail_5fromUFFA_BAK_fa_Vouchers_Detail_7select*intoUFFA_BAK_fa_Vouchers_Detail_4fromUFFA_BAK_fa_Vouchers_Detail_7select*intoUFFA_BAK_fa_Vouchers_Detail_3fromUFFA_BAK_fa_Vouchers_Detail_7select*intoUFFA_BAK_fa_Vouchers_Detail_2fromUFFA_BAK_fa_Vouchers_Detail_7select*intoUFFA_BAK_fa_Vouchers_Detail_1fromUFFA_BAK_fa_Vouchers_Detail_7select*intoUFFA_BAK_fa_WorkLoad_Detail_6fromUFFA_BAK_fa_WorkLoad_Detail_7select*intoUFFA_BAK_fa_WorkLoad_Detail_5fromUFFA_BAK_fa_WorkLoad_Detail_7select*intoUFFA_BAK_fa_WorkLoad_Detail_4fromUFFA_BAK_fa_WorkLoad_Detail_7select*intoUFFA_BAK_fa_WorkLoad_Detail_3fromUFFA_BAK_fa_WorkLoad_Detail_7select*intoUFFA_BAK_fa_WorkLoad_Detail_2fromUFFA_BAK_fa_WorkLoad_Detail_7select*intoUFFA_BAK_fa_WorkLoad_Detail_1fromUFFA_BAK_fa_WorkLoad_Detail_7

本文链接：http://www.bbsufida.com/u8/40400.html