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 :
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Change Asset Functional Location d365

(5) ShareShare
ReportReport
Posted on by 12
after uploading Assets with Functional Locations i found it's take Default location so when i try to change it to the correct location from DMF or Excel Add-in there is no errors but without any changes ? can any one help for this issue ?
I have the same question (1)
  • André Arnaud de Calavon Profile Picture
    304,359 Super User 2026 Season 1 on at
    Hi Mostafa,
     
    Can you tell which exact data entity you used and what columns were provided in the source file with what values?
  • Mostafa Gad84 Profile Picture
    12 on at
    hi Andre ,
    Data Entity it's Assets entity View V3 ,the columns as below      
    MAINTENANCEASSETID ACQUISITIONCOST ACQUISITIONDATE ACTIVEFROM ACTIVETO
     
    FIXEDASSETID FULLPRIMARYADDRESS FUNCTIONALLOCATIONID MAINTENANCEASSETLIFECYCLESTATEID MAINTENANCEASSETTYPEID MODELID MODELYEAR NAME
     
    NOTES OWNERCUSTOMERACCOUNTNUMBER PARENTMAINTENANCEASSETID PRODUCTID PURCHASEORDERID REPLACEMENTDATE REPLACEMENTVALUE SERIALID VENDACCOUNT WARRANTYDATEFROMVEND WARRANTYID WRKCTRID
  • GabrieldelosSantos Profile Picture
    23 on at
    Hi Mostafa.
    I had the same issue and I am almost sure that is not possible to update the functional location massivly.
    Did you solve it or figured out how to do it?
    Regards.
  • Suggested answer
    Syed Haris Shah Profile Picture
    1,629 Super User 2026 Season 1 on at
    Hi Mostafa,
     
    The Functional location Type field on assets is read-only, which means it cannot be updated directly through DMF or Excel Add-in. Even though the import runs without errors, the system ignores changes to this field.

    If you need to change the functional location type, the correct way is to use the Change functional location Type option available under the Maintain button group on the action menu of the asset record.

    For bulk updates, you can filter/select multiple assets with the same location type, then use the Update function to set them to the desired functional location in one go.
     
    If you find this answer helpful, please consider verifying the answer. 👍
     
    Regards,
    Syed Haris Shah
  • GabrieldelosSantos Profile Picture
    23 on at
    Hi Syed,
     
    I believe he is trying to update the functional location, not the functional location type.
    I’m facing the same issue.
    Do you know if there’s a way to perform this update in bulk?
     
    Thanks in advance!
    Gabriel
  • Sagar121 Profile Picture
    1,190 Super User 2026 Season 1 on at
    Hi Gabriel,
     
    Can you please share name of Data entity you are using ?
  • Suggested answer
    CA Neeraj Kumar Profile Picture
    5,108 Super User 2026 Season 1 on at
     
    Can you please try this data entity "EntAssetMaintenanceFunctionalLocationObjectEntity", 
     
     
    Regards,
    Neeraj Kumar
    If this helped, please mark it as "Verified" for others facing the same issue Keep in mind that it is possible to mark more than one answer as verified
  • Suggested answer
    Yng Lih Profile Picture
    1,612 Super User 2026 Season 1 on at
    Hi Mostafa,
     
    It can't be updated from Excel add-in or DMF.
     
    DMF will prompt below error.
     
    You can use this function "Install asset at location" to change the Functional location.
     
     
     
     
     
    If this information was helpful, kindly mark it as 'Verified'. Thank you. :)
     
     
      
     
     
     
  • Suggested answer
    CA Neeraj Kumar Profile Picture
    5,108 Super User 2026 Season 1 on at
     
    Update is not allowed. But Insert is allowed.
     
    I have tested the same entity to change the Functional location:
    1) Below are the steps:
    First make sure don't make changes in the exported data for Functional location, just update the Expiration date (it must be lesser than current datetime(), and greater than Effective date).
    It will allow you to update the expiration date first.
     
    2) Then, use the same exported data, make changes in the functional location id and update the Effective date (which should be equal or greater than Expiration date of previous record).
     
    This way it works.
     
    Regards,
    Neeraj Kumar
    If this helped, please mark it as "Verified" for others facing the same issue Keep in mind that it is possible to mark more than one answer as verified
     
  • Yng Lih Profile Picture
    1,612 Super User 2026 Season 1 on at
    Hi Neeraj Kumar,
     
    Agreed with you. Depends on the requirement, I read it as he needs to update.
     
     

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Mallesh Deshapaga Profile Picture

Mallesh Deshapaga 192

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 148 Super User 2026 Season 1

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 124 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans