Open Forum

Expand all | Collapse all

Mass Update Fixed Asset Card

  • 1.  Mass Update Fixed Asset Card

    Posted 12 days ago
    I am trying to update the Depreciation Start Date and Life on fixed assets without editing each asset. Is there a way to update all assets? I was looking for something like an "Edit in Excel" feature but could not find anything.

    I am using Dynamics Business Central.

    Thanks,

    ------------------------------
    Krystal Skidmore
    Layne Water Midstream, LLC
    The Woodlands TX
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: Mass Update Fixed Asset Card

    TOP CONTRIBUTOR
    Posted 10 days ago
    Have you explored Configuration Packages?  This tool essentially allows you to choose tables and fields and build an Excel workbook that will write to the new table.

    https://docs.microsoft.com/en-us/dynamics365/business-central/admin-how-to-prepare-a-configuration-package

    ------------------------------
    Jason Nicolaou
    Engagement Manager
    Sikich, LLP
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: Mass Update Fixed Asset Card

    SILVER CONTRIBUTOR
    Posted 10 days ago
    I would also use the Rapid Start approach, as Jason suggests.   Create a package and setup with the FA table and select the fields only for FA number and starting date.   Then "export to excel" and the spreadsheet will be created with all your fixed assets.  Simply change the data in the date field, save and then import back into the package.  Review and "Apply Data".

    Also, the Edit in Excel function should work in the latest BC version.  Which version are you working with?

    ------------------------------
    Jamie Constantine
    Columbus Global
    ------------------------------

    Conference-BCNAVUG_200x200


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