Posts Tagged ‘Reports’

Evaluation Tools

Wednesday, November 9th, 2011

In 1983, Quaker Oats purchased Gatorade, transforming it from a multi-million dollar business into a multi-billion dollar business.  Fast forward a decade & Quaker decided that another drink manufacturer was primed for the same growth.  This time, Quaker eyed a takeover of Snapple, a popular fruit beverage.  After paying a large ransom for the Snapple business, Quaker did not see the returns it had forecast.  The Snapple brand fizzled as Quaker resources were washed down the drain.  Eventually, the Snapple brand was sold at a $1.4 billion loss to Quaker.

What went right with Gatorade that went so wrong with Snapple?

The measurement tools that Quaker used to evaluate Gatorade were both accurate & appropriate.  However, in the decade that past, these same evaluation tools were not updated.  Quaker applied the same methods & metrics to the Snapple brand that they did to the Gatorade brand.  However, in the decade that had passed, these tools were no longer the most appropriate.

Evaluation mechanisms are constantly being updated.  What works today might leave you behind tomorrow.  Quaker found this out first hand.  If companies want to continue to thrive, they must be constantly tweaking & evaluating the tools they use to evaluate their business.

Microsoft Dynamics GP leverages ever evolving Microsoft technologies in order to provide the best reporting options possible.  Users can access reports in many different formats.  Business Alerts can send automated emails to any staf member when exception criteria are met or at specific intervals.  Emails can be configured to include attachments, including lists of applicable information.  Users can have similar automated Reminders open on their screens when specified criteria have been met.  This allows for fast & automated management by exception.

To Do lists & Check List force users to complete tasks periodically in a structured way.  Meaning, no longer are workflows undocumented or dependent on a single employee.  If an employee leaves the organization, those same tasks must still be completed.

Standard reporting is available in paper format as would be expected.  Users can further use inquiries to research linked transactions if auditing information.  The same information can be exported to Excel or Word at the click of a button through a Smartlist.  These can all have filters applied to them to restrict the information that is displayed.  However, where Dynamics GP takes things a step further is SRS Reporting.  Smartlists can live on the server in the form of an Excel Report.  These can contain, charts, graphs, lists or whatever one’s heart desires.  These reports are linked to the server & the Dynamics GP database through Excel, meaning information is constantly changing on them automatically as data is entered into Dynamics.  And the best feature is that those who wish to view these reports do no require a Dynamics GP user license as they are not actually logging into GP.  The same premise applies to SRS (or SQL Reporting Services) Reports.  These are built through regular SQL statements & can include filters, etc, just like any SQL query would have.  Data can be displayed in many different formats & again, do not require a license to view.

The evaluation tools offered by Microsoft are beyond comparison & constantly evolving.  those utilizing Dynamics GP are always in the know & won’t be left behind.

Pie Chart

Adam MacIntosh is the Senior Project Manager with WebSan Solutions Inc., a professional services consulting firm specializing in helping companies get the most out of their ERP systems. You can contact Adam at Adam.MacIntosh@WebSan.com or at 416-499-1235 ext. 213.


SSRS – Creating BI Reports for your Dynamics GP Data

Friday, July 1st, 2011

If you’re a business owner and frequent user of Dynamics GP, you might think, “I have a lot of data in my Dynamics GP system. I need to analyze my data, extract a new knowledge from it and make decisions based on this analysis. I want to see  the KPI of my business in real time mode to drive my business better. I want to have a tool which will help me see hidden trends in my business and industry…”. If you already have these thoughts, there’s good news – the Business Intelligence technologies (BI) will help you.

Basically, you need to have three things:

  1. The data warehouse. It is a special data base which has a star-schema data model (info cubes). Also, this database is in read-only mode for users and it is optimized for reporting and multidimensional analysis.
  2. Extraction, loading and transformation  process (ELT) which loads your data from OLTP system like Dynamics GP to your data warehouse. Generally speaking this ELT process “cleans”, transforms and loads your daily operation data from Dynamics GP into your data warehouse.
  3. Tools to create analytical reports and KPIs based on data from your data warehouse.

