Hello everyone,
I’m facing an issue in Dynamics 365 Finance and Operations when trying to upload sales order lines to existing sales orders using templates.
The problem is that if I upload a template with a single line, it works fine. But if I try to upload multiple lines, I get the following error:
"Cannot insert record in staging table. Record keys are DEFINITIONGROUP, EXECUTIONID, INVENTORYLOTID, PARTITION. Duplicate records must be removed from the file before importing."
The thing is, I’m not repeating any data. I actually need to upload multiple items into the same sales order, so this error doesn’t make sense to me.
Has anyone faced this issue or knows why D365 is treating my lines as duplicates when they are not?
Thanks in advance.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 575
André Arnaud de Cal... 245 Super User 2025 Season 2
BillurSamdancioglu 187 Most Valuable Professional
