用友U8 选择固定资产-帐表管理-折旧表-固定资产及累计折旧表一,按类别统计时,固定资产原值、累计折旧和本月折旧的各类别总计不正确,而单个固定资产的原值、累计折旧和本月折旧是正确的。用友U8 选择固定资产\帐表管理\折旧表\固定资产及累计折旧表一,按类别统计时,固定资产原值、累计折旧和本月折旧的各类别总计不正确,而单个固定资产的原值、累计折旧和本月折旧是正确的。
问题原因:数据问题解决方法:首先取消结帐恢复到一月份,然后在一月分进行折旧记提操作后,在sqlserver的查询分析器中执行如下sql语句即可select a.* into aaa from fa_total as a inner join Select fa_Cards.sDeptNum,fa_Cards.sTypeNumFROM fa_Origins AS fa_Origins_2 RIGHT JOIN fa_Origins AS fa_Origins_1 RIGHT JOIN fa_Cards LEFT JOIN fa_DeprTransactions ON fa_Cards.sCardNum = fa_DeprTransactions.sCardNum LEFT JOIN fa_WorkLoad ON fa_Cards.sCardNum = fa_WorkLoad.sCardNum LEFT JOIN fa_Departments ON fa_Cards.sDeptNum = fa_Departments.sNum LEFT JOIN fa_AssetTypes ON fa_Cards.sTypeNum = fa_AssetTypes.sNum LEFT JOIN fa_Status ON fa_Cards.sStatusID = fa_Status.sID LEFT JOIN fa_Depreciations ON fa_Cards.sDeprMethodID = fa_Depreciations.sID LEFT JOIN fa_ItemsManual ON fa_Cards.sCardNum = fa_ItemsManual.sCardNum LEFT JOIN fa_Origins ON fa_Cards.sOrgID = fa_Origins.sID ON fa_Origins_1.sAddID = fa_Cards.sOrgAddID ON fa_Origins_2.sDecID = fa_Cards.sOrgDisposeID LEFT JOIN fa_Vouchers ON fa_Cards.sVoucherNum = fa_Vouchers.sNum Where fa_Cards.sCardID IN SELECT MaxsCardID From fa_Cards WHERE fa_Cards.dInputDate<=‘2003-01-31‘ AND fa_Cards.dTransDate<=‘2003-01-31‘ Or fa_Cards.dTransDate Is Null AND fa_Cards.dDisposeDate<=‘2003-01-31‘ Or fa_Cards.dDisposeDate Is Null GROUP BY fa_Cards.sCardNum AND fa_Cards.iOptType<>8 And fa_Cards.iOptType<>6 AND fa_Cards.dDisposeDate is null group by fa_Cards.sDeptNum,fa_Cards.sTypeNum as b on a.sDeptNum=b.sDeptNum and a.sTypeNum=b.sTypeNumgodelete from fa_totalgoInsert into fa_totalselect * from aaagodrop table aaagoSelect fa_Cards.sDeptNum,fa_Cards.sTypeNum,Sumfa_DeprTransactions.dblDeprT1 as sum1 ,Sumfa_DeprTransactions.dblDepr1 as sum4 ,sumfa_Cards.dblvalue as sum2,sumfa_DeprTransactions.dblDeprT0 as sum3into bFROM fa_Origins AS fa_Origins_2 RIGHT JOIN fa_Origins AS fa_Origins_1 RIGHT JOIN fa_Cards LEFT JOIN fa_DeprTransactions ON fa_Cards.sCardNum = fa_DeprTransactions.sCardNum LEFT JOIN fa_WorkLoad ON fa_Cards.sCardNum = fa_WorkLoad.sCardNum LEFT JOIN fa_Departments ON fa_Cards.sDeptNum = fa_Departments.sNum LEFT JOIN fa_AssetTypes ON fa_Cards.sTypeNum = fa_AssetTypes.sNum LEFT JOIN fa_Status ON fa_Cards.sStatusID = fa_Status.sID LEFT JOIN fa_Depreciations ON fa_Cards.sDeprMethodID = fa_Depreciations.sID LEFT JOIN fa_ItemsManual ON fa_Cards.sCardNum = fa_ItemsManual.sCardNum LEFT JOIN fa_Origins ON fa_Cards.sOrgID = fa_Origins.sID ON fa_Origins_1.sAddID = fa_Cards.sOrgAddID ON fa_Origins_2.sDecID = fa_Cards.sOrgDisposeID LEFT JOIN fa_Vouchers ON fa_Cards.sVoucherNum = fa_Vouchers.sNum Where fa_Cards.sCardID IN SELECT MaxsCardID From fa_Cards WHERE fa_Cards.dInputDate<=‘2003-01-31‘ AND fa_Cards.dTransDate<=‘2003-01-31‘ Or fa_Cards.dTransDate Is Null AND fa_Cards.dDisposeDate<=‘2003-01-31‘ Or fa_Cards.dDisposeDate Is Null GROUP BY fa_Cards.sCardNum AND fa_Cards.iOptType<>8 And fa_Cards.iOptType<>6 AND fa_Cards.dDisposeDate is null group by fa_Cards.sDeptNum,fa_Cards.sTypeNumupdate fa_totalset dblMonthDeprTotal=b.sum3,dblDeprTotal = b.sum1,dblvalue=b.sum2,dblMonthValue=b.sum2,dblYearValue=b.sum2,dblYearDeprTotal=b.sum3,dblDepr=sum4from fa_total as a inner join b on a.sDeptNum=b.sDeptNum and a.sTypeNum=b.sTypeNumgodrop table bgo
解决方案:
问题原因:数据问题解决方法:首先取消结帐恢复到一月份,然后在一月分进行折旧记提操作后,在sqlserver的查询分析器中执行如下sql语句即可select a.* into aaa from fa_total as a inner join Select fa_Cards.sDeptNum,fa_Cards.sTypeNumFROM fa_Origins AS fa_Origins_2 RIGHT JOIN fa_Origins AS fa_Origins_1 RIGHT JOIN fa_Cards LEFT JOIN fa_DeprTransactions ON fa_Cards.sCardNum = fa_DeprTransactions.sCardNum LEFT JOIN fa_WorkLoad ON fa_Cards.sCardNum = fa_WorkLoad.sCardNum LEFT JOIN fa_Departments ON fa_Cards.sDeptNum = fa_Departments.sNum LEFT JOIN fa_AssetTypes ON fa_Cards.sTypeNum = fa_AssetTypes.sNum LEFT JOIN fa_Status ON fa_Cards.sStatusID = fa_Status.sID LEFT JOIN fa_Depreciations ON fa_Cards.sDeprMethodID = fa_Depreciations.sID LEFT JOIN fa_ItemsManual ON fa_Cards.sCardNum = fa_ItemsManual.sCardNum LEFT JOIN fa_Origins ON fa_Cards.sOrgID = fa_Origins.sID ON fa_Origins_1.sAddID = fa_Cards.sOrgAddID ON fa_Origins_2.sDecID = fa_Cards.sOrgDisposeID LEFT JOIN fa_Vouchers ON fa_Cards.sVoucherNum = fa_Vouchers.sNum Where fa_Cards.sCardID IN SELECT MaxsCardID From fa_Cards WHERE fa_Cards.dInputDate<=‘2003-01-31‘ AND fa_Cards.dTransDate<=‘2003-01-31‘ Or fa_Cards.dTransDate Is Null AND fa_Cards.dDisposeDate<=‘2003-01-31‘ Or fa_Cards.dDisposeDate Is Null GROUP BY fa_Cards.sCardNum AND fa_Cards.iOptType<>8 And fa_Cards.iOptType<>6 AND fa_Cards.dDisposeDate is null group by fa_Cards.sDeptNum,fa_Cards.sTypeNum as b on a.sDeptNum=b.sDeptNum and a.sTypeNum=b.sTypeNumgodelete from fa_totalgoInsert into fa_totalselect * from aaagodrop table aaagoSelect fa_Cards.sDeptNum,fa_Cards.sTypeNum,Sumfa_DeprTransactions.dblDeprT1 as sum1 ,Sumfa_DeprTransactions.dblDepr1 as sum4 ,sumfa_Cards.dblvalue as sum2,sumfa_DeprTransactions.dblDeprT0 as sum3into bFROM fa_Origins AS fa_Origins_2 RIGHT JOIN fa_Origins AS fa_Origins_1 RIGHT JOIN fa_Cards LEFT JOIN fa_DeprTransactions ON fa_Cards.sCardNum = fa_DeprTransactions.sCardNum LEFT JOIN fa_WorkLoad ON fa_Cards.sCardNum = fa_WorkLoad.sCardNum LEFT JOIN fa_Departments ON fa_Cards.sDeptNum = fa_Departments.sNum LEFT JOIN fa_AssetTypes ON fa_Cards.sTypeNum = fa_AssetTypes.sNum LEFT JOIN fa_Status ON fa_Cards.sStatusID = fa_Status.sID LEFT JOIN fa_Depreciations ON fa_Cards.sDeprMethodID = fa_Depreciations.sID LEFT JOIN fa_ItemsManual ON fa_Cards.sCardNum = fa_ItemsManual.sCardNum LEFT JOIN fa_Origins ON fa_Cards.sOrgID = fa_Origins.sID ON fa_Origins_1.sAddID = fa_Cards.sOrgAddID ON fa_Origins_2.sDecID = fa_Cards.sOrgDisposeID LEFT JOIN fa_Vouchers ON fa_Cards.sVoucherNum = fa_Vouchers.sNum Where fa_Cards.sCardID IN SELECT MaxsCardID From fa_Cards WHERE fa_Cards.dInputDate<=‘2003-01-31‘ AND fa_Cards.dTransDate<=‘2003-01-31‘ Or fa_Cards.dTransDate Is Null AND fa_Cards.dDisposeDate<=‘2003-01-31‘ Or fa_Cards.dDisposeDate Is Null GROUP BY fa_Cards.sCardNum AND fa_Cards.iOptType<>8 And fa_Cards.iOptType<>6 AND fa_Cards.dDisposeDate is null group by fa_Cards.sDeptNum,fa_Cards.sTypeNumupdate fa_totalset dblMonthDeprTotal=b.sum3,dblDeprTotal = b.sum1,dblvalue=b.sum2,dblMonthValue=b.sum2,dblYearValue=b.sum2,dblYearDeprTotal=b.sum3,dblDepr=sum4from fa_total as a inner join b on a.sDeptNum=b.sDeptNum and a.sTypeNum=b.sTypeNumgodrop table bgo