Set Available Minimum Stock Levels

Next

Company-wide minimum stock levels

Setting ‘Min Stock’ levels on an item basis in Furniture Wizard. This is set up if the goal is to have a minimum available stock level in all of the branches combined. You can also set up a minimum stock level per branch, in combination with the minimum stock level company-wide.

Setting preferences for minimum stock levels

Before setting up minimum stock quantities, you must:

  1. Open Extended Preferences

  2. Select Additional Settings

  3. Uncheck the ‘Auto Fill Purchase Orders by Branch’ box.
    This will now allow the entry to ‘Min Stock’ and ‘Order Qty’ on the Misc tab of the inventory item (discussed below).

Set your Minimum Quantities per inventory item.

  1. Open an inventory item and select the miscellaneous tab

  2. Select Edit

  3. Enter the Minimum Stock and Order Quantity of the item

    Min Stock- Minimum stock company-wide (sum of all branches)

    Order Qty -  Quantity of the item that must be ordered on a PO, used in conjunction with the minimum stock field. (most of the time this will be 1)

    For Example, if this item needed to be ordered in pairs (Order QTY= 2, Min Stock= 4). Now, if the inventory level goes to 3, Furniture Wizard would order 2 to bring the stock quantity to 5, which is above the minimum level of 4.

Minimum Stock Reports

To determine how many items, if at all, need to be ordered, use Report #168 - Inventory Criteria Fill-in by Supplier. This will not only show you the stock status of the supplier’s inventory to be ordered, but also the quantity to order, the amount to order, and the total amount.

As you can see below:
The chair and sofa both have a ‘Min Stock’ of 2; however, they have 1 available and 1 ‘on order’, so the ‘Qty to order’ remains 0.
The Loveseat has a ‘Qty in stock’ of 3, a ‘Qty on hold’ of 2, which puts a ‘Qty available’ of 2, but also a ‘Qty on order’ of 1, and a ‘Min Stock’ of 4. This then puts the ‘Qty to order’ at 2.

Report #287 - Inventory Criteria will provide you with a list of all inventory items with a minimum stock, the minimum stock set, and the reorder quantity set.

Purchase Order Entry

When creating a Purchase Order, regardless of the ship-to branch, the Auto Fill Stock button will order the quantity to get back to the minimum stock set earlier.

  1. When creating the PO select the Supplier as usual. (Notice the ‘Ship To’ is the warehouse because that is where the items need to be shipped to, not because that is where the minimum levels are set)

  2. Auto Fill Stock - This will automatically add all inventory items for that supplier that are below the minimum stock quantities.

    1. You can add other items to this PO as well.

  3. Post and continue your typical PO process.

Setting Available Minimum Inventory Quantities on a Branch level as well

You still need to set your Minimum Quantities per inventory item, as done earlier in this article, and also repeated below.

  1. Open an inventory item and select the miscellaneous tab

  2. Select Edit

  3. Enter the Minimum Stock- Minimum stock company-wide (sum of all branches)

    Order Qty -  Quantity of the item that must be ordered, used in conjunction with the minimum stock field.

You then need to go to the inventory grid on the ‘Check Stock’ tab to update the minimum stock quantities per branch.

  1. Check Stock

  2. Edit

  3. Scroll over and enter the minimum stock on the branch level.

    This item now has a total minimum stock value of 4, but a minimum stock of 1 at the showroom.

Transferring items to satisfy the minimum stock on the branch level

Use the Auto Fill Stock Function on a new transfer to satisfy the minimum stock quantities at the branch level. In this example, we have a minimum stock value of 4 and a branch-level minimum stock value of 1 in the showroom. We have ordered and received this item in quantity 4 in the warehouse. Now we need to transfer quantity 1 to the showroom to satisfy the minimum stock quantities in that location.

  1. New Transfer

  2. Set the ‘From’ and ‘To’ Locations for the Auto Fill Stock transfer

Now add the correct items to the inventory transfer.

  1. Auto Fill Stock

    The item(s) will now appear on the transfer, and you will continue the transfer process as normal.