This discussion is archived
1 Reply Latest reply: Nov 14, 2012 9:10 PM by Ivruksha RSS

Depreciation - FA

sliderrules Newbie
Currently Being Moderated

I am trying to generate a Fixed Asset report in SQL but need to obtain the following fields:

Depreciation Amount - depreciation calculated for the month
Year-to-Date Depreciation -cumulative depreciation for the current Financial Year
Depreciation Reserve -total cumulative depreciation for the asset

Does anyone have a similar query that obtains the above information?

  • 1. Re: Depreciation - FA
    Ivruksha Pro
    Currently Being Moderated

    You can generate an asset trace from asset module, the output contains all table names with column details that helps all report developers if they are designing an asset related report ...

    Please perform the below steps and review the output ....

    Switch Responsibility to System Administrator
    Navigate to Security > Responsibility > Request
    Select/Query the request group for your Fixed Asset Responsibility (Standard group name is "All Reports and Programs")
    Insert new record/row in the Requests region and select the program name "Generate Asset Trace"
    Save your changes ..
    Switch responsibility to your Fixed Asset Responsibility
    Run the concurrent program "Generate Asset Trace" with the parameter value for Asset book and Asset number
    Check the output (it would generate two ..1st one will contain asset details 2nd one will have SLA/accounting details of the Asset)

    The details of Depreciation Amount, YTD Depreciation and Depreciation Reserve are available in the Table FA_DEPRN_SUMMARY and FA_DEPRN_DETAIL.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points