Hi,
The requirement is to be able to export data via OData to the SalesJournalAutoSummary table. By default, such a solution is not available, so I created a new data entity from using the wizard. Everything is OK when the user opens the excel file and downloads the data via OData from D365. The problem arises when he wants to add new data and publish it.
I have already made many custom data entities to export and never had this problem, but unfortunately still exists here..
I created a data entity, added the appropriate fields to the entity key. I set the "Is Read Only" to "No." I updated the staging table..
When trying to publish the data, a message appears:
Details:
A row created in data set SalesJournalAutoSummaries was not published. Error message: 'Write failed for table row of type 'cst_SalesJournalAutoSummaryEntity'. Infolog: Info: Unable to create a record in table SalesJournalAutoSummary. Form: No, Customer.
Record already exists...'
Can anyone explain why there is a problem with the "No" and "Csutomer" values here?
And after publishing it creates a new line with these values...
