GSL Blog

Back to Blog Homepage »

Posts Tagged ‘business-intelligence Microsoft DynamicsGP tools marketing budgeting change’

Dynamics GP Events you do NOT want to miss – Get them into the Budget Now!

Friday, July 15th, 2011

Convergence 2012 – March 18-22, Houston, TX

GP Partner Connections 2011 – November 6-8, Caesars Palace, Las Vegas

 

DYNAMICS CUSTOMERS:

Convergence 2012:

The Customer event that cannot be matched…..  Convergence is the place to be if you’re a Dynamics Customer, Partner, ISV or Consultant.  With more learning opportunities than you can possibly jam in, you cannot afford to miss this conference.  Get this in the budget now and save your spot at this event where thousands of Dynamics users share tips and tricks and best practices for using Dynamics to gain the intelligence you need to meet your business goals. 

Sign up now to get email notifications on conference agenda, travel, and registration information. 

http://www.microsoft.com/dynamics/convergence/houston12/

Need more convincing?  Check out our March 2011 blog:  Convergence 2011 - Premier Microsoft Dynamics event

 

DYNAMICS GP PARTNERS

Partner Connections 2011:

If you’re a Dynamics GP Partner, ISV, Consultant, or Technical Sales Engineer and pride yourself on being the best in this changing field of applying business requirements to software and technology, you do not want to miss this event!

The agenda is a mix of workshops, roundtable discussions, general sessions, classroom training, and of course… fun in Vegas.

Register by October 1, 2011 and it’s only $499

http://dynamiccommunities.com/GPPartnerConnections/conference.html

 

Share/Save/Bookmark

New Users and Dynamics GP

Friday, June 17th, 2011

While brainstorming about an interesting topic for my next Gilchrist Scott blog post, I got a call about setting up new users.  Seemed very straight- forward at the time. 

Step 1: Log into Dynamics GP, go to Tools ->Setup->System->User and enter an ID and Password.  You can enter a class if your company is using that.

Step 2: Once that part is done, you’d then go to Tools ->Setup->System->User Access and grant them access to each of the companies you want them to be able to get into. 

Step 3: Grant Security so that based on the work that they do, they will only be able to access those areas that have to do with the duties that they perform.

Well, we did this process together, and then tested the users.  Perfect!  We were able to log in as each user and all was working very well.

The part that was not so straight-forward? When they tried to log in as these new users on another machine.  They weren’t able to get these users logged in.  They kept getting the error Your login failed.  Attempt to login again or contact your system administrator.”  Typically this means that you just entered the password incorrectly.  But while performing the definition of Insanity – “Performing the same steps over and over again, and expecting different results,” we found that we weren’t typing in the wrong password, because when we went back to the original machine that we setup the users on, the same password worked.

Now we needed to figure out what was different about these two machines that would play a role in these strange happenings.  There were several things that could have been contributing to the problem, so we decided to start with the most obvious first.  Any ideas?  Well, I took a look at the ODBC connection.  This is what is used to get Dynamics GP to be able to talk to the database where all your data is stored. 

When I looked at the connection, what I found was that the initial workstation was setup with an IP address (numbers that identify the server) and the other was setup using the server name as it appears on the network.  This was causing the issue for the Id’s and passwords.  The ODBC connections all need to be setup identically or there may be issues such as this.  It happens because the when the password is saved it gets encrypted based on the way the connection is setup, and if you try to access that new user on a workstation where the connection is not setup exactly the same as the workstation that created it, the decryption will not work to extract the password and allow the user in.

As usual with troubleshooting issues that come up, always be sure to look at the obvious first.  Just because something seems simple doesn’t always mean it is. 

Here’s to happy connections!

Share/Save/Bookmark

Key Questions to ask about your Audit Controls

Wednesday, December 1st, 2010

You passed your last financial audit with high marks. Your internal accounting controls more than satisfy the auditors’ requirements and you have nothing to worry about, right? Maybe!

With businesses “doing more with less”, the accounting staff is required to take on more responsibilities. This reduction in staff does not accommodate the traditional separation of duties recommended for audit controls.

When we talk with prospects and customers, we find:

  • AP Clerks are entering and posting transactions, and printing checks. How do you know some of those checks are not going to friends and family?
  • General ledger trial balances are downloaded to Excel to create financial statements instead of direct printing from the accounting system. What balances are changed for external reporting that do not match up to the general ledger?
  • Bank reconciliations are completed offline. Are you sure that every bank transaction has been recorded in the accounting system?

When we recommend to our clients a greater separation of duties, the response is that they don’t have the staff and the auditors approved the internal controls. After all, SAS300 states that “There is always some control risk because of the inherent limitations of any accounting and internal control systems.”

So how do you protect against fraud and accounting irregularities without hiring more staff and incurring large consulting expenditures? Here are examples of some things you can do to protect your company or organization.

· Review user security in your accounting system. Are the users allowed to remove history? Do members of the accounting department know the system administrator password that gives them access to every function in the system? Change the system password and restrict their rights only to their specific duties.

· Use an auditing tool that tracks changes to records. Most quality Enterprise Resource Planning (ERP) systems sell an inexpensive module that will track “before” and “after” changes. When a vendor address changes, the information can be tracked and reviewed at any time. Track changes to vendor EFT bank account information.

· Insist that all accounting functions operate in the accounting system. Use the bank reconciliation tool to reconcile to the bank, use the financial statement generator to print financial statements directly from the general ledger, track fixed assets within the ERP system and not in Excel.

· Assign bank reconciliation duties to someone who is not handling cash or printing checks. In a small accounting department, one of the best ways to prevent against fraud is to review the bank statement.

· Assign posting (update of the accounting records) to a different staff person. Reviewing the results of a computer check run or cash receipts batch can be completed in a matter of minutes by a separate staff person. And correcting the general ledger accounts prior to posting saves time when completing the month end reconciliation.

These are just a few examples of ways to maintain the integrity of your financial systems. And as auditors become more accounting system savvy, you continue to meet and, hopefully, exceed expectations.

For more information on how you can implement further accounting controls, please call us at 207.761.2133 or email info@gilchristscott.com.

Share/Save/Bookmark

Stepping it Up!

Friday, January 9th, 2009

I’m glad 2008 is history. Collapses and oversights like Bear Stearns, golden parachutes, a $700 Billion bailout (or whatever you prefer to call it), the Dow falling nearly 34% for the year; the worst year since the great depression, Bernie Madoff (?!!?), and more bad business from our automakers, make me crave change. I just want to move on. Unfortunately these events are not just last year’s chapter. Recovery will take time, require foresight, planning, and creative change.

It’s not a time to hunker down and wait it out. Rather, it’s time to step it up and take advantage of the investments you’ve already made. Maximize your resources. And for those of you who are my clients, that means maximizing productivity and business intelligence with your Microsoft Dynamics GP system.

Below I’ve provided some suggestions and also the tool you would use to carry each out. I have focused on specialty construction clients, but these ideas apply to most businesses: (more…)

Share/Save/Bookmark