If you use Sage 300 ERP Payroll, you might like to have a dashboard to show how many years your employees have worked for your company,and in which place and position, like shown below. In addition, you also might like to analyze the payroll date in Excel as well, like the example in this link.
BTerrell Group Blog
Sage 300 ERP Payroll: Creating Dashboards Using PowerPivot
Posted by Tony Zhang on Fri, Feb 14, 2014
Tags: Sage 300 ERP, PowerPivot
This blog is a continuation on the Sage 300 ERP business intelligence journey using PowerPivot. I will focus on the financial statements in this blog.
Let’s begin by looking at the tools. Many tools are used to prepare financial statements, namely Income Statements, Balance Sheets and Cash Flow Reports. In the Sage 300 ERP (formerly Accpac) world, the three, Excel based, tools widely used are: FR (Financial Reporter), Sage Insight and Sage Intelligence.
Sage 300 ERP: Operational Data Analysis Using PowerPivot - Wrap-Up
Posted by Tony Zhang on Thu, Dec 05, 2013
This is my final blog wrapping up our series on Sage 300 ERP operational data analysis using PowerPivot. Follow this link to interact with the workbook. Please note, you need Excel 2013 Professional Plus and will need to enable the Power View add-in for the interaction with the “Sales Dashboard”, as shown in the first screenshot below.
Tags: Sage 300 ERP, PowerPivot