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 :
Finance | Project Operations, Human Resources, ...
Answered

Import EcoResCategory via DMF

(0) ShareShare
ReportReport
Posted on by 68

Hi,

I would like to know if there is an entity to import EcoResCategory data via the DMF import functionality.
I checked multiple entities but it seems the one which i found is not for DMF imports as it does not even contains the staging table.

I mean you have the name,level,parent and so on.

pastedimage1648739913283v1.png
thanks,

VK

I have the same question (0)
  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    35,423 on at

    Hi Vicky,

    You can use EcoResProductCategoryEntity. You can set the Category hierarchy and import the records.

  • vicky1234 Profile Picture
    68 on at

    Hi Gunjan bhai,

    thanks for the reply.

    I want to import the category and hierarchies and not the product.

    the one which you shared is related to importing the products associated with a hierarchy.

    Let me know if I am missing something important

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    35,423 on at

    Hi Vicky,

    This entity takes care of the categories and hierarchies only. It doesn't import products. Please take a look at the underlying tables in the entity.

  • vicky1234 Profile Picture
    68 on at

    thanks Gunjan,

    I have tested and I confirm that its the entity used to import hierarchies as well.

    You are the best :)

  • vicky1234 Profile Picture
    68 on at

    Just wanted to ask what is the purpose of the Displayvalue and the ExternalId with value as {00000000-0000-0000-0000-000000000000}

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    35,423 on at

    Hi Vicky,

    I don't see a field DisplayValue. ExternalId is saving GUID values from other systems in case you are integrating D365 F&O with another system

  • vicky1234 Profile Picture
    68 on at

    My bad ,

    Its there on the ecorescategory table the field name is DisplayOrder.

    Thanks

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    35,423 on at

    DisplayOrder dertermines the sorting order on Category hierarchy form.

    For an example, in the screenshot below, Sports has a Display order value of 0.00, Apparel has a value 1.00 and Gifts has a values of 2.00. In the form they are arranged in this order.

    pastedimage1648832153118v1.png

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!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

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

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 390

#3
Adis Profile Picture

Adis 266 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans