web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Upload Fixed asset tra...
Microsoft Dynamics AX (Archived)

Upload Fixed asset transaction error - via Excel add-in AX 2012

(0) ShareShare
ReportReport
Posted on by Community Member

Dear all,

I tried to use excel add-in to upload the Fixed asset transaction (tables: Ledgerjournaltrans and Ledgerjournaltrans_Asset).

When i published the file, there is an error message: 

Table Ledgerjournaltrans_Asset: field 'reference' must be filled in. But i cannot file this field name for this Table.

Could you please help to advice this case?

Best regards,

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Thu Ngo,

    Filling the Ledgerjournaltrans_Asset won't work without making a system modification.

    I once tested that and described it here: dynamicsax-fico.com/.../excel-add-in-enhancements-2

    This modification works fine if you have a limited number of fixed asset transactions that you want to upload and post. If you have a lot of fixed asset transactions better use the Import-Export-Framwork.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Thank you so so much, your posts helped me a lot!!

    It looks like General journal is suit well for Excel add-in.

    But i have several questions as below, could you help me explain?

    1. When i upload several journal (multiple debit - multiple credit) one at time, AX could not split the Voucher correctly

    -> is there any way to solve it?

    2. There would be some rounding issues when validating the vouchers,

    -> is there any way to avoid?

    3. If i have multiple account structures active (let said: Expense account structure, Balance sheet account structure and Revenue account structure), and my transactions require Expense account structure, Balance sheet account structure

    -> Is it possible to up load?

    Best regards,

    Thu Ngo,

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Thu Ngo,

    For 1:

    Delete the voucher and upload it again. That is possibly the fastest way to get this fixed

    For 2:

    You have to ensure that your Excel data are rounded to 2 decimal places. Format your numbers differently in Excel

    For 3:

    The Excel Addin should be able to handle that.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Thank you so much, i tried "None" for Default Account structure and it works fine.

    Best regards,

    Thu Ngo,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans