Fixed Assets History Report

As we all know , after you do the year end closing to Fixed Assets in Dynamics the automatic printed report can’t be re-printed.
so i have tried to create some sort of SQL script to retrieve a detailed data for the Assets Depreciation (Asset ID , Asset Description , Year , Period , Depreciation General Journal Number , General Journal Date , Vendor ID , Vendor Name (If the asset was purchased of course) . Purchase document number ,..etc)  i did that although it has some limitations which are :

1. It only applies for cooperate book which is in the Fixed Assets Company Setup.
   
2. Transactions should be posted from Fixed Assets to General Ledger and posted from General Ledger .
   
3. If summarize financial process for a specific year , this year transactions will not appear for sure.
   
4. If the automatic created fixed assets general journal batch changed in General Ledger it will not be detected in the query.
   
5. This query detects depreciation journals only (Can be modified by removing filters).

The query will be posted tomorrow , after testing.
Edit : This is the script
USE [TWO] GO /****** Object:  View [dbo].[FIXED_ASSETS_HISTORY]    Script Date: 09/23/2010 06:53:38 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER VIEW [dbo].[FIXED_ASSETS_HISTORY] AS SELECT     dbo.FA00100.ASSETINDEX AS [Asset Index], dbo.FA00100.ASSETID AS [Asset ID], dbo.FA00100.ASSETDESC AS [Asset Description], dbo.FA00902.BOOKINDX,                       dbo.FA00902.FAYEAR AS Year, dbo.FA00902.FAPERIOD AS Period, dbo.FA01400.Acquisition_Cost AS [Acquisition Cost], dbo.FA00902.AMOUNT AS Amount,                       dbo.FA00902.SOURCDOC, dbo.GL20000.JRNENTRY AS [Journal Entry Number], dbo.GL20000.TRXDATE AS [Journal Entry Date],                       dbo.FA01400.VENDORID AS [Vendor ID], dbo.PM00200.VENDNAME AS [Vendor Name], dbo.FA00902.TRANSACCTTYPE,                       dbo.FA00902.GLINTBTCHNUM AS [General Ledger Batch Number], dbo.FA40201.ASSETCLASSIDDESC AS [Asset ClassDescription],                       dbo.FA00100.ACQDATE AS [Acquisition Date], dbo.FA00100.ASSETCLASSID AS [Asset Class ID] FROM         dbo.FA00100 INNER JOIN                       dbo.FA00902 ON dbo.FA00100.ASSETINDEX = dbo.FA00902.ASSETINDEX INNER JOIN                       dbo.FA40201 ON dbo.FA00100.ASSETCLASSID = dbo.FA40201.ASSETCLASSID LEFT OUTER JOIN                       dbo.GL20000 ON dbo.FA00902.GLINTBTCHNUM = dbo.GL20000.ORTRXSRC LEFT OUTER JOIN                       dbo.FA01400 ON dbo.FA00100.ASSETINDEX = dbo.FA01400.ASSETINDEX LEFT OUTER JOIN                       dbo.PM00200 ON dbo.FA01400.VENDORID = dbo.PM00200.VENDORID RIGHT OUTER JOIN                       dbo.FA00400 ON dbo.GL20000.ACTINDX = dbo.FA00400.DEPREXPACCTINDX AND dbo.FA00100.ASSETINDEX = dbo.FA00400.ASSETINDEX WHERE     (dbo.FA00902.BOOKINDX =                           (SELECT     CORPBOOKINDX                              FROM         dbo.FA49900)) AND (dbo.FA00902.GLINTBTCHNUM IS NOT NULL) AND (dbo.FA00902.TRANSACCTTYPE = 2)
So you can do the math on Crystal Report to calculate depreciation amount for an asset or asset class for a year …etc , accumulated deprecation till specific period , Netbook value …etc
Hope this helps.