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.
BTerrell Group Blog
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.
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:
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.