Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Problem by setting CustomerId of SalesOrder from NAV | Creating Entity with an invalid parent

Posted on by 30

Hi,

I'm currently developing a one way synchronisation (NAV -> CRM).

It was quite easy to set up the entity tables for NAV. I used the command New-NAVCRMTable of the Nav-Developershell.

Everything works fine only the account table throws an KeyNotFound Exception.

After spending hours on this problem i decided to solve this problem manualy.

So I used an older Entity-Table of the CRM Account table and modified it.

After that i looked at the table input and it worked fine.

At this Point i thought i was done and could create a SalesOrder from NAV in CRM just by filling some fields with data.

Mostly i was right, ic was able to create a SalesOrder with the SalesOrderDetails and the current AB-number etc.

But surprisingly in the Entity-Table of the SalesOrder was no "CustomerId", "CustomerIdName" and "CustomerIdTypeCode".

I added these 3 Fields manually. The CustomerId and CustomerIdName do a lookup to my Account Entity Table.

When i look into the Table, the fields get filled perfectly. But when i try to change the value of the CustomerId Field, i get this Error:

"Creating Entity with an invalid parent. Entity: SalesOrder, ReferencingAttribute:customerid"

Does anyone know what i do wrong? Did i maybe miss an Option which has to be set?

*This post is locked for comments

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans