Dear Kareem
It is useful for you.
select DATAAREAID,ASSETGROUP, assetid, NAME, TECHINFO1, TECHINFO2,
TECHINFO3, sum(assetval) assetval, sum(netbookvalue) netbookvalue
from
(
sELECT A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1,
E.TECHINFO2, E.TECHINFO3,
SUM(b.AMOUNTMST) ASSETVAL,
0 NetBookValue
FROM Axatvstst.AssetBook A, Axatvstst.AssetTrans B,
AXATVSTST.AssetDepreciationProfile C, AXATVSTST.ASSETBOOKTABLE D,
AXATVSTST.ASSETTABLE E
Where A.DATAAREAID = B.DATAAREAID AND A.ASSETID=B.ASSETID
AND A.ASSETGROUP=D.BOOKID AND D.DEPRECIATIONPROFILE=C.PROFILE
AND A.DATAAREAID=E.DATAAREAID AND A.ASSETID=E.ASSETID
AND B.TRANSTYPE IN (1,2) AND B.TRANSDATE <
TO_DATE('01/04/2006','DD/MM/YYYY')
GROUP BY A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1,
E.TECHINFO2, E.TECHINFO3
union
sELECT A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1,
E.TECHINFO2, E.TECHINFO3,
SUM(0) ASSETVAL,
SUM(b.AMOUNTMST) NetBookValue
FROM Axatvstst.AssetBook A, Axatvstst.AssetTrans B,
AXATVSTST.AssetDepreciationProfile C, AXATVSTST.ASSETBOOKTABLE D,
AXATVSTST.ASSETTABLE E
Where A.DATAAREAID = B.DATAAREAID AND A.ASSETID=B.ASSETID
AND A.ASSETGROUP=D.BOOKID AND D.DEPRECIATIONPROFILE=C.PROFILE
AND A.DATAAREAID=E.DATAAREAID AND A.ASSETID=E.ASSETID
AND B.TRANSDATE < TO_DATE('01/04/2006','DD/MM/YYYY')
GROUP BY A.DATAAREAID, A.ASSETID, E.NAME, A.ASSETGROUP, E.TECHINFO1,
E.TECHINFO2, E.TECHINFO3
) WHERE ASSETGROUP BETWEEN '033' AND '033' group by DATAAREAID,
ASSETGROUP,assetid, NAME, TECHINFO1, TECHINFO2, TECHINFO3
Regards
P Saravanakumar
Co-Its
09894999281
-----Original Message-----
From: Kareem [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 28, 2007 12:07 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] AssetBook and AssetTrans
Hi,
I want to know more about these two tables: AssetBook and AssetTrans.
I know that AssetTrans contains all the transactions of fix assets, but
how is it related to AssetBook? I noted that not all transactions that
exist in TransTable are in the assetBook table? so what data actually
is stored in the AssetBook?and when this table is updated?
thanks,
[Non-text portions of this message have been removed]
