---
title: "Q&A: Sage 100 ERP- How to Change Item Valuation from Average Cost to FIFO"
description: "Q&A: Sage 100 ERP- How to Change Item Valuation from Average Cost to FIFO"
---

[Oasis Solutions Blog ](https://blog.oasisky.com)

# [Q&A: Sage 100 ERP- How to Change Item Valuation from Average Cost to FIFO](https://blog.oasisky.com/blog/qa-sage-100-erp-how-to-change-item-valuation-from-average-cost-to-fifo)

 Written by [Oasis Solutions](https://blog.oasisky.com/author/oasis-solutions) | Mar 4, 2015 7:57:45 PM

**Question:** Our Company owns **Sage 100 ERP (formerly Sage MAS90). **We are considering changing the valuation method of several inventory items from Average Cost to FIFO. How do we do this?

**Answer:**  Luckily, there is a utility that accomplishes this change. It is** Inventory Item Valuation Selection and Maintenance**. However, other steps are required are make the change from Average Cost to FIFO.

**Step 1: ** **First, we recommended the Items that are being changed are adjusted to a zero inventory balance**. This can be done using Inventory Management **>** Main **>** Transaction Entry. Using the Adjustment Option set the quantity to reduce the quantity on hand to zero, accept and post the journal.

**Step 2:  **Using the Utility go to Inventory Management > Setup > Inventory Management Utilities and Select the Item you wish to change using Item Valuation Change Selection:  Proceeded and Update the Register.

**Step 3:  **Set the Inventory Quantity back to the original amount using Inventory Management > Main > Transaction Entry using an Adjustment: For FIFO set the FIFO date for distribution, run the Register and update.

This question was submitted to [Mike Renner, Partner WAC Consulting](http://www.caserv.com/), Owner at Computer Accounting Services** **and appears on [Oasis Solutions Group](https://oasisky.com)'s Partner [ERP VAR's](https://erpvar.com) blog.

If you have questions about your Sage 100 ERP, Sage 500, Sage 50, or other ERP, CRM or HRMS software please contact us for help!

[View full post](https://blog.oasisky.com/blog/qa-sage-100-erp-how-to-change-item-valuation-from-average-cost-to-fifo)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Oasis Solutions"
  },
  "dateModified" : "2019-01-24T21:05:18.532Z",
  "datePublished" : "2015-03-04T19:57:45Z",
  "headline" : "Q&A: Sage 100 ERP- How to Change Item Valuation from Average Cost to FIFO",
  "image" : {
    "@type" : "ImageObject",
    "height" : 60,
    "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
    "width" : 60
  },
  "mainEntityOfPage" : "https://blog.oasisky.com/blog/qa-sage-100-erp-how-to-change-item-valuation-from-average-cost-to-fifo",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Oasis Solutions"
  }
}
```