|
|
U8知识库
| 问题号: |
424 |
| 解决状态: |
最终解决方案 |
| 软件版本: |
其他 |
| 软件模块: |
固定资产 |
| 行业: |
通用 |
| 关键字: |
821固定资产查帐不符 |
| 适用产品: |
u821 |
| 问题名称: |
821固定资产查帐不符！ |
| 问题现象: |
821固定资产查帐不符！ |
| 问题原因: |
数据问题 |
| 解决方案: |
首先进行一次折旧记提操作，不要制单，然后执行如下sql语句即可：
USE UFDATA_002_2003
GO
select a.* into aaa from fa_total as a inner join
Select fa_Cards.sDeptNum,fa_Cards.sTypeNum
FROM 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.sTypeNum
go
delete from fa_total
go
Insert into fa_total
select * from aaa
go
drop table aaa
go
update fa_total
set dblMonthDeprTotal=b.sum3,dblDeprTotal = b.sum1,dblvalue=b.sum2,dblMonthValue=b.sum2,dblYearValue=b.sum2
from fa_total as a inner join Select fa_Cards.sDeptNum,fa_Cards.sTypeNum,
Sumfa_DeprTransactions.dblDeprT1 as sum1 ,sumfa_Cards.dblvalue as sum2,sumfa_DeprTransactions.dblDeprT0 as sum3
FROM 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.sTypeNum
go |
| 补丁编号: |
|
| 录入日期: |
2005-6-28 |
| 最后更新时间: |
|
马上注册，结交更多好友，享用更多功能，让你轻松玩转社区。
您需要 登录 才可以下载或查看，没有账号？注册账号
×
821固定资产查帐不符！ |
|
|站长微信|Archiver|手机版|小黑屋|用友之家
( 蜀ICP备07505338号|
51072502110008 )
IP卡
狗仔卡
发表于 2009-2-5 00:29:10
提升卡
置顶卡
变色卡
千斤顶
显身卡