Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Answered

Getting "InventOwner_RU record already exists" on creating Sales Order

(0) ShareShare
ReportReport
Posted on by 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
  • Mariano Melo Profile Picture
    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
    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
    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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans