|
|
|
|
|
|
|
|
|
|
|
| |
 Answer |
|
| |
If you have single quote chars in your doc numbers, you will have to first
identify all the document numbers that are affected in all the tables:
SELECT * FROM PM00400 WHERE DOCNUMBR LIKE '%''%'
SELECT * FROM PM10201 WHERE DOCNUMBR LIKE '%''%'
SELECT * FROM PM10300 WHERE DOCNUMBR LIKE '%''%'
SELECT * FROM PM10400 WHERE DOCNUMBR LIKE '%''%'
SELECT * FROM PM20000 WHERE DOCNUMBR LIKE '%''%'
SELECT * FROM PM30200 WHERE DOCNUMBR LIKE '%''%'
SELECT * FROM PM50100 WHERE DOCNUMBR LIKE '%''%'
SELECT * FROM PM80200 WHERE DOCNUMBR LIKE '%''%'
SELECT * FROM GL20000 WHERE ORDOCNUM LIKE '%''%'
Once you identify the document numbers you will need to have a plan to
correct them. Your plan should include making sure the new document number is
not going to create a duplicate situation. You can then proceed to update the
affected records as follows:
UPDATE PM00400 SET DOCNUMBR = 'NEW_DOC_NUM' WHERE DOCNUMBR = 'XY''Z'
UPDATE PM10201 SET DOCNUMBR = 'NEW_DOC_NUM' WHERE DOCNUMBR = 'XY''Z'
UPDATE PM10300 SET DOCNUMBR = 'NEW_DOC_NUM' WHERE DOCNUMBR = 'XY''Z'
UPDATE PM10400 SET DOCNUMBR = 'NEW_DOC_NUM' WHERE DOCNUMBR = 'XY''Z'
UPDATE PM20000 SET DOCNUMBR = 'NEW_DOC_NUM' WHERE DOCNUMBR = 'XY''Z'
UPDATE PM30200 SET DOCNUMBR = 'NEW_DOC_NUM' WHERE DOCNUMBR = 'XY''Z'
UPDATE PM50100 SET DOCNUMBR = 'NEW_DOC_NUM' WHERE DOCNUMBR = 'XY''Z'
UPDATE PM80200 SET DOCNUMBR = 'NEW_DOC_NUM' WHERE DOCNUMBR = 'XY''Z'
UPDATE GL20000 SET ORDOCNUM = 'NEW_DOC_NUM' WHERE ORDOCNUM = 'XY''Z'
You will need to do this for each affected document number
Make sure you take a look at David Musgrave's new series of articles on
Microsoft Dynamics GP and Illegal Characters at
http://blogs.msdn.com/developingfordynamicsgp/archive/2009/06/22/microsoft-dynamics-gp-and-illegal-characters-part-1.aspx
Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
"Caroline" wrote:
> Hello,
>
> I get the error:
>
> The stored procedure pmHistoricalAgedTrialBalance returned the following
> result: DMBS: -127, Microsoft Dynamics GP: 0.
>
> I read this may be related to a single quote character in Vendor ID, but
> there are not any. However there are single quotes in Document Number.
>
> If this is what is causing the problem, how can we fix it without manually
> changing all the doc numbers?
>
> Thank you,
>
> Caroline |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
Question
Notify me of replies
