web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

On - Hand Inventory Dual write Integration issue

(0) ShareShare
ReportReport
Posted on by 40

I wanted to integrate On-Hand inventory from F&O to CRM using dual write, integration mapping are in running status but no data is being integrated.
whether we need to do some setting for this or change the status of the inventory records to integrate
1464.inventory.pnginventory_5F00_Intialsync.png

I have the same question (0)
  • Suggested answer
    Ziyao Profile Picture
    on at

    Hi guru2912,

    In order to testify if the source data entities are successfully sync to CRM.

    First, you need to validate, there is data exists in data entity.

    1. Go to Data Management->Data entities->search "CDS inventory on-hand" to locate the Target entity name in SQL

    1376.inv.png

    2. Run select * from INVENTCDSINVENTORYONHANDENTRYENTITY from SQL

    pastedimage1595581021640v3.png

    No records returned.

    3. Try to insert some records to this entity for testing and then Check the result in CRM side by insert URL: https://XXXXX.dynamics.com/api/data/v9.0/msdyn_inventoryonhandrequests

    There is no data currently exist in CRM for entity Inventory On-hand Entry (msdyn_inventoryonhandrequests):

    pastedimage1595581271790v5.png

    pastedimage1595581138976v4.png

  • 88710815-a192-4ece-9324-8d7ddf313899 Profile Picture
    10 on at

    Hi Guru,
    is this issue resolve for you, if yes, could you please guide me how you get data in DAX entities ?

    Regards,

    Vijay Y

  • qamar-crm Profile Picture
    10 on at

    Hi Ziyao 

    I am having the same issue, I have figured-out the DUAL-WRITE tables of F&O and CE as well but according to Microsoft documentation we need to trigger an event from CE side to calculate the Inventory in F&O data entity then it is written to Dataverse by dual-write.

    How can I trigger the event if I am not on Quote, order or Invoice page ? Do we have this event information publicly exposed ?

    Thank you,

    Qamar

  • S Shambhu Profile Picture
    444 on at
    Hi All, I am having the same issue. Looking forward to your suggestions.
     
    Thank you 
    Shambhu

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 422 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans