By now you probably read David Musgrave's series on Microsoft Dynamics GP and Illegal Characters
and have come to realize that the single quote character is perhaps one of the biggest culprits in the errors you are receiving when running reports such as your age trial balances in both receivables and payables. It's enough for the single quote character to be in your customer ID, vendor ID, or even document numbers to cause some error while running a report or inquiring a transaction.
The following is an actual case
reported by a user on the Dynamics GP newsgroup when running the Payables Historical Aged Trial Balance report:The stored procedure pmHistoricalAgedTrialBalance returned the following
result: DMBS: -127, Microsoft Dynamics GP: 0.
After some research the user realized they had a few document numbers that contained the illegal single quote character, for example INV'23002. Note that this case is specific to the document number.
So, what to do if you are a victim of the single quotes?
1) You will need to first identify the tables…