BTerrell Group Blog

Sage 300 ERP (Accpac): Using PowerPivot for Dynamic ABC Analysis

Posted by Tony Zhang on Fri, Aug 30, 2013

This blog is a continuation on the Sage 300 ERP business intelligence journey on Power Pivot, covering ABC analysis, an inventory categorization technique often used in materials management, for both the valuation (cost) and sales of the IC item.

Read More

Tags: Sage 300 ERP, PowerPivot, Power Pivot, ABC Analysis, Sales History, Item Valuation, Inventory Categorization

Sage 300 ERP (Accpac): Using PowerPivot for Inventory Control

Posted by Tony Zhang on Fri, Aug 16, 2013

In my previous blogs, I shared PowerPivot solutions for Sage 300 ERP (Accpac) financials (AR, AP and Cash Flow Forecast). Starting in this blog, I’d like to tackle challenges from the operational side, starting with Inventory Control.

Read More

Tags: Sage 300 ERP, inventory control, PowerPivot, Power Pivot, Turnover, Turn Earn Index, GMROII