Error message when you convert Intuit QuickBooks data by using the Rapid Migration Tool (RMT) for Microsoft Dynamics GP: "Illegal characters in path"

This article has been archived. It is offered "as is" and will no longer be updated.
Assume that you use the Rapid Migration Tool (RMT) for Microsoft Dynamics GP to convert Intuit QuickBooks data into the Microsoft Excel format. However, when you perform the "Exporting data into Excel" process, you receive the following error message:
Location: ExcelManager.InitializeExcelManager
Exception Type: System.ArgumentException
Source: mscorlibMessage: Illegal characters in path.
TargetSite: CheckInvalidPathChars
To work around this problem, delete the special characters from the company name in Microsoft Dynamics GP 10.0. To do this, follow these steps:
  1. Use the sa login to start Microsoft Dynamics GP.
  2. On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to Company, and then click Company.
  3. In the Company Name field, determine whether there are any special characters. If there are, delete them. For more information about special characters, see the "More information" section.

    Note A test company that uses the <TEST> clause within the name is also affected. Temporarily delete "<TEST>" when you use the Rapid Migration Tool.
  4. To save and close the Company Setup window, click OK.
  5. Run the Rapid Migration Tool to perform the "Exporting master data into Excel" process.
  6. When the Rapid Migration Tool has completed the migration process, you can revert the company name to any name that you want, as long as it contains only Microsoft Dynamics GP-compliant characters.
More information
Special characters include, but are not limited to, the following.
Character Name
Tilde ~
Acute accent `
Exclamation point !
At sign @
Number sign #
Dollar sign $
Percent %
Caret ^
Ampersand &
Asterisk *
Opening parenthesis (
Closing parenthesis )
En dash -
Plus sign +
Equal sign =
Opening brace {
Closing brace }
Opening bracket [
Closing bracket ]
Vertical bar |
Backslash \
Forward slash /
Quotation mark "
Colon :
Apostrophe '
Left angle bracket <
Right angle bracket >
Question mark ?
Period .
Comma ,
More information
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.
great plains excelmanager.initializeexcelmanager illegal characters in path checkinvalidpathchars rmt

Article ID: 958367 - Last Review: 05/12/2015 12:35:08 - Revision: 4.0

  • Microsoft Dynamics GP 10.0
  • System Manager
  • kbnosurvey kbarchive kbexpertiseadvanced kberrmsg kbexpertisebeginner kbtshoot kbmbsmigrate kbprb kbexpertiseinter KB958367