User Access Setup Error: GPS Error RevokeUserAudit: 58

I faced this error message from the time I upgraded to GP2010 R2. The error message is thrown when we revoke access to a user on a company. Below is the exact sequence of error messages that I received:

Since I had not doing this frequently (it's maximum 3 users in 6 months) and also the purpose of revoking access was working without any issues, I did not consider this as a harmful message.

Yesterday, I had to revoke access to users for an existing company due to some maintenance. Minimum of 10 users and I started receiving this error message each time I select a user and revoke access. It's then I decided to check this out and clear it once for all.

I could get only one link with exact error message, which I found on our Community Forum. User Access Setup Error: GPS Error RevokeUserAudit: 58.

Let me explain what I did to get rid of this.

1. Check the second error message. It says it did not find the stored procedure *mxCallRevokeUserAudit*.

2. I checked whether this stored procedure is available on any other company that I had on my GP environment. I could not find one on any company.

3. I was intrigued by the name of this stored procedure since, it's not similar to any Microsoft Dynamics GP SQL object naming convention.

4. I then launched GP and opened Tables Resource Description (Microsoft Dynamics GP -> Tools -> Resource Descriptions -> Tables).

5. Since the message said something about *Audit*, I thought I would first check with *Audit Trails* module. To my surprise (and joy, of course), Physical Name of all tables started with *MX*.

6. I then concluded that the SQL Stored Procedure what I am looking at, is also of *Audit Trails* module.

Now I could not do much with that, since I could not find that stored procedure anywhere. I checked my GP licenses and it did not cover *Audit Trails* module at all.

When I upgraded to Microsoft Dynamics GP2010 R2, I had selected this module also for installation. Since this module is not covered under my license, it installed the dictionary but it did not create the SQL procedures (that's my assumption and I may be wrong).

The only option that was left; to remove this product from my environment (by removing DYNAMICS.SET file contents alone and not the dictionary itself).

This removed that now (in)famous error message.

VAIDY

Congrats MVPs - Mark & Siva

Congratulations to these tremendously talented and amazing individuals, Mark Polino and Sivakumar Venkataraman, to get their MVP status renewed. Most deserved ones.

Congrats again to you both and wish you many more MVP renewals in future. Do doubt about that.

VAIDY

State of Online Accounting Industry - Q&A on Software Advice by Michael Koploy

I was contacted by Mr. Michael Koploy, Software Advice, to have a look at his then recent article; State of Online Accounting Industry.

The importance of this article is that it gives an insight about Accounting Software on Cloud, from 3 of the leading Online Accounting Software solutions. 5 important questions and you are well informed by the answers. It's a great read and well informative.

I would like to share my views on this.

Advantages:

1. Cost - That'll be the driving point for any one who want to go online.
2. Less/Zero Maintenance - You don't have to worry about downtime or H/W maintenance on server or related resources.

Disadvantages:

1. Depends on providers. You can't just trust everyone and anyone who provide an online solution. There were some recent outages from industry's leading providers, such as Microsoft, Amazon, etc.
2. Since it's pay as you use, you have to limit your usage if you have to get some benefit out of. When I say that, I mean, I may not have one live environment and one test environment for the price of only one environment. If I insist to have, I may have to pay for that.
3. If I have to restore a backup due to a severe mistakes, I can't do it immediately. I don't even know whether my service provider maintains a backdated backup or not.
4. No Accounting Software is used AS IS, without a single customization(s). If I do require a customization, then my online accounting software should have an ability to import it and get updated with.
5. Whenever there is a major update to the parent product, I may or may not have a choice to decide on whether I actually want it or not. As always, a major upgrade also include additional cost depending on HOW major it is.
6. People may not feel like THEY ARE CONTROLLING THEIR DATA. I capitalized that, because, that's a huge question everyone would want to ask before adapting to the change.

In my humble opinion, everything else could be 100% online (Public Cloud), but Accounting Software should be a hybrid (Private Cloud). In that way, there will be a balance between cost, maintenance and others.

VAIDY