Over the last few months, I’ve been doing work with clients on creating some refreshable Excel reports. Working on one of them, we had parameters for dates and added one for Vendor ID, which is when I encountered an error:
Bad parameter type. Microsoft Excel is expecting a different ind of value than what was provided.
Microsoft Dynamics GP 2018 RTM has now been released. In this series of posts, I will be stepping through the installation of Microsoft Dynamics GP and additional products and then will move on to taking a look at the new functionality which has been introduced.
The series index for this series of posts is here and will automatically update as posts go live.
The deployment of the Excel Reports is is done via Reporting Tools Setup (Administration area page >> Setup >> System >> Reporting Tool Setup). Click the Excel Reports tab.
Change the Location to Network Share. Reports Directory can be set at both the System Level (for the out of the box reports) and User Level for customised reports.
You can also set a subfolder for where the reports are to be deployed; this is useful when you have more than just the Microsoft Dynamics GP reports deployed onto the report server.
Make sure the checkboxes in the Deployment Options section are checked and click the Deploy Reports button.
Microsoft Dynamics GP 2015 R2 has been released and, as with previous releases, Microsoft have started a Feature of the Day series on the Inside Microsoft Dynamics GP Team blog. As I have done with the last three series, I’ll be reposting these blog posts here with a little commentary.
The twenty second Feature of the Day is . A top suggestion on the MS Connect site, this feature moves the Debit column to display before the Credit column by default in account transaction reporting options in which the Credit column previously displayed before the Debit column.
This applies to SmartLists and Excel Reports, as well as the database tables and views on which the reports are based.
The Inside Microsoft Dynamics GP blog started a series of Microsoft Dynamics GP 2013 R2 Feature of the day posts the other day. As they did with the Microsoft Dynamics GP 2013 Feature of the Day posts they are doing them as short posts containing a PowerPoint slide show. I am translating these from the PowerPoints into posts; you can find my series index here.
The twentieth Feature of the Day covered is Dashboards. Four new reporting dashboards have been added to the Excel Reports in Dynamcis GP 2013.
The new dashboards are for the Financial, Sales, Purchasing and Inventory series and are deployed with the other Excel Reports. These refreshable reports can deployed to a shared network drive, SharePoint or SharePoint Online.
If the Excel Refreshable Report for SOP Line Items is used, it includes voids. The Data Connection properties have to be edited to exclude voids, rendering this refreshable report useless; unless you are not keeping voided transactions in History. I would like a column for voids added. Pretty much line item detail Excel Refreshable Reports will need this.
This would be a very useful feature to have and I would encourage you to go to MS Connect and vote.
To create the company, open GP Utilities (Windows Start menu » All Programs » Microsoft Dynamics » GP Utilities) by right clicking and select Run as Administrator. Log in as the SQL System Administrator (sa);