News and Announcements icon

Dynamics 365 CommunityForums Power Platform integration forum The detail cannot be u...

Power Platform integration forum

Answered

The detail cannot be updated because the parent is not editable. Dual write

(1) Share

Report

Report

Posted on by Viswanath M

40

While running the sales order line table mapping in dual write it throws error The detail cannot be updated because the parent is not editable. I have runned all related table mappings.

Anyone helps me to sort-out this error.

The detail cannot be updated because the parent is not editable.

The detail cannot be updated because the parent is not editable.

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Viswanath M 40 on at

Like (0)

Report

The detail cannot be updated because the parent is not editable. Dual write

This error is due to sales order header created first in CE with invoiced status. So, for those invoiced order we can't create the lines.

I solved this problem by changing the status field in header table mapping. Change invoice code to active code and then run sales order line. After running successfully, I have again changed the status code to original and run header.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,572 Super User 2024 Season 2

#2

Martin Dráb 228,792 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans