Guess What is this?

 

image

image

It is the Microsoft Dynamics GP Business Analyzer, it really an awesome utility contains tons of adjustable dashboards out of the box, can’t wait to validate all dashboards!

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Why do I see empty charts in Fabrikam?

 

I have installed Dynamics GP 2010 R2 and really enjoyed walking through dashboards and KPIs added to the application, but most of the KPI’s does not show the actual company data, instead it is showing zeros as below:

image

This is actually not related to an installation issue, it is due to the fact that the report is using the current date while Fabrikam uses 2017 as the default year, to view the report with data, just click on the “View” icon and select the report:

image

Change the date:

image

And enjoy!

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Dynamics GP 2010 R2 Business Intelligence Installation Error maxRequestLength

 

During Dynamics GP 2010 R2, I have selected to deploy Dynamics GP Business Intelligence Reports over SQL Server Reporting Services, but before starting the installation, the system generated an error that maximum number of retries has been exceeded and was requested to set a maxRequestLength flag in the web.config.

Web.config could be located under the installation path of SQL Server Reporting Services, in my case it was under the following path:

C:\Program Files\Microsoft SQL Server\MSRS10.SQL2008\Reporting Services\ReportServer

in the web.config, search for <httpRuntime executionTimeout=”9000″ /> and include the variable there to make it looks like the below:

<httpRuntime executionTimeout=”9000″ maxRequestLength=”20690″/>

Somehow, 20690 in specific is required, it will not accept number higher!

Update: Below is the exact error message:

The deployment has exceeded the maximum request length allowed by the target server. Set maxRequestLength = “20690” in the web.config file and try deploying again.

Enjoy!

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Microsoft Dynamics GP 2010 R2 Just Released!!!

 
Posting LIVE from Dynamics Confessor Blogspot!! Leslie Vail just posted the below article:

http://dynamicsconfessions.blogspot.com/2011/04/gp-2010-r2-ready-to-download.html

It’s HERE!

The covers have been pulled off of the newest version of Dynamics GP. Some fabulous new features have been added that really make it worth your time to install. Links to all of the download are at the bottom of this post.

Take a look at some of the R2 updates to Foundation alone:

Business Analyzer – this is the absolute COOLEST!

You can use Business Analyzer to help you make business decisions by viewing
Microsoft Dynamics GP reports from your desktop. The following illustration
shows Business Analyzer from your desktop.

image

Home Page – Viewing multiple metrics
Multiple metrics can be displayed in your home page. You also can create your own
metrics to display in your home page.

Sending reports in e-mail messages
You can send most reports in an e-mail message if you’re using a MAPI compliant email
service. All reports sent in an e-mail will be sent in HTML format, which
doesn’t require any other setup procedures. The recipient of the report must be
using Internet Explorer 7 or higher to view the e-mailed report, but no additional
setup is required.
To send a report in an e-mail, you first must set up a report option. Then, you can set
up e-mail options for each report option. Those settings, which include recipients
for the e-mail and settings for embedding or attaching the report are saved with the
report option and you’ll be able to send updated reports to the same recipients.

Sending customized messages
You can create predefined messages to send to your customers and vendors. These
messages can be assigned to the documents that you want to send in e-mail so all
customers or vendors receive the same message for selected documents. For
example, you can send a promotional message to your customers when sending
sales quotes in e-mail. You also can assign a specific message to an individual
customer or vendor. For example, you can send a holiday greeting message to a
customer. When you create a message, you can enter an e-mail address so your
customer or vendor can reply to your e-mail.

You can customize your messages by adding fields that are associated with a
document type. For example, a message can be personalized to address each
customer or vendor by name. You could add the due date for a sales invoice in a
message or the PO number for a purchase order. You also can copy the message
information from an existing message ID to a new message ID.

Viewing Reporting Services metrics
You can use Microsoft® SQL Server® Reporting Services 2008 or Reporting Services
2008 R2 to display graphical representations of Microsoft Dynamics GP data in the
metrics area of your home page. Reporting Services metrics appear in the SQL
Reporting Services Report list.

