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) / How to auto generate F...
Microsoft Dynamics AX (Archived)

How to auto generate Fixed Asset numbers based on asset groups when uploading fixed assets through Data Import Export Framework?

(0) ShareShare
ReportReport
Posted on by Rana Anees 1,813

Hii,

I have more than 1k fixed assets to upload in AX 2012 R2 in excel file. 
In excel file I have  following columns,

Fixed Asset group
Asset Name
Quantity
Business Unit
Physical Location
Employee
Acquisition Date

Existing fixed asset numbers are generated based on Fixed Asset groups i.e. FA of group Furniture starts with FUR-000215, Computes starts with COMP-0002514.

I am uploading from excel file by using Data Import Export Framework. How I can auto generate FA numbers based on FA groups. What settings required.

Thanks,

*This post is locked for comments

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,362 Super User 2026 Season 1 on at

    Hi Rana,

    I'm not sure if it is supported on Asset numbering, but usually you can go to the staging fields, add the asset number and enable the auto number option. This works for all numbers setup on the parameters forms. Assets numbers based on groups is a bit different, but you can test it.

  • Verified answer
    Rana Anees Profile Picture
    Rana Anees 1,813 on at

    It didn't work with me. So in excel file I manually generated next Asset Ids based on Asset Group and Number Sequence and imported through Data Import Export Framework.

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
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans