Import Assets with Asset Management Tools in Dynamics 365 Finance and Operations

By Jake Johansen | July 27, 2022

Asset Management tools in Dynamics 365 Finance and Supply Chain lets you plan and track costs and history for individual assets deeply integrated into all the domains of your ERP.

I was looking into a recent issue when importing data using the Asset management Assets entity, and it presented me with an interesting challenge. After I imported the assets, the Manufacturer was not showing up in the user interface. This intrigued me because I was able to verify that the MODELPRODUCTID field was populated in the DMF staging table. The D365 label on MODELPRODUCTID is "Manufacturer", but the field PRODUCTID also had the D365 label of "Manufacturer".

Asset Management Tools in Dynamics 365 Finance and Operations MODELPRODUCTID

Asset Management Tools in Dynamics 365 Finance and Operations PRODUCTID

So does this mean you don't need MODELPRODUCTID? While that was my initial thought, I found that if the field MODELID is populated, then MODELPRODUCTID is required. I did not, however, find any dependencies between PRODUCTID and those other two fields.

This leaves us with the following valid combinations of these three fields:

Asset Management Tools in Dynamics 365 Finance and Operations Valid Combinations

Below are some examples of sample data showing the correct combinations:

Asset Management Tools in Dynamics 365 Finance and Operations Sample Data 1

Asset Management Tools in Dynamics 365 Finance and Operations Sample Data 2

Questions?

Stoneridge Software has a team of experts that can help you with this feature! Please reach out to us if you have any questions.


Under the terms of this license, you are authorized to share and redistribute the content across various mediums, subject to adherence to the specified conditions: you must provide proper attribution to Stoneridge as the original creator in a manner that does not imply their endorsement of your use, the material is to be utilized solely for non-commercial purposes, and alterations, modifications, or derivative works based on the original material are strictly prohibited.

Responsibility rests with the licensee to ensure that their use of the material does not violate any other rights.

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!