Inventory Tracking

Contents of this Topic: ShowHide

Overview

Monsoon OMS keeps track of the number of units of a given item you can offer for sale across all warehouses. This number changes as you receive new inventory, ship orders, accept returns and process exchanges, etc.

While it is no longer possible to disable inventory tracking at a global level, individual items can still be excluded from Inventory tracking by selecting Ignore ATP on the inventory record.

Items excluded from inventory tracking

1. Mark the item as "Drop-Ship" in its inventory record. Monsoon OMS does not track ATP/QOH for items drop-shipped from a supplier (vendor).

Drop-ship items can still be backordered if necessary:

1. At the Process Orders screen, navigate to the appropriate order record and then select the item you wish to backorder by selecting anywhere in the item row.

2. Select the Force Backorder link on the accordion.

3. When Then use the Fill Backorders link in the Accordion.

2. Mark the inventory item as "Ignore ATP": This selection tells the program to assume this item is always in stock. For example, most of your items are probably physical products, such as books or clothing. But you may also sell "virtual" items such as software or books that are delivered electronically and thus are always "in stock".

Tracking inventory adjustments to warehouse QOH

1. To track changes made to inventory QOH values at each warehouse, set the system parameter TrackInventoryAdjustments (in the Program parameter group) to TRUE.

2. Each time the QOH of an item in any location is changed, the program stores the details (i.e. the reason for the adjustment, who made the adjustment and the increase or decrease).

3. To review these details, print the Inventory Adjustments report.

First-In, First-Out cost tracking (FIFO)  

• The program can track your cost of goods sold on a First-In, First-Out ( FIFO ) basis and is controlled by the system parameter TrackInventoryFIFO (in the Program parameter group). If this option is set to TRUE, the program tracks all incoming and outgoing inventory and its cost.

• FIFO requires a supplier cost is present for all inventory items. If inventory is received, or adjusted, etc. and it does not have its cost on file, the program prompts you to enter the cost at that time. 

• To set up your initial costs, go to the Main Menu>Settings>Inventory Functions>Initialize FIFO Data.

• Here you can initialize your costs, either from your existing inventory data, or by importing it from a text file.

• Once you begin to track your FIFO costs, you can check the FIFO status of any item by navigating to the appropriate item record at the Inventory screen and select the FIFO Status link in the Item tab.

• There are also two standard reports that provide FIFO information, FIFO Inventory Details by Supplier and FIFO Inventory Value by Supplier.

Sub-SKUs

• Having a unique SKU for each product variant allows Monsoon OMS to track your inventory at the product attribute level, i.e. colors, sizes, styles, etc. Variants are usually displayed to customers as drop-down lists from which they make selections.
• Some shopping cart systems are able to have unique SKUs for each variant of a product and it is not necessary to build sub-SKUs in the program.
• If your shopping cart does not have a way to create a unique SKU for each variant of a product, you can build them in Monsoon OMS by defining their Options in the Attributes and Options tab of the Inventory screen. You can build sub-SKUs for an individual product or as a batch process for all affected products.  
• When orders are  imported from your shopping cart, it combines the main or "parent" SKU for each item with the selected options and adds the correct sub-SKU to the order. The program is then able to track the ATP of the product at the attribute level.

• Real-time inventory tracking

• This feature is only available with some shopping cart systems.  It enables your customers see up-to-the-minute inventory status (in stock, out of stock, etc.) information about your products. Refer to the Shopping Cart Matrix.

• As items are received into Monsoon OMS' inventory or sold at the Manual Orders screen, the changes in inventory ATP are reflected in your Web store within minutes or seconds.

Additional information

Created: 10/11/11

Revised: 8/13/15

Published: 08/19/15