GSL Blog

Back to Blog Homepage »

Archive for the ‘Microsoft’ Category

GP 2010 R2: Email and Word Templates

Monday, August 8th, 2011

We still love the Word Templates in GP 2010. The main issue, however, was that not all reports were available as a template.  Users spoke, and the developers listened!  With GP 2010 R2, a new tool called the MS Word Template Generator is available.  Any report available in Report Writer can now be processed through the Word Template Generator.  Here are the basic steps:

1) Report Writer generates a data file (an XML file)

2) The Word Template Generator creates a template based on the data file

3) The template is imported into GP and can be edited as necessary (there’s an add-in for WORD that allows you to view and select GP fields).

4) When you print the report, choose Template instead of Standard

 

A few of the benefits of Word Templates:

1) Users are able to re-format templates in a familiar environment (Word)

2) Templates can be assigned to specific customers

3) No more multiple reports dictionaries for multiple companies!  Reports can be assigned to specific companies.

 

GP2010 R2 has new email capabilities, as well.  Any report window that has a Print button now also has an Email button. Users can generate a custom message, add data fields from the transaction window, and send!  The report is static, in an HTM format, and can be viewed using a web browser by GP users and non-users.

Thinking about moving ahead to GP2010 R2?   Gilchrist Scott is offering discounted rates for upgrades scheduled in August. Contact us soon to talk about upgrading. (207) 761-2133.

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

How can Business Ready Licensing (BRL) for Dynamics GP save you money?

Monday, June 13th, 2011

At Gilchrist Scott, LTD, we know how important the relationship between clients and their Microsoft Dynamics Business Partner is.  You have made the wise decision to invest in Microsoft Dynamics GP. Now is the time to ensure that you are taking full advantage of all the Microsoft Dynamics features and capabilities to enable confident decision making, drive business productivity, and reduce operational costs.

 

BRL (Business Ready Licensing), was introduced in 2006 to help Dynamics customers get more value from their existing and new solution.  The bundle offers a wide range of functionality to support your business process.  Prior to 2006, customers purchased their solution using Module-based Licensing, adding new modules as needed.  This placed the value in the functionality, whereas BRL places the value in the number of users so customers don’t have to worry about which modules to buy initially.  You own the entire bundle, and may activate unused functionality as needed.  

 

With the special  promotional offers out there, many of our clients are able to move to BRL at a fraction of the cost that it was even a few short months ago. This will enable existing clients to access dozens and dozens of new modules, and freeze their annual enhancement at their current list price.

 

If your company is interested in a License Model Transition, now is the time to do it.  Microsoft’s year-end promotions offer this transition at a deeply discounted rate, but only until June 24th.  Please contact us now to discuss!

Share/Save/Bookmark

Convergence 2011 - Premier Microsoft Dynamics event

Wednesday, March 23rd, 2011

Why attend Convergence?  If you haven’t already seen this, I would like to share what Microsoft has to say about their most widely attended customer conference:

  1. Learn how we can get the most out of our Microsoft Dynamics solution.
    • Learn how to use the features and functionality of the Microsoft Dynamics solution we currently license to improve operational efficiencies and increase employee productivity.
    • Discover how Microsoft Dynamics can help us meet our fiscal responsibilities and compliance obligations.
  2. Network and collaborate with my peers and the product experts from Microsoft.
    • Tap into the strength of the Microsoft Dynamics community and get expert tips and see firsthand how users like us are optimizing their Microsoft Dynamics solutions to solve business problems.
    • Consult with our solution provider and the Microsoft personnel who are directly responsible for developing and supporting our product.
    • Take advantage of networking and learning opportunities outside of conference sessions. For example, in the Community and Learning Center, we can get free technical support, participate in hands-on lab exercises, and meet fellow users and product experts.
  3. Experience the latest solution innovations, new products, and technologies.
    • Get up-to-date on the latest Microsoft products and business technologies such as Office 2010, SharePoint 2010, and SQL Server and learn how these products can enhance our Microsoft Dynamics solution.
  4. Get insights into Microsoft’s corporate direction, and understand future plans for our Microsoft Dynamics solution.
    • Hear directly from key Microsoft Dynamics executive leaders about the broader Microsoft vision and company direction—and how Microsoft Dynamics strategy aligns.
    • Align our business to take best advantage of the insights I gain regarding Microsoft’s direction and solution investments.
  5. Become eligible for up to a 20% discount off when:
    • Purchasing additional users
    • Acquiring additional modules/granules
    • Transitioning to a Licensing Model

Plus, Convergence 2011 Atlanta is cost-effective and easy to attend. Atlanta offers many affordable hotel options, and the event starts on a Sunday so it will take less time from your work week.

For more information or to register to attend Convergence click on this link Convergence Web site.

 Feel free to give us a call at 207.761.2133 if you have any questions. 

We hope to see you there!

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

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

Introducing Management Reporter for Microsoft Dynamics ERP

Thursday, June 24th, 2010

Management Reporter for Microsoft Dynamics ERP is now available for Microsoft Dynamics GP 2010.  I like to think of Management Reporter as the ‘New and Improved FRx’!  A lot of the same functionality found in FRx exists within Management Reporter as well as a lot of additional functionality.  Some of the highlights include:

 

v  Report Library – organize your reports in folders! 

v  Insert Graphics – you have the ability to insert graphics within Management Reporter. 

v  Show negative numbers in red font.

v  Column page breaks – control where the column page breaks are placed.

v  Format override in Rows.

v  Custom page numbering.

v  Security on Library, Folder, and Report Definitions.

v  Report Groups!

v  Inline Notes!

v  Undo/Redo functionality!

v  Add footnotes to reports!

v  Migrate your existing FRx report catalogs and building blocks to Management Reporter!

To find out more about Management Reporter for Microsoft Dynamics ERP visit the following URL: http://www.microsoft.com/dynamics/en/us/products/management-reporter.aspx

Or contact Gilchrist Scott at info@gilchristscott.com for a demo!

 

 

 

 

 

 

 

 

 

Share/Save/Bookmark