BTerrell Group Blog

Sage 300 ERP (Accpac): Purchase History and KPIs Using PowerPivot

Posted by Tony Zhang on Fri, Oct 18, 2013

This blog is a continuation on the Sage 300 ERP business intelligence journey using PowerPivot, and covers Purchase Analysis.

In the following Purchase History example, I created a KPI to compare the purchase unit cost with the number from the previous year.  The unit cost is greater than 105% from the previous year, so it's highlighted in red.  This screenshot shows a number as green if the number is within the target and yellow as a warning you are about to be out of the target.

Read More

Tags: Accpac, Sage 300 ERP, KPI, Purchase history, PowerPivot