Archive for the ‘Microsoft Dynamics GP’ Category

Key Questions to ask about your Audit Controls

Thursday, December 2nd, 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:

  • Accounts Payable 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 203.281.0006 or email info@criticaledgegroup.com

Microsoft Dynamics GP – Home Page Font Change

Wednesday, March 24th, 2010

Does your home page in Microsoft Dynamics GP version 10.0 strain your eyes while navigating through due to a small font size?

If you are like a lot of Microsoft Dynamics GP users, you are on the computer a good majority of the day and your eyes could start to glaze over after a few hours, but through an easy to fix solution, you could increase the font size on your Dynamics GP home page to help prevent any glazing.

Defult Home Page with 9pt font

Defult Home Page with 9pt font

Through the home page file under the ‘Background’ folder in your Dynamics GP folder you can easily change the font size to whatever you’d like. By testing in-house we have come up with a good array of font sizes to help you change your home page from small, 9 point font, to about 15 point font without affecting anything else but the font size.

To easily make the change to your font size:

Change the original file name of “HomePage.css” to “HomePage_Orginal.css” so that you are able to keep the original file as a backup. Then, download and save the file we have already created that contains a larger font size and save in the Dynamics GP background folder as “HomePage.css” (Note: Whichever file is named  “HomePage.css” becomes the default)

To download and save the file in your Dynamics GP folder please click here: http://www.criticaledgegroup.com/filephotos/docs/HomePage.css

Revised Home Page with 15pt font

Revised Home Page with 15pt font

(Note: The file needs to be saved on individual machines that have Dynamics GP installed for those users that wish to change the font size. This is not a system-wide change.)

Please let us know if you’d like any help with this change. Contact us here!

                                              

                                           ZPVAWZY9PVCT

Increase the Speed When Switching Between Companies in Dynamics GP

Monday, March 8th, 2010
Does your organization have more than 3 databases, which results in you having to often switch between companies in Dynamics GP?
If so, there is usually a long wait time for Dynamics GP to load before you can continue with your work. There is a simple solution to help make it faster for users.

The ‘power user’ role can perform this solution through the SQL maintenance window in Dynamics GP 10.0, that would allow all users to switch companies faster than before; cutting the load time down by almost 50%. (Note: Make sure to save your work in the prior company before switching because you will be logged out of the first company.)

To get to the SQL Maintenance window you must go to ‘Microsoft Dynamics GP’ -> ‘Maintenance’ -> ‘SQL Maintenance’

Then select the company database from the drop down, then select the ‘List Action Status Header’ and ‘List Action Status Line’ -> then select the check boxes for ‘Drop Auto Procedure’ and ‘Create Auto Procedure’ -> Then click ‘Process’

Repeat the same steps for all the company databases that you have in your organization.

3-5-10_Switching companies maintenance window_Image_resized

Please contact us for more information: http://www.criticaledgegroup.com/contact/contact_us.asp

The Paperless Office or why are we still saving paper documents?

Tuesday, February 23rd, 2010

Nearly 20 years ago, the “seers” in our industry proclaimed that within about 10 years, all paper documents will be eliminated.  Yet we are increasingly drowning in paperwork and wasting more time than ever searching for that one piece of paper when we need it.

Today, there are numerous cost effective document management systems that integrate with GP.  At the same time, the cost of disk space to store these electronic documents has decreased dramatically.  We now talk in terms of “gigabytes” where 20 years ago we spoke of “megabytes” of data.

At CriticalEdge, we have implemented one of these many solutions in-house.  When I need to view a Verizon contract, I go to the GP vendor record and open the attachment.  If I need to look at a vendor invoice, I open it through the Transaction by Vendor Inquiry.

Let me know what impediments are in the way of your implementing a document management solution?

Update: Our 2010 Audit Preparation Class is now a Free Webcast

Monday, February 1st, 2010

*Class has been changed to a 1 hour webcast due to customer demand

Due to the reduction of time from a 3 hour in-person event to a 1 hour webcast, the main topics will still be covered but will not be discussed as in-depth.  The webcast will be recorded so that it can be watched on-demand.  It will also be free of charge.  We feel that audit preparation is extremely important for our customers and others running Microsoft Dynamics GP.  The webcast will be played live and recorded in February and all are welcome to attend. The following topics will be covered:

-  SmartLists
-  Security and Audit Reporting
-  Reprints of posted transaction journals
-  Posting Setups and Posting Flows
-  Process Documentation

Date and time coming soon!

Any questions that you have on how your organization can best prepare and handle an audit, please contact us at 203.281.0006 or at support@CriticalEdgeGroup.com.