Viewing additional information
If you want to analyze data in a Reporting Services 2008 or Reporting Services R2
metric displayed in your home page, you can click a data point in the metric to open
a detailed report for additional information. If you want to view additional data in
the detailed report, you can click certain data fields to open the maintenance or
inquiry window related to that data field.

Modifying a metric – At Last!
If you are using Report Builder 3.0 or Report Builder 2.0, you can open the Microsoft
SQL Server Report Builder window from the Metrics Detail window to modify SQL
Server Reporting Services metrics and KPIs (key performance indicators). SQL
Server Reporting Services R2 also must be installed and set up to use with Microsoft
Dynamics GP.

Opening a metric in Report Viewer
If you are using Reporting Services 2008 or Reporting Services 2008 R2 to display
metrics, you can click the View icon to display a metric in Report Viewer.

Installation and deployment features
Electronic Funds Transfer (EFT) for Receivables Management is installed along with
Microsoft Dynamics GP instead of as a separately selectable Microsoft Dynamics GP
feature.

Human Resources and Payroll Suite
This is now installed as a separately selectable Microsoft Dynamics GP feature instead as an additional component.

When deploying Reporting Services reports using the Microsoft SQL Server
Reporting Services Wizard, you can deploy reports to either Native mode (SQL Server Reporting Services) or SharePoint® mode.

You can deploy Reporting Services reports and Excel reports using Microsoft
Dynamics GP Utilities. After creating the system database or company database,
you can select which reports to deploy and the location to deploy the reports to.
Instead of selecting the series that you want to deploy reports for, reports for the
components that you have installed are deployed. If you are upgrading a company,
the deployed reports are automatically upgraded. In previous releases of Microsoft
Dynamics GP, you had to use a separate wizard to deploy SRS reports and a
separate wizard to deploy Microsoft Excel reports to Microsoft SharePoint.
If you aren’t ready to deploy reports using Microsoft Dynamics GP Utilities, you can
deploy reports using the Report Tools Setup window in Microsoft Dynamics GP.
You can use the Report Tools Setup window to redeploy reports or deploy reports to
a different location.

List Performance Enhancements YAY! WOO HOO!
List views provide a view of your data that you can customize in a variety of ways.
In Microsoft Dynamics GP 2010 R2, improvements were made to the speed at which
the information is displayed, enabling you to spend your time using the list rather
than waiting for it to display.

Report deployment
You can deploy SQL Services Reporting Services reports and Microsoft Excel report
using the Report Tools Setup window in Microsoft Dynamics GP. You also can use
the window to redeploy reports or deploy reports to a different location.

SmartList Builder Publish multiple Excel reports at once
You can use the new Bulk Deploy Excel Reports window and select multiple Excel
reports to publish at once, rather than publishing them individually.

SmartList Builder Set the default column order in SmartList Builder
You can define default column order using SmartList Builder so that the SmartList
is displayed with the columns in the order you want when it is first opened. A new
window, Default Column Order is added to SmartList Builder for determining the
column order.

SmartList Builder Drill Down to Extender and SmartLists
You can use the Drill Down Builder to create drill downs from Microsoft Dynamics
GP, SmartLists and Extender. A Dynamics GP Form drill down opens a Microsoft
Dynamics GP form and sets values on the form. A SmartList drill down opens a
SmartList and sets search parameters. An Extender drill down opens an Extender
Form or Detail Form and sets the values of the ID fields.

SmartList Builder Multicompany Excel Reports in a Single Excel Worksheet
You can add data from multiple companies into a single Excel Worksheet. In
addition, you can add the Company ID and/or Name to each line so that you can
see which company the data came from.

SmartList Builder Update Multiple field settings at one time
You have the ability to modify field options for multiple fields with the same field
type at once instead of one at a time. For example, you can select display options
such as currency symbols and percentage signs and mark several fields to display
the option for using the Set Field Options window.

Add Microsoft Dynamics GP forms to Extender menus
You can add Microsoft Dynamics GP forms to Extender menus using the Add
Dynamics GP Forms window allowing additional flexibility to the menus you
create.

Unified Communications and Office Communicator 2007 functionality was added. This functionality is also available using the Linked Lookup fields on Extender windows and forms, detailed forms, and extra windows.

