Solved

MS Dynamics Shutsdown Running AR Trial Balance

Posted on 2013-12-19
3
551 Views
Last Modified: 2013-12-19
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?
0
Comment
Question by:nursecore
3 Comments
 
LVL 18

Expert Comment

by:Victoria Yudin
ID: 39730018
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
 
LVL 18

Accepted Solution

by:
Steve Endow earned 500 total points
ID: 39730464
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
 

Author Comment

by:nursecore
ID: 39730483
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

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now