Sage 100 for light manufacturing
April 06, 2015
Sage 100 for light manufacturing
Score 6 out of 10
Sage 100 ERP Advanced (184.108.40.206)
- GL, AP, AR, Inventory, Sales Order, Purchase Order, RMA, Bill of Material, Work Order, MRP, Custom Office, Visual Integrator, Crystal Reports
Overall Satisfaction with Sage 100 ERP
Sage 100 ERP is used across the organization for inventory, purchasing, manufacturing, sales, and financials. It is the heart of running our business operations. We use MRP extensively to coordinate raw materials purchased [that are] scheduled [for] manufacturing. The ERP tracks our inventory levels, product sales availability, pricing, customer status, and sales history, etc.
- For its price point, Sage 100 is still one of the most versatile of all purpose ERP packages available. The utilities built into it are often not found in higher end products, which allows for much more flexibility.
- Some ERP systems focus on doing a few things very well. Sage 100 does a lot of things medium well. It's a question of balance.
- The user interface is pretty straightforward and consistent.
- A key missing function is to be able to track serial numbers and lots independent of item valuation method. The system will not track serial numbers for standard cost valuation items.
- This is a killer for manufacturing operations, which often use standard cost accounting.
- The non-work order production process, Bill of Material Production Entry, has no way to schedule a planned production order.
- If you could create a production order like a sales order, then light manufacturing operations would not need to implement the work order module (one of the most complex modules) in order to show planned production supply in MRP.
- Inventory Warehouse Transfers are currently instantaneous. There is no way to schedule a planned transfer with ship and arrive dates. No transfer in process documentation.
- This makes it difficult for MRP if you need to transfer material from one warehouse to another and need to factor in transport time.
- Reconciling Purchase Price Variance in the GL with sub system transactions is very difficult. Critical for Standard Cost Accounting PPV analysis.
- If the sub system transactions showed the transaction line standard cost and PPV value, then it would be much simpler to reconcile with the GL transaction data.
- While the work order module works, it is not very user friendly. Just getting a work order to the point that you can work on it is a multi step process requiring running posting reports.
- The work order partial completion costing logic is inadequate, requiring 100% of the WIP dollars be issued to the work order before doing a partial completion.
The last 20 years I worked as a Sage consultant implementing Sage 100 for customers. Other systems I dealt with were: Quickbooks, MS Great Plains, Expandable, Accpac (now sage). Downgrades from Oracle and SAP
There is no built in international or multi-currency functionality. Sage 100 is a US domestic product only. The sweet spot is mid size US distribution, and general purpose. Often, other systems excel at one or two things, then leave the inventory and accounting functions as after thoughts. Sage 100 does everything medium well.