BTerrell Group Blog

Sage 300 ERP: Save Time With Shortcuts!

Posted by Kevin Yu on Sun, Nov 10, 2013

Ever wonder how much time you spend switching between your mouse and keyboard when entering large amounts of data?  With these Sage 300 ERP shortcuts, you will no longer ask yourself this question.  The following Sage 300 ERP shortcuts allow you to navigate most screens by only using your keyboard.

Read More

Tags: Sage Accpac ERP, Accpac, Accpac ERP, Sage 300 ERP, ERP Accpac, Sage 300 ERP Shortcuts, sage accpac shortcuts

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

A Brief Sage 300 ERP Retrospective

Posted by Chris Firra on Wed, Oct 02, 2013

Sage 300 ERP, formerly known as Sage Accpac ERP, has a long history that is older than even Sage Software (which was founded in 1981).  The software's origin can be traced back to 1976, when Don Thompson, Ted Comfoltey, Keith Wales, and Norm Francis formed the Basic Software Group.  The original product, marketed as Easy Business Systems, was first designed for the CP/M operating system, the original dominant operating system for microcomputers.  Here's a short recap of what happened afterward:

Read More

Tags: Accpac, Sage 300 ERP

Sage 300 ERP (Accpac): Sales History Reporting Using PowerPivot

Posted by Tony Zhang on Mon, Sep 30, 2013

This blog is a continuation of the Sage 300 ERP (formerly known as Accpac) business intelligence journey using PowerPivot, and covers Sales History reporting.

Why bother to re-create the Sales History out-of-the-box report from Sage 300 ERP?

The very answer also applies to questioning why I would need Business Intelligence (BI) when I already have my reports. In some sense, it is like comparing financial accounting and managerial accounting – both provide information to support business decisions, but their consumer, format, span and depth are different. Reports usually require certain formats and are created for a set of period, such as fiscal year or period. On the other hand, BI is flexible in its format. Many times it has powerful visualization ability, and can be generated for any period of time such as daily, weekly or monthly. It is important for the BI solution to provide a holistic view of the business and be able to adapt to changes quickly.

Read More

Tags: Accpac, Sage 300 ERP, reporting, Sales History

How to File a TWC Unemployment Report Using Sage 300 ERP or Accpac

Posted by Brian Terrell on Tue, Apr 30, 2013

Read More

Tags: Accpac, Sage Accpac, Accpac ERP, Sage 300 ERP, accpac tips