There are alot of BI tools which can help you to create a whole process of these 1-2-3 steps. However, if you have ERP based on MS SQL Server (i.e. Dynamics GP – you have a simple way of studying the system and pretty powerful BI tool right out from the box! It is SQL Server Reporting Service (SSRS) which actually is the part of MS SQL Server installation.

So, let’s see what SSRS can provide you:

  • Simple access to your Dynamics GP database and use it as a data warehouse, you just need to write a bunch of SQL-statements and SSRS will transform on the fly the results of these queries to BI reports
  • Loading and analyzing data from MS Analysis Services which is more powerful solution to build data warehouse from Microsoft
  • Special tool for building in drag-n-drop mode you BI reports – Report Builder 2.0 It is free and can be downloaded from Microsoft site
  • Creating beautiful graphic dash-boards with KPI’s in Report Builder 2.0
  • Different filters for your BI reports
  • Access to your reports, dash-boards and KPIs via Web, you can see all your BI stuff just in your internet browser
  • Generating your BI reports in off-line mode and sending them via e-mail on a schedule. (Do you want to see some daily reports every morning in your inbox? No problem, SSRS will do it for you. Just create your reports in Report Builder, then publish and schedule them)
  • Integration with your MS Share Point portal, yes you will be able to build reports and analyze data right in your portal
  • Built in export of reports to Word, Excel, PDF and TIFF-format

MS SQL Server Reporting is very simple for installation and studying. You could get BI tool and start analyze your data in Dynamics GP in two or three days. Simple, powerful and ready for use right out from the box.

Printing Reconciliation Report

Wednesday, November 11th, 2009

Do you often find yourself canceling reports that automatically print after you have posted a document?  Or even changing the default destination of these reports?  Well, one can set the default destination of these reports or even stop them from printing all together.

Try entering  the Posting Setup screen (Microsfot Dynamics GP > Tools > Setup > Posting > Posting).  In this screen, you can select whether or not a specific report will print by selecting or de-selecting the checkbox in the Print column.  Also, one can specify destination for a report by making the appropriate selection in the Send To column.

See the attached screenshot below & save yourself all that extra clicking when you next post a transaction.

Calc formula

Exporting FRx Statements

Monday, November 2nd, 2009

FRx is the standard financial reporting tool utilized by most Microsoft Dynamics GP users for financial reporting.  FRx links directly into the general ledger to allow the creation of endless types of reports.  These report are then viewed in the FRx DrillDown Viewer.  Users I have spoken to in the past have expressed that they are more comfortable viewing reports in Excel.

To take your FRx financial report & export to excel:
1 – Generate the report
2 – In the DrillDown Viewer, select File > Export > Worksheet File > Formatted Excel
3 – Save the report to its desired location

This quick & easy trick should save you time & energy in attempting to convert your reports.

 

Calc formula

The Homepage

Tuesday, September 15th, 2009

Home sweet home!  It’s a beautiful place.  Its where we feel most comfortable & spend most of our time.  The same can (& should!) be said about your ERP.  The homepage in Dynamics GP has access to everything you need in the click of a button.

Managers are always interested in quick easy access to reports.  The Dynamics GP homepage offers various metrics to the user the second they log in.  Click on the pencil icon to the right of the word Metrics on your desktop to modify what metrics will display.  Although there are dozens to choose from, my fav five are:

  • Top 5 Customers by YTD Sales
  • Top 10 Items by Sales Amount for the Past 30 Days
  • Receivables Aging
  • Payables Aging
  • Gross Profit for the Past 12 Months

Scroll through your metrics using the < & > keys for instant access to the reports you desire.

Try these other tips to help make your homepage a one-stop shop for all your GP needs:

  • Right click on the navy blue banner at the top of the screen to create graphical shortcuts
  • Click on the pencil icon to the right of the Quick Links heading for one-click access to your favourite windows
  • Click the ‘Customize this page …’ button to change layout of your homepage
  • Select the following  icon to add or remove windows from your desktop & even configure shortcuts:

Button

  

Dynamics GP Homepage

Dynamics GP Homepage