Clients First USA
Clients First knows their software, but they are also astute business people, and they really understand manufacturing and distribution in particular.
Jimmy Witcher, COO, Merrick
Read More
About UsService OfferingsProduct OfferingsIndustries ServedDownloadsBlogTestimonials

Subscribe to our mailing list

* indicates required
    Interested in    
Hot Topics

Posts Tagged ‘mas 200’

What’s New in Sage ERP 100 through Version 4.00 to Sage ERP 100 2015

Tuesday, March 10th, 2015

A great document showing the workflow and functionality changes that have occured since Sage MAS90 & Sage MAS200 4.00 all the way through Sage ERP 100.

Using this document you can see all the functionality that you might be missing from the version you are currently on to the most current version.  Simply upgrade (we can help) and you’ll get the ‘delta’ in functionality.

Sage ERP 100 Upgrade Guide

Types of Inventory and Inventory Accounts for manufacturing company

Monday, February 4th, 2013

Setup Tips

In a Manufacturing company, you start from purchasing raw materials and end up selling finished products: 

Purchase Raw Material >–(convert)–> Work-In-Process >–(convert)–> Finished Goods >>>>Sales of Finished Goods

Thus, there are 3 types of inventory for a typical manufacturing company:
1) Raw Material Inventory – raw material to be used as input in manufacturing process
2) Work-in-Progress (WIP) Inventory – Goods which are still in the process of converting to finished goods. It’s not yet a finished good. (If your solution supports WIP)
3) Finished Goods Inventory – Completed unit output from manufacturing process.

Correspondingly, three inventory accounts are needed.
1) Raw Material Inventory Account
2) Work-in-Progress (WIP) Inventory Account
3) Finished Goods Inventory Account

When raw material is purchased, the cost of the raw material will be posted to theRaw Material Inventory account. Raw Material Inventory Account will store the value of raw materials received but not yet issued to production department.

When the raw material is transferred to production department, the cost of the material will be transferred from Raw Material Inventory Account to WIP Inventory AccountDirect Manufacturing Labor Cost and Manufacturing Overhead Cost will also be debited into WIP Inventory Account.

When the finished good is completed, the WIP Inventory Account will be credited with the total manufacturing cost and the cost will be debited into Finished Goods Inventory account.

When the Finished Good is sold, the cost will be transferred from Finished Goods Inventory Account to Cost of Goods Sold (COGS) Account.

Switched from Hotmail to and now Outlook won’t login with your old Outlook Hotmail Connector?

Thursday, August 2nd, 2012

Microsoft previews the new

If you’ve been a user of Hotmail (gulp, I admit I am on) you know that its actually been improving dramatically over the last few years.  Many gave up long ago when it was slow and clumsy and ‘uncool’ compared to Gmail.  Microsoft has slowly but steadily improving it.

Recently they completely rebranded it and created a completely new User Interface.  It’s now known as (You can still use as well).

If you choose to move to the new interface, all of your existing email, and settings comes along and by default your email account is still (Where ‘xyz’ is your email name)

They give you a cool option to change that to while still allowing to be delivered to you.  You have the choice of having email from both merge into none inbox or keeping them separate.

One feature Hotmail (and now has had for awhile is Alias’s.  You can create up to 5 additional email addresses that all still feed to your primary account.

Problem with Outlook Plug-in.

Outlook for the Desktop (part of Microsoft Office) had gotten a slick Connector about 2 years ago that allowed your Hotmail account to be manageable within Outlook as a separate series of folders.  It works just as well as when Outlook is connected to Exchange.

Microsoft hasn’t yet rebranded or released a new version of this connector (keep in mind is still technically ‘beta).  However, if you keep your originally address, all still works perfectly.  However, if you switch to, your Outlook plug-in will attempt to login with your prior and not be able to login.  It will present you with a screen to enter your password.

However, the user id of is NOT editable.  It took me about an hour to figure this out.  Hopefully this helps you.  Changing this user ID turned out to be simple.

  1. Completely quit Outlook.  Give it a few seconds to fully shut down.
  2. Go into your Control Panel and locate the Mail Control Panel App.
  3. Click on “E-Mail Accounts”
  4. Double Click the ‘’ row
  5. Now change the E-mail Address to ‘’
    1. If you want to change how it appears in outlook, so it says click the Advanced button
    2. In the bottom portion of the screen under Mail Account, change to
  6. Click OK
  7. Click Close, then Click Close again.
  8. Re-open your MS Office Outlook desktop application and all should be good!

I hope you found this helpful and it should save you the frustration I found.  My guess is this is going to become a common issue as people become aware of and run into this issue.

Purchase Agent for 4.5 now Available

Monday, June 11th, 2012

Automate your MAS90 (Sage ERP 100) Purchasing

JobOps has released this latest version of Purchase Agent.  We have a detailed blog post on this over at our 90Minds sister site.

The most important change from prior versions is, like it’s big brother, Component Exception Manager (CEM) from the full JobOps solution,  it will now blow through the Bill of Materials (BOM) to look at purchase requirements.

This means, if you have a Widget made up of item ABC and XYZ and to make one Widget, you need two of ABC and two XYZ, Purchase Agent will look at the minimum stocking levels and Sales Orders for item Widget, and suggest the purchase (times 2) of ABC & XYZ.  Previously, prior versions could only order finished goods and was not appropriate for companies who assembled products.


Calculating Available Quantities and Costs – Tips & Tricks For MAS90 & MAS200

Tuesday, April 3rd, 2012

How is costing and Quantity Availability calculated in Sage ERP 100 (MAS 90 & MAS 200)?

imageCustomers often ask us how the Sage ERP MAS 90 Inventory Management module
calculates costs and quantities available. Here we provide the explanation.

Calculating Quantity Available

Here we describe the calculation used for printing the quantity available on Inventory Management and Bill of Materials module reports. The calculation depends on the selections in the Include in Quantity Available in the Inventory Management Options window.

  • Due to the differences in vendor lead times from business to business, the quantity on purchase orders can be used when calculating the quantity available. To include quantity on purchase orders in the quantity available calculation, select Purchase Orders.
  • Due to the differences in manufacturing lead times, quantity on work order can be used in the quantity available calculation. To include quantity on work orders and quantity required for work orders in the quantity available calculation, select Work Orders.
  • To include both quantity on purchase orders, work orders, and quantity required for work orders in the quantity available calculation, select POs and WOs.
  • If you prefer that the quantity available calculation not to be considered in either purchase orders or work orders, select No POs and WOs.

The quantity available is calculated using:

[Quantity on Hand + Quantity on Purchase Order + Quantity on Work Order] – [Quantity on Sales Order + Quantity on Back Order + Quantity Required for Work Order].

Inventory Item Cost Hierarchy

The valuation method of an item affects the order in which each type of cost is used in the Sales Order, Purchase Order, and Inventory modules. Below we describe the hierarchy used for each valuation or costing method.

Standard Valuation Cost Hierarchy

The standard cost from the Inventory Masterfile is the first value used for unit cost. If the standard cost is zero, the unit cost defaults to the last cost. If the last cost is zero,
the unit cost defaults to the warehouse average cost. If the warehouse average cost is zero, the unit cost defaults to the item average cost.

Average Valuation Cost Hierarchy

The warehouse average cost from the Inventory Masterfile is the first value checked for unit cost. If the warehouse average cost is zero, the unit cost defaults to the item average cost. If the item average cost is zero, the unit cost defaults to the last cost. If the last cost is zero, the unit cost defaults to the standard cost.

FIFO/LIFO/Lot/Serial Valuation Cost

For purchases, the vendor last cost is the first value checked for unit cost. If there is no vendor last cost, the last cost from the item costing file is used. If the last cost is zero, the unit cost defaults to the standard cost. If the standard cost is zero, the unit cost defaults to the warehouse average cost. If the warehouse average cost is zero, the unit cost defaults
to the item average cost. Once goods are received, the cost is recorded in the FIFO/LIFO/LOT/Serial cost tier, and the specific cost tier value is used in all transactions.

Other Considerations

In the Sales Order module, the determination of what cost to apply is calculated during the Sales Journal update. When using a pricing method that is a Markup Percentage or a Markup Amount and the standard cost is zero, the cost hierarchy is followed to determine the unit price.

In the Inventory module, the hierarchy determines the cost used in Inventory Transaction Entry for all transaction types.

In the Purchase Order module, the Auto Generate Orders Selection Window uses the following hierarchy when selecting Update Unit Cost With:

1. Standard Default or Last Unit Cost: the Primary Vendor’s last cost is used.

2. Standard Unit Cost: the item’s standard cost is used.

3. Average Unit Cost: the item’s average cost is used.

4. If any of the costs are zero for the above selections, the unit cost used follows the cost hierarchy based on the valuation methods listed.

Please call us with your questions.