[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

MS Dynamics Shutsdown Running AR Trial Balance

Posted on 2013-12-19
3
Medium Priority
?
604 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 2000 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
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…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

649 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