Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Rapid Migration Tool Error Message When Importing data from Excel Template to GP2010 Company

Posted on by Microsoft Employee

Hi All,

When running the Rapid Migration tool( Excel Template option) I am getting the below message:

"The maximum segment length in Microsoft Dynamics GP account framework is smaller than maximum account length in Peach Tree. You must uninstall and re install Dynamics GP and create an account framework that uses at least seven Characters for each segment.:

My Scenario is I am trying to import data from "excel" to Dynamics GP company . After clicking Next  button in the "Master Records export Results" window I am getting the above message. Also after clicking the next button getting an Unhandled exception with below message:

Value of -1 is not valid for value. Value should be between Minimum and Maximum value.

Also in the  Chart of Accounts Migration Segment existing window - the "Next Button"is disable

Also is there a way to uncheck the "chart of accounts" option in the Data Type Selection window/section.

Please advice

Thanks.

*This post is locked for comments

  • GloriaB Profile Picture
    GloriaB 981 on at
    RE: Rapid Migration Tool Error Message When Importing data from Excel Template to GP2010 Company

    Develop an understanding of the difference between the account framework and the account format. The framework is created when you first install GP code, using GP utilities the framework for the first two segments must be at least 7 characters in length. Then when you create the account format in the company, those also must be at least 7 characters in length.

    OR alternatively, you have an account in your Excel worksheet that is missing an account segment.

    The "Next" button will be disabled until the above is resolved. With the chart of accounts, it's an all or nothing process.

    There is no way to disable the chart of accounts option because all the other records refer back to the chart of accounts, so it's the minimum that you can use the RMT for.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans