GSL Blog

Back to Blog Homepage »

Author Archive

Looking to connect with other GP Partners?

Monday, September 19th, 2011

“They say that time changes things, but you actually have to change them yourself” 

     Andy Warhol

Dynamics GP Partners:  Do you remember Stampede?  Are you looking for an opportunity to connect, gain insight, improve your bottom line?  Are you looking for new strategies while preserving the core that’s made you successful?  If so, you need to attend GP Partner Connections 2011, November 6-8 at Caesar’s in Las Vegas.

Connections has become an exclusive planning, training, and networking conference for Dynamics GP partners from all over the country.  This will be the 3rd year of a grass roots effort to bring value back into the Partner Channel. 

Who should attend?  Consultants, Developers, Practice Managers, Project Managers, and business leaders in any Dynamics GP ISV or Consulting practice. 

Save $100 by registering by 9/30/11.

Contact me for more details, and for more information on the breakout sessions, go to the GP Partner Connections website:  http://www.gppartnerconnections.com/ 

Take the time to change. 

Share/Save/Bookmark

What can a Dynamics GP Light User do?

Monday, August 1st, 2011

There’s been so much buzz about Dynamics GP Light Licenses lately, and why shouldn’t there be?  When you have the ability to access data, turn it into business intelligence and deliver insight to your team, we would be putting our head in the sand by not asking about it.

 

Understanding and complying with Microsoft’s licensing rules requires some education, but it’s not complicated when limited to Dynamics GP.   

 

What can a Dynamics GP Light User do?

·         Perform real-time analyses with refreshable Excel reports

·         Access the library of key metrics via SQL Server Reporting Services – Charts, Metrics, KPI’s

·         Gain insight using Analysis Cubes

·         View financial statements with Management Reporter

 

How does the Light User access this information?

·         Using a web browser, Light Users access information through SharePoint, including:

o   Role Center Dashboards

o   External Lists

o   Business Portal Applications such as Time & Expense and Requisition Management

o   Workflow Approvals

o   Enterprise Search

 

Why buy a full Microsoft Dynamics GP User License when you can get a Light License and real time data for under $200? (What CAN’T a GP Light User do?)

·         A GP Light User can NOT log into the GP Application or perform any tasks within the program.

 

How do you know when you need a Light License in order to be in compliance?

·         GP Light Users are perfect for a non-GP User who is accessing a report, query, or application that uses the Dynamics databases, for example:

o   Executive Centers and Dashboards

o   Excel Reports (Smartlist Builder and Microsoft Excel Reports)

o   SSRS, Crystal, and other reporting tools

o   Visual Studio, Access, or other development applications that produce or update GP data

o   Workflow in Dynamics GP

o   Business Portal’s Order Management and Requisition Management

o   Payroll and HR Self Service suite

 

Still not sure?  Contact us today to get the answers you need to take advantage of the price and opportunity to deliver intelligence rather than meaningless data.

 

Share/Save/Bookmark

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

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

Are you using the right tool for the job? Save time and empower users with Microsoft Dynamics GP.

Wednesday, December 1st, 2010

So often we get into a rut in our daily work lives, using the tools and technology that we’ve become accustomed to in completing our day-to-day work. Why don’t we consider using the best tool for the job instead of the default tool? Many of us stick with what we know because we’re all working in lean organizations and we perceive it takes too much time and effort to try something different. We’ve shown our clients that this perception is just not true and they are reaping the benefits of having more time, not less.

Reporting is a prime example. In accounting and information systems, there are multiple ways to get data out of the system. It’s overwhelming and unfortunately, many ERP Software system users in the accounting department are printing reports and re-entering the data in Excel for their final output because that’s what they know. There’s no time spent learning something new. For many it’s their default reporting tool.

Examples of the primary reporting tools in Microsoft Dynamics GP are:

· Report Writer

· SQL Reporting Services (SSRS)

· Excel Reports

· Smartlist and Smartlist Builder

· Crystal Reports

Most organizations do not have the resources to become experts in all the tools, but the IT and Management team should select and embrace a few. Variety provides options, and options empower users. Less reliance on IT and external resources means cost savings across the board.

How do you know which tools are right for your organization? Ask the experts. A small amount of time with your GP Partner to assess your needs and recommend the tool set that will meet the users and organization’s needs, will provide big payoffs.

New England Tech Air, Scarborough Maine, is a prime example of a company that’s diligent about having a lean accounting staff. They can’t afford to spend hours on getting access to data. Last year, at year-end, Angela Hussey, Accounting Manager, needed to complete the mandatory year-end 401K census. Angela’s default tool was to use Dynamics GP Report Writer or to look up the data using GP Inquiries. Both of these options were leading to several days of work. She didn’t have that much time and knew there must be a better way.

It took a half hour to assess the requirements confirm that Dynamics GP Smartlist Builder was the right tool. A half-hour later Angela had the report she needed. “They saved me 8 or 10 hours; at least one whole day and a ream and a half of paper,” she explained. “I am fairly busy most of time so this helped a lot. I have to do this once every year, and before now, there was no easy way to get to it.” A small amount time to determine the right tool avoided numerous hours of staff time. Just as importantly, it brought confidence and understanding of a new tool.

Angela went on to explain, “What we do is not always a cut and dry use of the system; we do some quirky things. Gilchrist Scott knows us well, so they’ve been able to modify some screens and reports for us, which makes it more user-friendly for us in general. It even helps with little things to save time, like not having to hit so many buttons on a payroll screen.”

When you say to yourself “there must be a better way”, you’re probably using the wrong tool for the job. Stop, and reconsider your options. It will save you time and improve your toolbox. Give us a call at 207.761.2133 to help you find the right tool for your time-consuming tasks.


Share/Save/Bookmark

Dynamics GP Payroll Year End Update - 2010

Tuesday, November 16th, 2010

Watch for Dynamics GP (Great Plains) - US Payroll year end update tentatively scheduled for 11/18/10.

Form Changes included in the year end update will include W-2, Hire Act (ends 12/31/10), W-3, and Payables 1099-INT.

Microsoft Payroll and Technical Support experts are recommending all Dynamics GP Payroll users install the year end update. We recommend you do this before the year-end crunch. It’s best to get the year-end update out of the way rather than waiting until you’re ready to process W-2’s.

GP Update Target Release Dates for Version 9,  10 SP 5,  GP 2010 SP 1
US Payroll Year End - 11/18/2010
Canadian Payroll Year End - 12/16/2010
US Payroll Round 1 2011 tax update - 12/16/2010
Business Portal W4 form change – 12/16/2010

Watch for the 2011 Tax update with the following changes (known so far):
Earned Income Credit phased out
Social Security limit remains unchanged from 2010
State changes: California, Kentucky, Minnesota, New York City

Share/Save/Bookmark

GP 2010 Word Templates

Thursday, November 4th, 2010

We love the Microsoft Dynamics GP 2010 WORD Templates.  Now you can EASILY add logos and change layouts on PO’s,, Invoices, Sales Orders, and other reports.  Additionally, for those organizations that have multiple companies in Dynamics GP, you can now have unique reports for each company.  Each company can have their own Logo, addresses, and information specific to that company.  No more workarounds or multiple reports dictionaries! 

GP 2010 Word Templates use the Dynamics GP Report Writer functionality but the process is very different so here’s a general overview:  

1.            Identify the Report and Fields

             Print the report you want to modify to Screen.

             Click on Modify

             Notice the Report Name in the top left of the window

             Make sure that the fields you want in the new Template exist in the Report Writer report because this is where the XML data is generated for the templates to read. 

 Note: This is particularly important to consider when upgrading.  Make sure that the reports dictionary that you’re upgrading contains the most current report, with all the fields you need.  Reports that are known for not upgrading well are the Sales Order Processing (SOP) and Purchase Order Processing (POP) reports. 

 

2.            Create the Dynamics GP Word Template from the Report Writer Report

             Reports – Template Maintenance

             Find the Report you want to Modify

             Click New and Select from Existing Template

             Enter your new template name and Create

 

3.            Modify the Dynamics GP Word Template

             In the Available Templates list select the newly created template.

             Click Modify to open Microsoft Word with the template loaded.

             Make the changes as desired.

             Save As ________

             Optional: Check the Maintain compatibility with previous versions of Word (if using Office 2010).

             Save the template to the location that your business process standards have outlined; either local or shared location.  (Ask your Dynamics GP internal administrator or GP Partner)

             Close Word

             Notice the green plus sign to Add a template. – Click on this and locate the document just saved.

             Open and say Yes when asked if you wish to replace the existing template.

4.            Assign the Template to the Customer/Vendor and Company

             Select the modified template.

             Click Assign - Company. Mark the applicable companies. Save.

             Click Assign – Note: Debtor = Customer and Creditor = Vendor  

             Click on the green plus sign to select the Customer(s) that applies. 

             Delete any Customers that should not have been included in the range previously entered and Save   

5.            If you’re looking for more detail, check out the Dynamics GP Word Templates section in the System Setup Guide and Report Writer User’s Guide. 

Share/Save/Bookmark

Microsoft Dynamics GP keeps up with $17.6 billion Jobs Bill

Monday, April 5th, 2010

If you are thinking of hiring; now is the time.  There are two new tax benefits available to employers hiring workers who were previously unemployed or only working part time.  This is part of the new $17.6 billion Job Bill, or officially known as the Hiring Incentives to Restore Employment (HIRE) Act which was signed by the President in mid-March. 

What this means for you:

·         Tax Benefit 1:  For every “Qualified” employee (defined as Unemployed for the previous 60 days or worked less than 40 hours in the previous 60 days) Employers will not have to pay FICA tax on these employees from 2/3/10 – 12/31/10.   

·         Tax Benefit 2:  For each worker retained for at least a year, businesses may claim an additional general business tax credit, up to $1,000 per worker, when they file their 2011 income tax returns

 

In Dynamics GP Payroll, it will work similar to the following (details to be worked out):

1.    A “Qualified” employee is someone that has been unemployed for the previous 60 days or worked less than 40 hours per week in the previous 60 days.  These employees will be flagged in Employee Maintenance in a new field.

2.    A new 941 report will have at least 2 new fields:  1. Number of employees in the date range that are qualified, and FICA amount the employer can reduce.

3.    Before the Q2 941 report is run, the Dynamics GP code change will need to be made and the employees flagged.

Share/Save/Bookmark