Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Unanswered

Plugin Issue onto Work Order Product Entity

Posted on by 20

Hey,

I am trying to create one Work Order Product (same product) for multiple work orders in Field Service Module, I am having a error as below. Can anyone help me with 

Error - "There can't be two active records for the same warehouse, product, and unit."

1. What makes a work order product unique ?

2. The below are the 3 OOTB  plugins causing this issue 

Field Service: Create (post-operation) for msdyn_workorderproduct]

Field Service: Create (post-operation) for msdyn_inventoryjournal]

Field Service: Update (pre-operation) for msdyn_productinventory]

pastedimage1605565619162v3.png 

pastedimage1605565673822v4.png

  • vince.perta Profile Picture
    vince.perta 34 on at
    Plugin Issue onto Work Order Product Entity
    I'm faced with this same error message, and this post is the only thing I've found that mentions it.  In my cases, it's been happening when through Dual-Write updates from D365 F&O to CE:
    • When trying to receive a PO:
      • Unable to write data to entity msdyn_purchaseorderproducts.Writes to PurchPurchaseOrderLineCDSEntity failed with error message Request failed with status code BadRequest and CDS error code : 0x80040265 response message: There can't be two active records for the same warehouse, product, and unit.
    • When a PO approval workflow is trying to complete:
      • Unable to write data to entity msdyn_purchaseorders.Writes to PurchPurchaseOrderHeaderV2Entity failed with error message Request failed with status code BadRequest and CDS error code : 0x80040265 response message: There can't be two active records for the same warehouse, product, and unit.
    Has anyone out there had any luck in determining what kind of records this is referring to, or how to overcome it?  

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans