Unified Operations & Dynamics AX Forum

Expand all | Collapse all

Fixed Asset Continuity Schedule report

  • 1.  Fixed Asset Continuity Schedule report

    TOP CONTRIBUTOR
    Posted Dec 10, 2018 01:45 PM
    Edited by Zvika Rimalt Dec 10, 2018 08:23 PM
    We are asked to periodically generate from D365 a sort of fixed asset summary report, that lists all assets/books, and for each one specify acquisition date and amount, total depreciation, total adjustments, and net book value etc.

    Is there an out of the box report giving that information?

    #UnifiedOperations
    #Finance

    ------------------------------
    Zvika Rimalt
    Functional Consultant
    Vancouver BC
    ------------------------------
    ​​​
    AXUG Summit - Post


  • 2.  RE: Fixed Asset Continuity Schedule report

    SILVER CONTRIBUTOR
    Posted Dec 10, 2018 04:16 PM
    Hi Zvika

    For my clients I typically use the Fixed Asset Roll Forward report. In order to use this report you will need to import the Format Mapping from the electronic reports database.

    This is for D365 only, I do not know if there is something similar in 2012.

    Thanks,

    ------------------------------
    Arush Kuthiala
    Western Computer
    Toronto ON
    ------------------------------

    AXUG Summit - Post


  • 3.  RE: Fixed Asset Continuity Schedule report

    TOP CONTRIBUTOR
    Posted Dec 10, 2018 08:02 PM
    Hi Arush

    Please can you share the screen shot and the process in 365 for FA reports

    Since we are  on AX 2012 R3, dont have roll forward and manually done on excel

    Thanks and best regards

    ------------------------------
    Nazim Lalji
    Dynamics AX Analyst

    ------------------------------

    AXUG Summit - Post


  • 4.  RE: Fixed Asset Continuity Schedule report

    TOP CONTRIBUTOR
    Posted Dec 11, 2018 01:10 AM
    Thanks Arush, I managed to download the report and it looks like it has many of the fields we need in the report.

    Did you find yourself modifying the electronic format? any recommendation for an online resource/tutorial on how to make changes?

    ------------------------------
    Zvika Rimalt
    Functional Consultant
    Vancouver BC
    ------------------------------

    AXUG Summit - Post


  • 5.  RE: Fixed Asset Continuity Schedule report

    SILVER CONTRIBUTOR
    Posted Dec 12, 2018 09:54 AM
    Hi Zvika

    I have not modified it, I'm a functional resource so if I needed it modified I would just write it up and send the changes to a develop :D
    For what it's worth one of my clients needed changes and I recommended they just export to Excel and use Macros, that seemed the easiest approach.

    Hi Nazim

    In order to add the format follow the following steps

    1. Go to the Electronic Reporting workspace

    2. Under Configuration Provides there should be a Microsoft tab, click the Repositories button

    3. In this case go to Add -> LCS

    4. Once the LCS repository is added select it and click Open

    5. This will open up the full list of reports available. In the Configuration Name search for "Fixed Asset roll forward"

    6. Select this report and in the Versions section at the bottom click Import.

    Once this is done the format should be available in the format drop down in the report.

    Hope this helps!


    ------------------------------
    Arush Kuthiala
    Western Computer
    Toronto ON
    ------------------------------

    AXUG Summit - Post


  • 6.  RE: Fixed Asset Continuity Schedule report

    TOP CONTRIBUTOR
    Posted Dec 16, 2018 10:28 PM
    thanks Arush

    Apparently (I have not tried it yourself) one can modify these reports through a type of configuration that can be done by functional resources as well.
    Personally I have not run into anyone who has actually done it themselves but this is how Microsoft was presenting the tool in conferences.

    Thank you very much for your suggestion of the Roll Forward report, the users loved it and are planning to use it.

    ------------------------------
    Zvika Rimalt
    Functional Consultant
    Vancouver BC
    ------------------------------

    AXUG Summit - Post


  • 7.  RE: Fixed Asset Continuity Schedule report

    SILVER CONTRIBUTOR
    Posted Dec 17, 2018 01:43 PM
    Hi Zvika

    It was my pleasure, I will see if I can find some tutorials on configuring these reports when I get some free time. That would be a cool thing to know.

    Take care,

    ------------------------------
    Arush Kuthiala
    Western Computer
    Toronto ON
    ------------------------------

    AXUG Summit - Post


If you've found this thread useful, dive deeper into User Group community content by role