Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / License Issue while im...
Microsoft Dynamics NAV (Archived)

License Issue while importing Text file generated for NAV - CRM Integration

(0) ShareShare
ReportReport
Posted on by Sarav 429

NAV_5F00_CRM.jpg

I'm working on NAV 2016 integration with CRM 2016 (Dynamics 365) in Native connector available in NAV.

We have few Custom Fields in Order screen (CRM) and Sales Order (NAV).

I used cmdlet 'NEW-NAVCRMTable' from the following MSDN link to generate the text file:

https://msdn.microsoft.com/en-us/library/mt574341(v=nav.90).aspx

After generating the text file, tried to import the file into NAV but we are getting license issue. The database is with Developer license only. Please find the attached screenshot for reference. Kindly guide on the above issue whether any steps is missing in the process.

Thanks in advance.

*This post is locked for comments

  • Verified answer
    Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,567 on at
    RE: License Issue while importing Text file generated for NAV - CRM Integration

    Hi

    The Text file you are importing don't have the field "ModifiedOnBehalfBy" which exists in the table, that is the reason you are not able to import your text file.

    do the below to import your text file.

    1, export the 5353 table in text format from NAV

    2, compare your file and the file you exported from NAV

    3, Merge those fields which are missing in your text file and import. 

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 44,656 on at
    RE: License Issue while importing Text file generated for NAV - CRM Integration

    Based on the error message, currently i.e. before import there is a field called ModifiedOnBehalfBy in the table but in the import file that field is missing so it has to delete that field from the table, since the table and field are in a standard object range normally we don't have permission to delete those, you can do that only by importing .fob using merge fields but not using .txt.

  • Sarav Profile Picture
    Sarav 429 on at
    RE: License Issue while importing Text file generated for NAV - CRM Integration

    The generated Text file contains new fields and the Field No. are not in 50000 series. I guess the importing is stopped because of that reason.

    I even tried another method by manually creating the same field in the table '5353' as 50000 series and compiled it. It didn't show any error. Then, I kept those fields in pages '5353' & '5374'. Then in RTC navigated & clicked on the page 'Microsoft Dynamics CRM Sales Orders', the instance automatically closed without any message.

    How to import the text file with Field no. of NON '50000' series. Please guide me if we need to any special license for the Text file importing.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: License Issue while importing Text file generated for NAV - CRM Integration

    Are these fields are part of any specific object add-on ?  

    You need to check your license

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans