25 June 2009

Illegal Characters in Dynamics GP

No, David Musgrave not talking about immigration or unlawful users in his latest set of posts. In a two part series, Dave takes on illegal characters in Dynamics GP. There are times when quotes, backward single quotes and carriage returns can really screw up your data and David tackles dealing with these issues. Mariano Gomez has also jumped in with his own take on this issue.

I've seen issue this mostly with importing and exporting data. We had one import that added a carriage return to the end of a ton of master records. The data looked correct on the screen but would be blank on reports. That was fun to find and fix.