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.
BTerrell Group Blog
Tony Zhang
Recent Posts
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
Sage 300 ERP: How to Create a Cash Flow Forecast using PowerPivot
Posted by Tony Zhang on Wed, Aug 07, 2013
I recently blogged about using Excel’s PowerPivot functionality to create more flexible AR aging reports, and AP aging reports using Sage 300 ERP data. In this blog, I will cover how to create a cash flow forecast report based on the aged receivable and the aged cash requirements.
Tags: Sage 300 ERP, cash flow forecast, cash flow forecast with sage 300 ERP data
Sage 300 ERP: AR Aged Trial Balance Reporting using PowerPivot
Posted by Tony Zhang on Wed, Jun 26, 2013
This blog introduces the Sage 300 ERP A/R Aged Trial Balance Report, and presents solutions to address challenges like adding more Aging Periods, grouping by National Account, filtering by the Account Set (AR control account) at transaction level, and performance issue - using PowerPivot. PowerPivot is a free add-in to Excel 2010 and is a built-in functionality of Excel 2013.
Tags: Sage 300 ERP, A/R, Accounts Receivable, AR aged trial balance report