Tuesday, March 29, 2011

Dynamics GP2010 R2 Feature of the Day

Drilldown from SQL Reporting Services Reports


Why this feature is cool!

This feature allows a user to render a summary report then drill back into a detailed report to display the financial details behind the totals. This gives your end user a closer look into the numbers the report is displaying and the ability to drill right into the transaction through the Microsoft Dynamics GP client for more analysis if necessary.


What does it look like?

In this example, the KPI report was created along with the summary line graph but there wasn't an easy way to see the details behind the summary totals. With the 12 additional reports that were created, we were able to give the details behind the amount plus the added ability to drilldown into the Microsoft Dynamics GP client and analyze the transaction if needed.




Friday, March 18, 2011

Tip – AR Customer Trial Balance not matching to GL?

Here are a few tips that should solve your problem......

  • Run Microsoft Dynamics GP - Maintenance - Checklinks - Sales (All) and then Microsoft Dynamics GP - Tools - Utilities - Reconcile to make sure all the data and tables correlate.

  • Verify your AR Aging buckets include ALL days (up to 999). Go to Microsoft Dynamics GP - Tools - Setup - Receivables. Do ALL of the aging periods appear on your report? Either modify this screen to have a shorter number of periods, or modify your report to include additional aging buckets (Contact support@collinscomputing.com) for assistance with this).

From This:


To This:



  • Find out if any customer have document older than 999 days. Go to Inquiry - Sales - Transaction By Document and enter in a date range that is more than 999 days out. You can then choose to write-off the older documents. Or add a field to your aging report to include to include in the last bucket any document older than a specific date (starting date).

Wednesday, March 9, 2011

Dynamics GP2010 R2 Feature of the Day

Business Intelligence Refresh


Why this feature is cool!

Microsoft Dynamics GP2010 R2 gives people a Business Intelligence refresh of the SQL Reporting Services (SRS) reports. Redesigning the reports gives a consistent look throughout all SRS reports and an updated graphical interface. The Reports have alson been updated to pull in the Currency symbol and decimal places based on the Company Setup within Microsoft Dynamics GP.


What does it look like?

Tuesday, March 1, 2011

Dynamics GP 2010 R2 Highlights

New features are constantly being added to Microsoft Dynamics GP. Even though version 2010 has been released, Microsoft continues to enhance the solution and will release the R2 version of GP2010 after Convergence.

The Microsoft Dynamics GP product team has a "Feature of the Day" within their "Inside Dynamics GP" blog that we encourage you to visit or subscribe to. Here is an entry from last Thursday regarding one of the new features in R2:

Navigation List Views up to 360% faster! The introduction of list views in version 10 and the action pane has provided you with greater access to your data. For some of the larger, more robust lists, it can take a while for data to appear in the list. In Microsoft Dynamics GP2010 R2, those lists have been re-architected so the information appears more quickly. As an example, the Sales Transactions List with Business Analyzer metrics will display data 360% faster.



Some of our other favorite GP2010 R2 features are:



  • Ability to email Dynamics reports directly from GP!

  • SOP Returns now able to be sent in Word format.

  • Easier to create templates in Word format.

  • New Report Deployment Wizard.

  • Over 50 new SQL reporting services reports.

  • Drilldown from Summary to Detail in SRS reports.

  • Multi-Company reporting with SRS.

  • Copy Security acress Dynamics installations of GP, BP, and CRM.

  • Dexterity table expansions for developers.
After Convergence we will share any specific user features and enhancements we know you will love!