We would like to switch to using the FIFO method to value our inventory.

If you are currently using the replacement cost method and would like to update your system to use the FIFO method, you will want to take the following steps in Softbase:

First, you want to create a FIFO cost record for all parts in your inventory.  This is done under the Parts Setup module in the Setup tab. Click on the Correct FIFO tab, and then run the program for a warehouse.  It will show you any discrepancies in the system, such as the part MSO15 below sowing an on hand of 14 but having no FIFO costs recorded.

Use the Correct button to create a FIFO record for each quantity in your system (or remove any excess FIFO records) and then repeat for all warehouses.

Once FIFO records are created and are consistent with the on hand values, you will want to switch the warehouse to reflect the FIFO costs.

This is also done in the parts setup module under the Warehouses tab.  For each warehouse, you will want to ensure you have checked the option to use FIFO and update.

Once this is completed, your warehouses will be set to use the FIFO method for valuation and your FIFO records will be matched to reflect your inventory on hands.

• Related Articles

• Physical Inventory

  Before starting the Physical Inventory Count process in Softbase, you will first want to run a report to capture the inventory counts and values. To do that in Softbase, on the Reports tab, run the following Report: Parts Inventory Valuation ...

• Parts Inventory Reconciliation (not using WIP)

  To reconcile inventory, there are a few variables that need to be considered when looking at your physical valuation when comparing it to the GL account balance. First, the costing method being used to value inventory will be either replacement cost ...

• FIFO (First In, First Out)

  Overview FIFO, or First In, First Out, is a method of inventory management where the oldest items in inventory are assumed to be sold first. This ensures that inventory costs are based on the assumption that the oldest items are sold first, ...

• What is FIFO and how is it calculated?

  FIFO is an acronym for first in, first out. It is a cost layering concept under which the first goods purchased are assumed to be the first goods sold. The concept is used to devise the valuation of ending inventory, which in turn is used to ...

• Parts Reconciliation using Accrual Based Accounting

  To reconcile inventory, there are a few variables that need to be considered when looking at your physical valuation when comparing it to the GL account balance. First, the costing method being used to value inventory will be either replacement cost ...