Copy lists in Extender
You can copy list field items from one form or window to another one. The Copy
List Items window shows all the lists defined in Extender, so you can choose which
list to copy from; then, select all or individual list items to copy. In addition, you can
append the list you copy to the existing list items.

Matched Table Enhancements
In the Matched Tables window, you have new Table Description fields to help
identify the tables, and the ability to include fields that don’t appear in both
matched tables.

GET YOUR COPY NOW!

clip_image001

PartnerSource
Product Release Downloads for Microsoft Dynamics GP 2010
Word Template Generator for Microsoft Dynamics GP 2010 R2
Service Pack, Hotfix, and Compliance Update Patch Releases for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Visual Studio Tools for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Web Services for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Workflow for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for eConnect for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Web Services for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Integration Manager for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Workflow for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Personal Data Keeper for Microsoft Dynamics GP 2010

clip_image001[1]

CustomerSource
Product Release Downloads for Microsoft Dynamics GP 2010
Service Pack, Hotfix, and Compliance Update Patch Releases for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Visual Studio Tools for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Web Services for Microsoft Dynamics GP 2010
Software Development Kit (SDK) for Workflow for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for eConnect for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Web Services for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Integration Manager for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Workflow for Microsoft Dynamics GP 2010
Service Packs and Hotfixes for Personal Data Keeper for Microsoft Dynamics GP 2010

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Enhanced Inventory Item Reconciliation

 

I have several customers suffers reconciling their items the traditional way, they sometimes due to the huge number of transactions finds items contains “Allocated” quantities while it is actually not.

The normal process to fix this up is by following the standard procedure by getting all users outside GP >> Go to tools >> Utilities >> Inventory >> Reconcile, easy steps but what if you have a large number of items and wanted to perform this operation? This will definitely take hours.

As a part of the Professional Services Tools Library, MS team has introduced an enhanced Item Reconciliation Utility that reconciles only items that need to be reconciled!

Using Item Reconciler

Item Reconciler allows you to reconcile Inventory. The Reconciler’s function is the same as the reconcile functions built into Microsoft Dynamics GP with one exception: only those items that need reconciling will be reconciled using Professional Services Tools Library. This can increase performance if all items don’t need to be reconciled.

If you are interested in this feature, just go ahead and install Professional Services Tools Library from Dynamics GP DVD and follow the documentation.

The good thing about this tool is that the tools is available for free! No additional fees required.

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85 
me@mohdaoud.com
www.mohdaoud.com

Microsoft Dynamics GP – Management Reporter Issues

 

While trying to work on Management Reporter, I got the below error:

“The operation could not be completed due to a failure on the server.”

Followed several steps to investigate the issue, checked the functional currency and validated almost everything with no result, even searched the whole web with no result.

I finally decided to reinstall everything, uninstalled server, client, data provider and deleted the database then tried to reinstall, another issue came up:

“An error has occurred while implementing database on server, please refer to error log for more details.”

Error log detailed nothing about the issue, but when I tried to search the log about all database issues, I noticed that the management reporter being failed to grant database access to the domain Administrator user as it was already added.

Deleting the user from all databases and from the database logins level and reinstalling the application resolved the issue and the customer is currently enjoy reporting with management reporter!

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Dynamics GP 2010: Fuels Your Business Productivity

 

A marketing campaign is ready to be launched! Next Wednesday 13 April 2011 is the day of the event held in Sheraton – Amman 9:00 AM to 5:00 PM

Who should attend? If you feel like you have a need to purchase a new ERP to manage your business, this will be the best place for you to find out what can Dynamics GP do for your business.

Developers and Technicians will not really have any added values as the event is focused on how the profitability of the application will be presented and how to measure the value returned from the ERP investment.

Personally I’ll have 2-3 hours of this event, I will show the value of the business intelligence features introduced in Dynamics GP 2010 along with newly added Dashboards to business portal and Workflows.

In addition, I will present how the ERP will help NGO’s to manage their business requirements, and introduce modules that’s designed for not for profit organizations like Grants Management, Encumbrance Management and Budgeting.

clip_image002[10]

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
www.mohdaoud.com