Finance | Project Operations, Human Resources, ...

How to duplicate Customer Free Text Invoice Data Entity ?

(0) Share

Report

Posted on by Community Member

Hi I am using Customer free text invoice data entity to import free text invoice,

The entity has Customer invoice table and Customer invoice line as the data source,

Client ask New custom Customer Free Text Invoice entity with additional field and the property ispublic enabled.

So, I Duplicate the standard entity , staging table, privilege's, And changed the name, Properties and Logics as per my duplicate objects,

And did the full build and sync , Build completed without error.

when i try to export it works as expect, But while import It throw the error and did not hit the debugger also.

1538.pastedimage1616131745189v3.png

8446.pastedimage1616131771483v4.png

Please guide me what I missed.

Thanks.

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

moved to the d365 forum

Was this reply helpful? Yes No
nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

Did you check Staging log details?

Was this reply helpful? Yes No
WillWU 22,363 on at

Like (0)

Report
Copy link

Link copied!

Hi Sudhakar Venkatesan,

Is the import file Excel? please check if it contains any empty rows.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Nikolaos Mäenpää

yes, I checked data in staging, when export staging hold the data but while import I am getting error before data move to staging.

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Will Wu

No, file don't have issues, I Tried that file with standard Customer Free Text Invoice entity, It's working fine.

Thanks.

Was this reply helpful? Yes No
nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

You didn't yet answer if you checked Staging log details. That's the button that you see in your first screenshot.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Nikolaos Mäenpää,

I checked the log description it shows the following Log Description " The data value violates integrity constraints. "

Thanks.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Sudhakar,

great, this tells us that your data has some issue vs your entity definition.

Usually this error message means that you have duplicate rows in your file. Duplicate means : many records that have same values in the entity key field(s).

Please double check your entity key, and compare your data against it.

Was this reply helpful? Yes No