It is working the backend Regards P Saravanakumar 09894999281 -----Original Message----- From: Kareem [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 1:01 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: AssetBook and AssetTrans What is this for? --- In Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED], "p.saravanakumar" <[EMAIL PROTECTED]> wrote: > > 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- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED] > 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] >
[Non-text portions of this message have been removed]
