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

Released product Inventory Integration

(0) ShareShare
ReportReport
Posted on by 185

Hi, everyone,
I hope you all are doing well.
I am trying to integrate D365 f&o products and inventory with D365 CRM.
As I am using dual write for integration and while mapping inventory table I am not getting confused with the table.
So I have tried "Inventory on-hand by warehouse and inventory status" entity, As dual write doesn't automatically create an entity in Dataverse(CDS), so I have created customer entity and map with it, but
while running I am getting an error something like this "....doesn't have primary company field set".
Could anyone please tell me am I using the correct entity if yes, then what configuration should I do to make it work?
"Inventory on-hand by warehouse and inventory status" shows
following fields.

1.)ARE WAREHOUSE MANAGEMENT PROCESSES USED [AREWAREHOUSEMANAGEMENTPROCESSESUSED]
2.)INVENTORY SITE ID [INVENTORYSITEID]
3.)INVENTORY STATUS ID [INVENTORYSTATUSID]
4.)INVENTORY WAREHOUSE ID [INVENTORYWAREHOUSEID]
5.)ITEM NUMBER [ITEMNUMBER]
6.)ON HAND QUANTITY [ONHANDQUANTITY]
7.)ON ORDER QUANTITY [ONORDERQUANTITY]
8.)PRODUCT COLOR ID [PRODUCTCOLORID]
9.)PRODUCT CONFIGURATION ID [PRODUCTCONFIGURATIONID]
10.)PRODUCT NAME [PRODUCTNAME]
11.)PRODUCT SIZE ID [PRODUCTSIZEID]
12.)PRODUCT STYLE ID [PRODUCTSTYLEID]
13.)TOTAL AVAILABLE QUANTITY [TOTALAVAILABLEQUANTITY]
14.)Available OnHand Quantity [AvailableOnHandQuantity]
15.)Available Ordered Quantity [AvailableOrderedQuantity]
16.)Ordered Quantity [OrderedQuantity]
17.)Reserved OnHand Quantity [ReservedOnHandQuantity]
18.)Reserved Ordered Quantity [ReservedOrderedQuantity]

On_2D00_Hand-Entity.png

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    304,837 Super User 2026 Season 1 on at

    Hi Jishnu,

    Did you add a company column to the Dataverse table? Read the documentation about this concept and how to map it.

    Company concept in Dataverse - Finance & Operations | Dynamics 365 | Microsoft Docs

  • Jishnu Thapa Profile Picture
    185 on at

    yes, I add in the dataverse table but there is no company field in the f&o entity.

  • Jishnu Thapa Profile Picture
    185 on at

    Hi André Arnaud de Calavon,

    Could you please tell me how to add the company column to the Dataverse table? maybe I might add in the wrong way.

  • Jishnu Thapa Profile Picture
    185 on at

    Hi, everyone,
    I hope you all are doing well.

    I am trying to map "Inventory on-hand by warehouse and inventory status" Entity with a custom created table, while running, I am getting error as "Error:Project validation failed. SourceEntitySchema: Inventory on-hand by warehouse and inventory status has a primaryCompanyField set to DataAreaId and DestinationEntitySchema: cr767_warehouseinventorystatusesonhands doesn't have primary company field set. Dual-write only supports mapping between cross-company entities or company-specific entities from both sides.".

    Could anyone please tell me how to set the primary company field in DestinationEntitySchema Entity?

    5518.F1.PNG

  • André Arnaud de Calavon Profile Picture
    304,837 Super User 2026 Season 1 on at

    Hi Jishnu,

    Probably the documentation can clarify something for you. You can start here:

    Company concept in Dataverse - Finance & Operations | Dynamics 365 | Microsoft Docs

  • André Arnaud de Calavon Profile Picture
    304,837 Super User 2026 Season 1 on at

    Oh. I do see this is a duplicate of your other question. Let me merge the posts...

  • André Arnaud de Calavon Profile Picture
    304,837 Super User 2026 Season 1 on at

    Hi Jishnu,

    I read above that you can't find a company field in the F&O entity. If this is the case, check for the DataAreaId field. Currently, I don't have an environment with Dual Write enabled to check it.

  • Jishnu Thapa Profile Picture
    185 on at

    Hi André Arnaud de Calavon,

    DataAreaId field is not there, there is the only following field.

    1.)AREWAREHOUSEMANAGEMENTPROCESSESUSED [AREWAREHOUSEMANAGEMENTPROCESSESUSED]

    2.)INVENTORYSITEID [INVENTORYSITEID]

    3.)INVENTORYSTATUSID [INVENTORYSTATUSID]

    4.)INVENTORYWAREHOUSEID [INVENTORYWAREHOUSEID]

    5.)ITEMNUMBER [ITEMNUMBER]

    6.)ONHANDQUANTITY [ONHANDQUANTITY]

    7.)ONORDERQUANTITY [ONORDERQUANTITY]

    8.)PRODUCTCOLORID [PRODUCTCOLORID]

    9.)PRODUCTCONFIGURATIONID [PRODUCTCONFIGURATIONID]

    10.)PRODUCTNAME [PRODUCTNAME]

    11.)PRODUCTSIZEID [PRODUCTSIZEID]

    12.)PRODUCTSTYLEID [PRODUCTSTYLEID]

    13.)TOTALAVAILABLEQUANTITY [TOTALAVAILABLEQUANTITY]

    14.)AvailableOnHandQuantity [AvailableOnHandQuantity]

    15.)AvailableOrderedQuantity [AvailableOrderedQuantity]

    16.)OrderedQuantity [OrderedQuantity]

    17.)ReservedOnHandQuantity [ReservedOnHandQuantity]

    18.)ReservedOrderedQuantity [ReservedOrderedQuantity]

  • ToddB Profile Picture
    Microsoft Employee on at

    Hi Jishnu,

    Hopefully you have resolved this issue.

    If not, I would recommend creating a support incident.

  • Verified answer
    Jishnu Thapa Profile Picture
    185 on at

    Yes, I  have resolved this issue.

    Thanks

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 April Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 664

#2
André Arnaud de Calavon Profile Picture

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

#3
CP04-islander Profile Picture

CP04-islander 550

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans