RM Statement printing issue

[swabunn]

Great Plains: 7.5
SQL Server:2003

we have weired problem while printing RM statments. If we choose sort by "customer name", it just kick the users out from the system and we use any other sort by option like "customer id" etc. it works fine.The problem is that users wants to print by customer name.

Thanks

Swabunn

 

[winthropdc]

I suspect you have a special character in one of the names.

The back quote character "`" (below the ~ key) has special meaning to Dexterity and can cause issues when report writer sorts by a field containing that character.

The single quote character "'" can cause problems at the SQL level, but that can be coded around and any bugs caused by this are normally fixed quickly.

Use the following queries to search for this.

select * from RM00101 where CUSTNAME like '%`%'

select * from RM00101 where CUSTNAME like '%''%'

If you find a back quote, replace it with a single quote and it should fix the issue.

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[swabunn]

Thanks David, It works