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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Error: Cannot create a record. The record already exists. - Custom data entity D365

(0) ShareShare
ReportReport
Posted on by 65

Hi, We need help against the following scenario.

Summary:

We have created a custom entity which create discount lines [Retail and commerce ->Pricing and discounts ->Discounts] against a discount scheme. The following problem occurs when we provide 15k+ records in excel. If we try to import the same data in chunks it gets uploaded successfully.

Error:

Results. Field 'Reference' must be filled in.

Cannot create a record in Periodic discount line (RetailPeriodicDiscountLine). Discount: 000040.
The record already exists.

We've checked and there is no duplicate record, nor we have any reference field in our entity or data source.

Additional Details:


If we try to upload the records without batch then it get stuck after uploading 60% data the job stays in execution but record insertion is stopped (checked through SQL), if we ran it in a batch it uploads around 60% data and throws error against the rest of them (as shown in screenshot) and the job completes as "Partially completed "

 

51473.Error.png

Any help in this regard will be highly appreciated. Thank you.

*This post is locked for comments

I have the same question (0)
  • Muhammad Zain Ul Abiddin Profile Picture
    65 on at

    It's been a day, anyone?

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…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans