SQL view for Fixed Assets depreciation in Dynamics GP

Below is a view I have put together to get the monthly Fixed Assets depreciation amounts in Dynamics GP. For more detail on the Fixed Assets module, please visit my Fixed Assets Tables page. If you’re looking for more SQL code, you can find it on my GP Reports page.

~~~~~

CREATE VIEW view_FA_Depreciation
AS

/*******************************************************************
view_FA_Depreciation
Created on Apr 7, 2010 by Victoria Yudin - Flexible Solutions, Inc.
For updates visit http://victoriayudin.com/gp-reports/
Tables used:
FA00100 – fm - Asset General Information Master
FA00902 – d - Financial Detail Master
*******************************************************************/

SELECT
     fm.ASSETID Asset_ID,
     fm.ASSETIDSUF Asset_Suffix,
     fm.ASSETDESC Asset_Description,
     d.FAPERIOD Depr_Month,
     d.FAYEAR Depr_Year,
     d.AMOUNT Depreciation,
     d.GLINTTRXDATE GL_Trx_Date,
     fm.Master_Asset_ID,
     fm.ASSETCLASSID Asset_Class,
     fm.STRUCTUREID Stucture_ID,
     fm.LOCATNID Location_ID,
     fm.ACQDATE Acquisition_Date,
     fm.Acquisition_Cost,
     fm.Physical_Location_ID,
     fm.Asset_Label

FROM FA00902 d  -- financial detail

LEFT OUTER JOIN
     FA00100 fm  -- fa master
     ON fm.assetindex = d.assetindex

WHERE d.TRANSACCTTYPE = 2  -- depreciation only

/** the following will grant permissions to this view to DYNGRP,
leave this section off if you do not want to grant permissions **/

GO
GRANT SELECT ON view_FA_Depreciation to DYNGRP

~~~~~

Disclaimer: I tested this on limited data, if you find an issue or have a suggestion for improvement, please let me know and I will post the update here for everyone