Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 2013 Fixed Asset Im...
Microsoft Dynamics GP (Archived)

GP 2013 Fixed Asset Import/Export

(0) ShareShare
ReportReport
Posted on by Community Member

I am attempting to import assets using the Asset import tool. I have saved the Excel file as a CSV (comma delimited) file. When I attach the file and run as a macro, I got the following error message: Filed not found in dictionary. (Line #5).

As suggested by a Susan Conrod of the GP Community; "this happens everytime you run in a Fixed Asset the very first time.  Basically, the way around it is to enter one asset manually and then everything else will come in".  

I did as Susan suggested, however, I still encountered the error.

Any suggestions?

Regards

JLowe

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: GP 2013 Fixed Asset Import/Export

    I agree with Mahmoud. I have used the Macro tool many a times for Fixed Assets and also for some other areas within GP. It takes a little bit of time setting it up but once the setup is done in the template Macro correctly and data is clean (rid of invalid characters), its a breeze to run it through.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: GP 2013 Fixed Asset Import/Export

    Another option, is the Macro tool. I have an Excel macro generator which includes a calculation formulas to calculate the YTD  and LTD. All you have to do is to fill the asset details according to the original template, and the macro generator tool will dynamically calculate the results and provide a macro file to be run on Dynamics GP.  I have used it in several sites, importing more than 10,000 assets.

    The file is planned to be published on my blog soon as part of the macro generator series.

  • Community Member Profile Picture
    Community Member on at
    RE: GP 2013 Fixed Asset Import/Export

    Hi There...  Do you have a template for Great Plains 2013 Asset Import / Export Template?

    Thanks,

    Brian

    [quote user="Jlowe"]

    I am attempting to import assets using the Asset import tool. I have saved the Excel file as a CSV (comma delimited) file. When I attach the file and run as a macro, I got the following error message: Filed not found in dictionary. (Line #5).

    As suggested by a Susan Conrod of the GP Community; "this happens everytime you run in a Fixed Asset the very first time.  Basically, the way around it is to enter one asset manually and then everything else will come in".  

    I did as Susan suggested, however, I still encountered the error.

    Any suggestions?

    Regards

    JLowe

    [/quote]

  • Suggested answer
    Joshua Page Profile Picture
    Joshua Page on at
    RE: GP 2013 Fixed Asset Import/Export

    I checked the fix-list and it looks like it was fixed in 11/19/13 version of the Payroll Year end update. 12.00.1538 (KB2911836).

    mbs.microsoft.com/.../MDGP2013_PreviousPatches.pdf

    If you have any other questions please feel free to let me know!

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: GP 2013 Fixed Asset Import/Export

    Do You know if microsoft will release a hot fix to correct this bug?   I have SP2 GP2013 and the bug still .

    Thks.,

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: GP 2013 Fixed Asset Import/Export

    Check out this link for details on importing assets into Dynamics GP.

    support.microsoft.com/.../871638

  • Community Member Profile Picture
    Community Member on at
    RE: GP 2013 Fixed Asset Import/Export

    Thank you Redbeard! This solution worked. However it only imported one asset :-( from the import template.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: GP 2013 Fixed Asset Import/Export

    I believe this post explains the problem you have encountered in detail and how to fix it.

    amllpdynamics.blogspot.com/.../dynamics-gp-fixed-asset-bug-in-gpv2013.html

    The best approach is to fill in the fields in the Asset Export/Import window as you did before, but this time, leave the Run Macro after creation unchecked

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans