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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Planned Orders Entity ...
Supply chain | Supply Chain Management, Commerce
Answered

Planned Orders Entity : File contains duplicate rows, cannot insert data into staging due to unique key violation

(0) ShareShare
ReportReport
Posted on by Zain Mehmood 4,187 Most Valuable Professional

Hi All,

I am trying to upload Planned orders through the Planned orders entity. I am getting the following error, my sheet contains only single row.

pastedimage1600035487184v1.png

This is my sheet

pastedimage1600035530744v2.png

Any help would be appreciated in this.

Regards,

Zain Mehmood

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Hi Zain,

    Are you using an Excel file as sourse format or another, like xml, txt or csv?

    Can you check if there are empty lines at the end of the file?

  • Verified answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,093 on at

    Hi Zain,

    Planned orders entity is read-only entity, so you can only export data through it. Can't you import document that should be creaed planned orders directly (Purcahse, production order..)?

    pastedimage1600064965186v1.png

  • Zain Mehmood Profile Picture
    Zain Mehmood 4,187 Most Valuable Professional on at

    HI Andre,

    Checked already, I am using Excel File with no rows at the bottom.

    Regards,

    Zain

  • Zain Mehmood Profile Picture
    Zain Mehmood 4,187 Most Valuable Professional on at

    Hi Sergei,

    My requirement is to create multiple packing SKU's from the same bulk order.

    If i create the production order directly, i have to calculate the net requirements manually for the bulk production orders.

    If i use the pegged supply option, bulk item orders are created separately for the same type multiple packing SKUs.

    The orders for bulk items are grouped only in the planned orders window.

    Regards,

    Zain

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 298 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 179 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

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

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans