MS Dynamics Shutsdown Running AR Trial Balance

I am having the crazy issue running an AR Trial Balance for one Class ID.  I can run for any other Class ID except for the one ID.  If I run a range of Class ID's that can that contain that I'd it does the same thing.  You can print the report to the screen and see the whole thing, but you can't print or export.  Immediately upon hitting print you get the attached error and GP's shuts down.  This happens running any of the Trial Balances...detail and summary.  I have Reconciled, run Check Links on the whole Sales Module...nothing has worked.  

We have Dynamics GP 10.  Has anyone else ever seen this issue?  Any ideas on what to try next?
nursecoreAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Steve EndowConnect With a Mentor Microsoft MVP - Dynamics GPCommented:
Hi,

I saw something similar with a client several years ago.  If they tried to run an AP aging report it would crash.

We eventually narrowed it down to a few vendors and found one that had an apostrophe. But instead of an apostrophe, the user had typed the "grave accent" character (the key above tab, next to the 1 key--http://en.wikipedia.org/wiki/Grave_accent).

That non-standard ASCII character caused Report Writer to crash.

Since you have narrowed it down to a particular class ID, I would do a quick check of all of the customer IDs in that class.

Victoria's recommendation above is another variant of this issue, but it looks like we are both leaning towards the same cause.

I just tested the grave access in GP 2010, and it doesn't seem to cause any problems, so it looks like that 'bad character' issue might be with older versions of GP.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0
 
Victoria YudinOwnerCommented:
Was there an error attachment? I don't see it...

Have you checked to see if you have any 'blank' customers? You can run the following in SQL:

select * from RM00100 where CUSTNMBR = ''

Open in new window

0
 
nursecoreAuthor Commented:
Hilarious...I took the same steps and discovered the same thing...even before the solution was posted.  Should have waited...might have took less time.
0
All Courses

From novice to tech pro — start learning today.