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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Getting "InventOwner_R...
Supply chain | Supply Chain Management, Commerce
Answered

Getting "InventOwner_RU record already exists" on creating Sales Order

(0) ShareShare
ReportReport
Posted on by m 53
Hello,
 
I am getting below error when creating Sales Order. 
 
/The record already exists in InventOwner_RU table./
 
Any help would be appreciated.

Thanks
I have the same question (0)
  • Mariano Melo Profile Picture
    Mariano Melo 332 Moderator on at
    Getting "InventOwner_RU record already exists" on creating Sales Order
    Hi m
    Adding on what Kevin posted. 
    That table works for Consignment inventory feature (inventory owner). 
     
    Are you working on with consignment items? check if the item you are including in the sales order is for consignment and if so, it must have a vendor associated.
     
    i leave you the consignment MS Learn link for you to check out.
  • m Profile Picture
    m 53 on at
    Getting "InventOwner_RU record already exists" on creating Sales Order
     Any pointers to resolve this issue?
  • Verified answer
    Kevin Xia Profile Picture
    Kevin Xia 4,033 Microsoft Employee on at
    Getting "InventOwner_RU record already exists" on creating Sales Order
    Hi,
    Based on the problem you described, I have some suggestions for your reference:
    • Check for duplicate records: First, ensure that you have checked the InventOwner_RU table before creating the sales order to verify that there are no duplicate records. You can use data queries or relevant data management tools to validate if any duplicate records exist.
    • Fix the duplicate records: If you have identified duplicate records, you can resolve the issue by deleting or modifying one of the duplicates. Be cautious while performing this operation and make sure to select the correct record for the fix.
    • Data integrity check: Ensure that all required data and related fields are correctly filled in and set when creating the sales order. Missing or incorrect data can lead to duplicate records or other data issues.
    Best regards,
    Kevin

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans