Skip to main content

Notifications

Announcements

No record found.

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

  • Mr D365 Profile Picture
    Mr D365 414 on at
    On - Hand Inventory Dual write Integration issue
    Hi All, I am having the same issue. Looking forward to your suggestions.
     
    Thank you 
    Shambhu
  • qamar-crm Profile Picture
    qamar-crm 10 on at
    RE: On - Hand Inventory Dual write Integration issue

    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

  • RE: On - Hand Inventory Dual write Integration issue

    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

  • Suggested answer
    Ziyao Profile Picture
    Ziyao on at
    RE: On - Hand Inventory Dual write Integration issue

    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

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,791 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,488 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans