Skip to main content

Notifications

Announcements

Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Fixed Asset Import - M...
Finance | Project Operations, Human Resources, ...
Suggested answer

Fixed Asset Import - Macro

(0) ShareShare
ReportReport
Posted on by Kait C 10

Hi there, I am fairly new to GP and currently have over 100 fixed assets that I need to upload (this will be my first time going through the fixed asset process). I have put all assets in the required format to import and saved as a .txt file prior to uploading. When I enter the import tool it is requesting a macro. What is this? How can it be created or are there templates that can be used across multiple organizations?

On the opposite end, is there a way to mass upload disposals for the year? I am familiar with how to individually retire each asset by entering the asset ID, but again I have over 100 and this will be extremely time consuming.

Thank you in advance! 

Categories:
Microsoft Dynamics GP
  • ZL-14052118-0 Profile Picture
    ZL-14052118-0 2 on at
    Fixed Asset Import - Macro
    Hi, I am same as you, just start to use GP for the fixed asset part. Could you please advise your format as CSV or Excel? Highly appreciate. 
  • Suggested answer
    Nicole Hellerud Profile Picture
    Nicole Hellerud 1,712 on at
    RE: Fixed Asset Import - Macro

    Hi Kait C-

    Thank you for your post. I've listed below the Importing info that can be found in the HELP file. 

    Importing asset records

    You must mark the All-Asset Info option in the Asset Import/Export window to import asset information or make changes to existing asset information.

    When you import new asset information into the Asset General Information window, an asset book and financial detail information will be created for each book if the following conditions are met:

    • The Auto Add Book Info option is marked in the Book Setup window for each book ID.
    • The Auto Add Book Info option is marked in the Fixed Assets Company Setup window.

    To import prior depreciation balances, unmark Auto Add Book Info for all Book Setup records in the Fixed Assets Company Setup window.

    We recommend that you import several small files rather than one large file. You also should import the information to a test company to view the imported results.

    To import asset records:

    1. Open the Asset Import/Export window.
      (Financial >> Utilities >> Fixed Assets >> Asset Import/Export)
    2. Mark Import and select All Asset Info.
    3. Enter or browse to find a location to create the macro in and enter a file name for the macro. The file name extension should be .MAC.
    4. Mark the Run Macro After Creation option to start the macro automatically after it is created. To run the macro later, from the Microsoft Dynamics GP menu choose Macro >> Play.
    5. Enter or find the path and name of the file containing the data to be imported or accept the default path and name—Asset.txt.
    6. Select Comma- or Tab-delimited format.
    7. Choose Continue to create the macro and import the data.

    If a problem error occurs while running the macro that imports the data, information added prior to the problem does not have to be imported again.

    While we do not have a mass upload disposal, we do have the Mass Retire that you could look into.

    Recording the sale or retirement of a group of assets

    Use the Fixed Assets Mass Retirement window to record the sale or disposal of a group of assets. You must build a new asset group for each mass retirement to ensure that all existing assets that meet the criteria selected are included in the retirement. 

    To record the sale or retirement of a group of assets:

    1. Open the Fixed Assets Mass Retirement window.
      (Financial >> Transactions >> Fixed Assets >> Mass Retire)
    2. Select an asset group ID.
    3. Enter a retirement date and select a retirement type.
    4. You can enter or select a retirement code to describe why the assets are being retired.
    5. Enter or select a currency ID if the currency is different from the functional currency ID.
    6. Enter the cash proceeds, non-cash proceeds, and expenses of sale. These amounts will be used when retiring each asset in the asset group.
    7. Choose a spread option or accept the default option. 
    8. Choose Retire.

    Close the Fixed Assets Mass Retirement window.I hope this information helps. Please let us know if you have continued questions/concerns.

    Wishing you healthy/happy days ahead.
    Nicole Sutton
    Senior Support Engineer
    Microsoft Dynamics

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 439 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 305

#3
Saalim Ansari Profile Picture

Saalim Ansari 261

Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans