Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Fixed asset journal upload using Excel Add-in AX 2012

Posted on by Microsoft Employee

Dear all,

Could you share the way to upload the Fixed asset journal into AX 2012 using excel add-in?

I found that there are two tables in the Fixed asset journal. Does any one know how to combine these tables (LedgerJournalTrans_Asset, LedgerJournalTrans) ?

Thank in advance,

Thu,

*This post is locked for comments

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Fixed asset journal upload using Excel Add-in AX 2012

    Hi Thu,

    You can also have a look if a service can be used in this case. technet.microsoft.com/.../hh781102.aspx

    I'm not sure if Fixed assets are supported correctly in the Ledger journal service.

  • Suggested answer
    ZvikaR Profile Picture
    ZvikaR 89 on at
    RE: Fixed asset journal upload using Excel Add-in AX 2012

    in AX2012 Excel add-on is notoriously unstable and lacking in versatility (as you see here)

    There is an excellent add-on to 2012 called AtlasXL which gives you solid upload capabilities without any customization.

    Personally if I were you I would not bother to try and get the Excel Add-on tool to work...

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Fixed asset journal upload using Excel Add-in AX 2012

    Hi Thu,

    The problem with the Excel fixed asset upload in a GL journal is that the tables that you have are linked through the recid. As a result, you would have to upload first your journal lines and then do an update to enable the fixed asset tab where you enter the value model and the transaction type. This can be done for example with the help of an event handler, which needs however some development. So it is not possible out of the box.

    Therefore, please consider Andre's suggestion to make use of the Data Import Export Framework because this works out of the box.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fixed asset journal upload using Excel Add-in AX 2012

    Hi André,

    Cause our users require to use excel add-in, and the DIEF might need some setup before use it, so we think it would be more difficult for users.

    Best regards,

    Thu,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fixed asset journal upload using Excel Add-in AX 2012

    Dear Ludwig,

    I need to look for the solution without modification first, so does it mean i could not upload the journal which has more than 1 table?

    Best regards,

    Thu

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Fixed asset journal upload using Excel Add-in AX 2012

    Hi Thu,

    As alternative, you can have a look at Data Import Export Framework. This framework is able to read Excel or CSV files into (asset) journals.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Fixed asset journal upload using Excel Add-in AX 2012

    Hi Thu,

    You will have to make a small modification to become able uploading those journals. I would thus recommend that you talk with a developer.

    Best regards,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans