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 / Failed to insert recor...
Supply chain | Supply Chain Management, Commerce
Unanswered

Failed to insert record into staging table. The keys of the record are DEFINITIONGROUP, EXECUTIONID, PARTITION, RECORDID. Duplicate records must be removed from the file prior to import.-The duplicate key value is (5637144576, sales price agrem import, sal

(0) ShareShare
ReportReport
Posted on by amineit 205

Hello everyone, I hope you are fine.

I want to import File " Sales price agreement" in data management, So I get this error 

"Failed to insert record into staging table. The keys of the record are DEFINITIONGROUP, EXECUTIONID, PARTITION, RECORDID. Duplicate records must be removed from the file prior to import.-The duplicate key value is (5637144576, sales price agrem import, sales price agrem import-2023-01-04T02:58:54-33403ECEC3654302B2CB7412E42A824C, 0)
'0' 'Sales price agreements' record(s) inserted in staging"

 So, I tried to auto increment the "RECORDED ID" but doesn't work. it's send me a message

"Non-editable fields were not allowed to mark as Auto default or Auto-generated "

0001.PNG

I have the same question (1)
  • Martin Dráb Profile Picture
    Martin Dráb 237,801 Most Valuable Professional on at

    SalesPriceAgreementEntity should be read-only, IMHO. Trying to import records directly to PriceDiscTable is logically wrong and setting RecId from outside isn't possible.

  • amineit Profile Picture
    amineit 205 on at

    I didn't find "PriceDiscTable" in the Export DATA MANAGEMENT

  • Martin Dráb Profile Picture
    Martin Dráb 237,801 Most Valuable Professional on at

    PriceDiscTable is a table, not a data entity. It's a data source of SalesPriceAgreementEntity, therefore you're already trying to import data to PriceDiscTable when you're importing through SalesPriceAgreementEntity. And I'm arguing that it's a wrong thing to do. Changes to prices should be done through trade agreement journals instead of written directly to PriceDiscTable. Trade agreement journal tables are used in several entities, such as Trade agreement journal headers.

  • amineit Profile Picture
    amineit 205 on at

    Thank you Sir

  • amineit Profile Picture
    amineit 205 on at

    One question, please,

    How I can import lists of sales price items at one time?

  • Martin Dráb Profile Picture
    Martin Dráb 237,801 Most Valuable Professional on at

    I guess that Trade agreement journal headers V2 (TradeOpenTradeAgreementJournalHeaderV2Entity) + Open sales proce journal lines V2 (SalesOpenSalesPriceJournalLineV2Entity) would do the job.

  • amineit Profile Picture
    amineit 205 on at

    Thank you so much

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
Siv Sagar Profile Picture

Siv Sagar 283 Super User 2025 Season 2

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 213 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

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

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans