D365 Integration With Odata : Data Entity Write Failed

(0) Share

Report

Posted on by Community Member

Hi All,

I am working with integrating sales order along with shipping charges into D365 FO using ODATA.

I have created custom package with new Data Entity for mapping Shipping Charge amount. Below was the error i see while creating sales order through Odata.

Write failed for table row of type 'MySalesOrderHeaderChargeEntity'. Infolog: Warning: Matching record for the read only data source 'SalesTable' does not exist.","type":"Microsoft.Dynamics.Platform.Integration.Services.OData.AxODataWriteException"

but surprisingly the same solution working on another instance which is running on different system..

D365 FO Apllication and platform versions used:

Product version: D365 FO 8.1

Platform Update: 20(7.0.5030.35333)

Can any one help me out to how to trace this and resolve.

Categories:

Development / Customization / SDK

Data Integration

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

as it works in other instance, check to see on access, build/deployment is same, PU is same

Restart DIXF services and try and suggest

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Rahul,

Thanks for the quick response.

i tried restarting DIXF service but still same error. and PU is same on both instance

what access do i need to verify ? what do you mean by build/deployment same . Can you please elaborate more as i am new to D365 FO Development.

i also tried performing full build of my model but no luck.

Was this reply helpful? Yes No
Martin Dráb 237,924 Most Valuable Professional on at

Like (0)

Report

It says that you're trying to add charges to a non-existing sales order.

If you assume that the order exists, your assumption seems to be wrong. It works in the other environment because such an order already exist there.

If the order was supposed to be created before importing charges, it sounds like your actual problem is in the order creation.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i was trying to add charges to the order along with order creation using OData and order will be created simultaneously.

Yes,the order will be created by OData integration first and then charges will be applied. the same working fine on other environment.

just curious and want to know why it was not working on my new instance.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i am using SalesOrderHeaderChargeEntity standard data entity for applying freight charges for the sales order thorugh Odata

Was this reply helpful? Yes No
Verified answer

Daniel Weichsel on at

Like (1)

Report

"just curious and want to know why it was not working on my new instance."

Are you relying on the user default legal entity in your OData requests, and is it different in the new instance?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i am using specific legal Entity and same reading using my application configuration. which is same on both instance "USMF"

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Thanks Daniel.

Changing default legal entity in user preference settings actually resolved issue.

Was this reply helpful? Yes No