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

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 (3)
  • Martin Dráb Profile Picture
    Martin Dráb 238,916 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 238,916 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 238,916 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February 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 218 Super User 2026 Season 1

#2
Mallesh Deshapaga Profile Picture

Mallesh Deshapaga 172

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 115 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans