When using the data export tool (Maintenance>Export Data) for accounts, if any account segment (Tools>Setup>Financials>Segment) has a single quote " ' " in the description, the process will fail with an error

"Microsoft SQL Server Native client 11.0 SQL Server Incorrect syntax near 's' Microsoft SQL Server Native client 11.0 SQL Server SQL Server Unclosed quotation mark after the character string "

To work around the issue you must change all account segment descriptions and remove any single quotes (do not rolling down the changes to accounts)
Category: Tools - Other
Needs Votes



Hello Microsoft development team, Please consider implementing a fix for this issue as it will perfect the overall product and also provide an error free method to export the required Account data for migration purposes. I do look forward to your response on this matter.

Category: Tools - Other