4
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)
"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)
STATUS DETAILS
Declined
Comments
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
Administrator on 4/27/2023 12:05:39 PM
Thanks for the suggestion, there will be no changes to this fuctionality at this time.
Microsoft