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 / 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,173 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)
  • Zain Mehmood Profile Picture
    Zain Mehmood 4,173 Most Valuable Professional on at
    RE: Planned Orders Entity : File contains duplicate rows, cannot insert data into staging due to unique key violation

    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

  • Zain Mehmood Profile Picture
    Zain Mehmood 4,173 Most Valuable Professional on at
    RE: Planned Orders Entity : File contains duplicate rows, cannot insert data into staging due to unique key violation

    HI Andre,

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

    Regards,

    Zain

  • Verified answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,093 on at
    RE: Planned Orders Entity : File contains duplicate rows, cannot insert data into staging due to unique key violation

    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

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 298,959 Super User 2025 Season 2 on at
    RE: Planned Orders Entity : File contains duplicate rows, cannot insert data into staging due to unique key violation

    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?

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,011

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 215 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans