GP 2013 error voiding checks

 

The Problem:

When you try to void a check in GP2013, you get the following error:

Batch batchname failed to complete posting. Use the Batch Recovery window to complete the posting process. When you click on the More Info button you see the following:

A save operation on table ‘ME_Void_Checks’ cannot find the table.

[Microsoft'][SQL Server Native Client 10.0][SQL Server]Invalid object name  ‘company database name.dbo.ME123506’.

Of course, the Batch Recovery window is no help.

The error occurs whenever you void a check, no matter which window you choose to void it from (PM or Bank Rec). This error is caused by the Safe Pay product. There is an old KB article explains the problem and shows you how to fix it, but it doesn’t fix it (it’s an old KB article).

ME_Void_Checks Failed Accessing SQL Data ... - Microsoft Support

After reading the KB article, I found out that the culprit is the Safe Pay product. Still, I went through the steps suggested by the KB article.

First, I tried Resolution 2 to fix it (because it was easier). I ran the Grant.sql script against the system and company databases, but it did not fix the problem.

Next I tried Resolution 1. “Run the installation routines again from the shortcut bar.” I did not have any such thing to run from my shortcut bar. I hunted around for a window that I could add to my shortcut bar, but none of them looked promising. I abandoned that effort.

The error message actually does tell us what’s wrong, the database is missing the ME123506 table.

The Fix:

Since the system couldn’t find the table, go to SQL Maintenance, select the Safe Pay product, and created the table. Viola! Problem solved.

Until next post!

Leslie

Problem with dual install of 2010 and 2013

Both GP 2010 and GP2013 are installed on my local computer. That machine is also the SQL server.

The Problem:

I created a new user  (USER1) in GP2013 and gave him access to the Fabrikam company, which was database TWO01. The system database was named DYN131.

• USER1 was granted access to Fabrikam.
• USER1 was a power user

Whenever I tried to log in as USER1, I was greeted with this:

I was definitely typing in the correct user name and password. Finally, I went directly to the SQL server and blanked out the password. The blank password didn'’t work either.

The Solution:

I checked the SQL Server to make sure USER1 was listed as a Login to the server and was mapped to the both the TWO1 database and the DYN131database. No problems there. I then checked the DYN131 and TWO1 databases to confirm USER1 was a member of the DYNGRP database role for both databases.No problem there either.

Since I needed to change something, I selected USER1 and mapped him to the DYNGRP of the TWO database. The TWO database is the sample company for the GP2010 installation. That’s all I did; USER1 was not listed as a user for the TWO database.

Solved. Now, USER1 could log in to the sample company created in the GP2013 installation.

Go figure.

Until next post!

I want to be on Doug Pitcher’s list! Vote for me!

I know the fervor of the DynamicsWorld “top” 100 list is everywhere, but there is a far more prestigious list to aspire to. I am of course talking about the 2013 version of Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2012.

The list is so funny and honest, I don’t know how he comes up with this stuff, remarkable!. You will laugh out loud reading it, it’s that good.

I’ve been proud to be on it, and I hope I can cut the muster again this year.  And, dah, David Musgrave is on the list! That tells me for sure that Doug’s list is the best!

I don’t think Doug has an official ‘voting’ poll, but should you have the chance to talk, e-mail, text, twitter, Facebook, Linked in . . .  him, put in a good word for me

Keep up the good work Doug!

Until next post!

Leslie

Vote for David Musgrave–2013

I am in full agreement with Jivtesh. Though I think this whole 'list' thing is nothing more than a brilliant marketing idea of Dynamics World, still, to not have David Musgrave on the list should only CONFIRM IT IS A FRAUD.

C'mon people, we know who the superstars are. We do not need some web site determining  the best of the best. I think we all know that it's David Musgrave, and it has been for years.

But, if it's a vote that they need, vote for David and vote often. Even if it is a marketing scheme, I'll buy in just to get the right man at the top of the list.

Until next post!

Leslie

Review of Developing Microsoft GP Business Applications

Wow!

I am honored that my book, Developing Microsoft GP Business Applications is being reviewed in detail by Ian Grieve. I just learned of this today, he has 5 parts already reviewed. The reviews start here: http://www.azurecurve.co.uk/2013/02/review-of-developing-microsoft-dynamics-gp-business-applications-part-1/

Ian is completely independent and I will definitely be reading his reviews and be able to make the book better because of them. I've only read the 5th article, and am so very impressed by his thoroughness and honesty.

He talks about what's good, and what could be improved, I am elated to learn that someone so exceptional is taking this much time reviewing my book!

Thank you Ian!

Until next post,

Leslie