I love SalesPad dashboards in Microsoft Dynamics GP because you can literally get any metric you need to run your distribution business. That is a bold statement, so let me explain in more detail.
In general, the
However with the new SalesPad dashboards you have access to EVERY table stored in Microsoft Dynamics GP. This means that you can also get all the financial information such as cash flow, AR, AP, sales, customers, vendors and more.
We have one
Here are four things I especially like about SalesPad dashboards for Dynamics GP:
- Drill Down Features
One really cool feature is the built in drill-down capabilities. For example, one dashboard has top products by revenue and I can see a pie chart of the top 10 products. If I click into one of those products it drills down and tells me who bought it and then I can drill down further and see what invoice it was on. These drill-down capabilities can be helpful if you're trying to find out what made this product the top seller.
- Master Filtering
Another really nice feature is master filtering. Basically you can link all of the metrics on your dashboard to one metric. So let's say on your sales dashboard you have all of your metrics linked back to a sales rep. If you click on one of the sales reps’ names, all of the other metrics that are on your dashboard will filter through and only report on that one sales rep.
- New User Specific Security Rights
If you're making a financial dashboard that has a lot of sensitive information in it, you don't want to pick and choose people and overlook someone. So you can specifically name the CEO and CFO as the only people who can view the information, and it doesn't matter at that point what security group they were in.I'm a big fan of the way SalesPad handles security for the dashboards. Most of SalesPad security is based on user groups and you're either in that user group and have specific rights, or you're in a different group and you have separate rights. When it comes to dashboards, they have user-specific rights, which means that you can build a dashboard for Sales Rep A, Sales Rep B, Sales Rep C and each of them will only have access to their own dashboard. You don't have to be concerned about them seeing somebody else's information.
- Display Options
There are a number of different ways you can display dashboards. If you're selling very specifically, such as in territories, states and countries, there are maps that will highlight either the area where those sales are coming through.There are grids, pivot charts, pie tables, pie graph charts and different gauges. There are cards with the data right on them and then there are text boxes where you can leave additional notes.In my opinion, these SalesPad dashboards for Dynamics GP are fantastic!
Easy To Build
SalesPad dashboards are very easy to build. As soon as you build the connection to your Dynamics GP database, which takes only a few minutes, you have everything accessible to you. This is significantly easier if you have some SQL knowledge, because you can write queries to answer questions that you're asking often.
For example maybe your VP wants to know, ‘What is the status of year-to-date sales versus last year?’ or ‘What is our cash flow?’ If you are running these different queries and you know these reports, you can literally copy the query, paste it into the SalesPad dashboard and build your metric right off of that.
Push the Limits
I have built a number of SalesPad dashboards at this point, basically trying to stretch the limits to see how far I could push this idea and what I could make it do.
Right now my focus has been on the sales side. There haven’t been any questions that I haven’t been able to build a dashboard for, including fields of information that aren't in SQL, because with queries you can write in your own values.
I honestly believe that you can use SalesPad dashboards in Microsoft Dynamics GP to get any metric you need to run your distribution business.
Download the white paper, “