web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Getting an error using...
Business Central forum

Getting an error using the Dynamics GP Migration extension to Migrate from GP2018 to Business Central

(0) ShareShare
ReportReport
Posted on by Joe Critchlow 1,145

We are getting the following error when we try to use the files that are exported from Dynamics GP2018 using the Migration extension in Dynamics 365 Business Central. We are choosing to use the existing COA from Dynamics GP.

"The Data does not represent a valid JSON Token"

Any help would be greatly appreciated.

Joe

Categories:
Other
Data Migrations
I have the same question (0)
  • Joe Critchlow Profile Picture
    Joe Critchlow 1,145 on at
    RE: Getting an error using the Dynamics GP Migration extension to Migrate from GP2018 to Business Central

    Kristen, thanks so much for pointing us in the right direction. We found an extra ] in the code file, after removing the migration got past the error.

  • Verified answer
    Kirsten S Profile Picture
    Kirsten S 20 on at
    RE: Getting an error using the Dynamics GP Migration extension to Migrate from GP2018 to Business Central

    Joe -

    If you look at your account json file within the zip file, you most likely have a character that is messing with the json, start by looking for a \ or /.  The other option could be extra carriage returns in the json for accounts.  Since the migration works when you use a new COA, the issue should be in the account json file.

  • Joe Critchlow Profile Picture
    Joe Critchlow 1,145 on at
    RE: Getting an error using the Dynamics GP Migration extension to Migrate from GP2018 to Business Central

    Hi Kristen,

    We are choosing to use the existing COA and not posting, as soon as we select the zip file we get the error.

    Joe

  • Kirsten S Profile Picture
    Kirsten S 20 on at
    RE: Getting an error using the Dynamics GP Migration extension to Migrate from GP2018 to Business Central

    At what point in the process are you getting the error?  You have exported the data via Dynamics GP, choose to use the existing COA, what do you choose for your posting option?  Do you receive the error when you map to the .zip file?  At what point and what exact steps are you doing?

  • Joe Critchlow Profile Picture
    Joe Critchlow 1,145 on at
    RE: Getting an error using the Dynamics GP Migration extension to Migrate from GP2018 to Business Central

    Hi Kristen,

    We are on R2 18.00.0704. The migration actually works if we choose to supply a new COA, however if we use the current COA that we have we get the error.

    Joe

  • Kirsten S Profile Picture
    Kirsten S 20 on at
    RE: Getting an error using the Dynamics GP Migration extension to Migrate from GP2018 to Business Central

    Joe -

    What release of Dynamics GP2018 are you using?  The support for  JSON was added with the GP2018R2 release so if you are on an earlier version of GP2018 the exported files will not be in the correct format.

  • Joe Critchlow Profile Picture
    Joe Critchlow 1,145 on at
    RE: Getting an error using the Dynamics GP Migration extension to Migrate from GP2018 to Business Central

    Hi Olister,

    We are using the migration business data under from setup under Setup and extensions.  We are following the following instructions -  docs.microsoft.com/.../ui-extensions-dynamicsgp-data-migration.

    Joe

  • Suggested answer
    Olister Rumao Profile Picture
    Olister Rumao 3,963 on at
    RE: Getting an error using the Dynamics GP Migration extension to Migrate from GP2018 to Business Central

    Hi Joe,

    Can you tell what all steps you are following to Migrate Data from GP2018 to BC?

    I think you are using wrong WebService Key in Business Central > Users has something to do with when you are connecting BC to GP

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans