Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

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

Posted on by 1,811

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,

  • Verified answer
    Rana Anees Profile Picture
    Rana Anees 1,811 on at
    RE: How to auto generate Fixed Asset numbers based on asset groups when uploading fixed assets through Data Import Export Framework?

    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.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 288,420 Super User on at
    RE: How to auto generate Fixed Asset numbers based on asset groups when uploading fixed assets through Data Import Export Framework?

    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans