Reporting and Analytics for ERP

Get Involved. Join the Conversation.


    Jacqueline Fournier
    Fixed Asset Reporting
    Topic posted October 12, 2017 by Jacqueline Fournier, tagged BI Publisher, Fusion Financial reporting, OTBI, Reports 
    446 Views, 5 Comments
    Fixed Asset Reporting
    Reporting from Fixed Asset Sub-Ledger

    Hello -

    I'm looking for the following information in a report from the Fixed Asset sub-ledger.  I am looking for a report that shows the following (at least):

    - Asset Number (description and number)

    - Category

    - Location

    - Start Date

    - Method

    - Life (years or months)

    - Original Cost

    - Cost

    - Depreciation

    - YTD Depreciation

    - Depreciation Reserve

    - Period End Net Book Value

    - GL Account information (full account with all segments) - Cost Account, Accumulated Depreciation Account, Depreciation Account

    I'm using the "Journal Entry Reserve Ledger" which includes many fields I don't need and doesn't include several fields I would like to see on a monthly basis.  Generally, I'm looking for best practices and instructions for reporting from the Fixed Asset sub-ledger. 



    • Sameh Soliman
      This should be the report you are looking for ( Journal Entry Reserve Ledger <javascript:void(0);> ) , you can customize your own BIP layout and extract more columns from ( Journal Entry Reserve Ledger Data Model<javascript:void(0);>).
    • Alexey Shtrakhov

      Hi Jacqueline,

      Im not sure if exactly understood the requirement but for listing the assets having all the information above we are using "Asset Register" with customized template.
      we list in excel for all our around 25000 assets.

      Attaching you some screenshot... column names are in Finnish, but the thing is that for us the data extract provided by this report was the most suitable the only thing we needed to modify the template quite a lot.

      With respect

    • Liam Todd

      Hi both, just looking at some fixed asset reporting myself - was the catalogue ever shared and if so would I be able to take a look?



    • Xavier Cuinier


      In Update 18B a new OTBI subject area will come with some interesting improvments related to your need (I think) :

      In case all your assets depreciate, you can also review the OTBI analysis enclosed with journal entries detail