Stephen Smith's Blog

Musings on Machine Learning…

The Sage 300 2016 KPIs

with 8 comments


The new Sage 300 Home Page provides a nice launching point for running your new Web based Sage 300 Accounting screens. It also provides a Home view where you can choose to display up to six KPIs out of a palette of twelve.


The twelve KPIs give a good selection of things from G/L, A/R and A/P since these are the accounting screens we are including with the first release. Then there will be more KPIs with the second release which includes the I/C, O/E and P/O screens and matching KPIs.

Some people love KPIs, others just find them a nuisance. Using the KPIs is entirely optional, it’s up to you to select what you wish to see. The KPIs are controlled by Sage 300 security, so if you don’t have rights for a KPI, it won’t be available to display.


Many of the KPIs have settings dialogs that you open from the hamburger menu. For instance below is the one for the Account Balances KPI where you choose the five accounts to show the balance for.


You can also edit the title of each KPI. You can re-arrange them on the screen using drag and drop. For KPIs with an associated report, there is another menu item on the hamburger menu that will open the report.

Technical Details

When we developed these, although I couldn’t blog on what we were working on, I did blog on some of the technical aspects that went into how these were implemented using CSQRY and then on caching and calculating these. For this on premise release, we aren’t implementing any of the cloud based technologies that would calculate these for you in the background. Instead we calculated these the first time you access them in a day, and then cache the result for the rest of the day. Most people open and close their browser pretty frequently so we want it to be quick. Of course you can select refresh from a given KPI’s hamburger menu to recalculate the data.

We had similar data widgets in our Sage 300 6.0 Portal, these new KPIs leverage what was developed there as well, for instance to display aging or to categorize financial data.


KPIs are a good way to see information relevant to your job quickly when you log in. Often you can use this information to decide what you need to do next, or to just keep your finger on the pulse of your business.


Written by smist08

September 6, 2015 at 11:05 am

8 Responses

Subscribe to comments with RSS.

  1. […] Introduction The new Sage 300 Home Page provides a nice launching point for running your new Web based Sage 300 Accounting screens. It also provides a Home view where you can choose to display up t…  […]

  2. Will these KPIs display dates in non-North American formats? (Sounds like a dumb question, but the previous Portal dashboard was hard coded in USA date formats, so was useless in Australia.)

    Stephen Coldwell

    September 29, 2015 at 3:32 pm

  3. Is this Sage 300 2016, or Sage 300c?

    Stephen Coldwell

    September 29, 2015 at 3:33 pm

    • At Summit, they tended to refer to the new web UIs as Sage 300c, which I’ve tended to be doing. But its really all part of Sage 300 2016.


      September 29, 2015 at 5:55 pm

  4. […] Receivable from Internet Explorer, Edge, Chrome, Safari or Firefox. There is a nice Home Page with KPIs, good international support and many usability enhancements. You can now easily access Sage 300 […]

  5. […] and Accounts Payables. The focus of this release isn’t on a new flashy portal with flashy KPIs (although we do have those) or other new technology enabled functionality. The focus is on the core […]

  6. […] have new KPIs for I/C, O/E and P/O. They are in the screen shot below, namely “Top Salespersons”, […]

Leave a Reply to Stephen Coldwell Cancel reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: