Warehouses window

From Orders, select Manage inventory> Manage products, select a product from the list of Current Products, and click Warehouses

Delete button

Click to delete a product's warehouse. The following conditions exist for deleting a product's warehouse:

  • The warehouse must be empty of all inventory.
  • The warehouse cannot be the product's Default warehouse.
  • No orders can be open for the product stored in the warehouse.

Product Code

(read only) Displays the code of the product for which you are setting up warehouses and defining inventory parameters.

Warehouse

Enter a warehouse location for a product. Select the Find icon to look up a warehouse location; warehouse locations are defined on the Set up warehouses window (from Orders, select Set up warehouses).

Bin

(optional) Use this field to define a specific bin where a product is stored in a warehouse.

Minimum Order Point

Enter a reorder point for a product's inventory. When a product's inventory at a warehouse drops to the reorder point, iMIS informs you that you need to reorder the product when you print the Product Reorder List report (from Orders, select Generate reports, select the Product report type, and select Product Reorder List). iMIS compares the products in inventory to the Minimum Order Point to determine if the product should print on the report.

Minimum Order Qty

Enter a minimum amount of a product to reorder for a warehouse. Often, the quantity entered depends on the order quantity required for receiving a vendor discount. When the inventory level drops below the Minimum Order Point, the suggested Minimum Order Qty prints on the Product Reorder List report (from Orders, select Generate reports, select the Product report type, and select Product Reorder List).

On Order

Enter the number of products currently on order for a warehouse.

The value entered in the On Order field is the value that displays in the On Order field on the Manage products window. If you store a single product's inventory in multiple warehouses, the On Order field on the Manage products window displays the combined total product quantity on order for all the warehouses.

iMIS automatically decreases the number of products entered in the On Order field on both the Inventory and Manage products windows when you post product receipts.

Expected Arrival

Enter the date a reordered product is expected to arrive at a warehouse.

Standard Cost

Enter the standard cost of a reordered product for a warehouse. You only need to enter a Standard Cost if you selected Standard Cost as the Valuation Method on the Inventory System Setup window (from Orders, select Set up module, and click Inventory).

Last Received

(read only) Displays the last date a product receipt was posted to inventory for a warehouse. Only inventory receipts, and not inventory adjustments, update the Last Received field.

Income Account

Enter the income account number for a product stored in a warehouse. Select the Find icon to look up an account number; individual accounts are defined for the GL_ACCOUNT table on the Set up general lookup/validation window (from Customers, select Set up tables > General lookup/validation).

Inventory Account

Enter the inventory account number for a product stored in a warehouse. Select the Find icon to look up an account number; individual accounts are defined for the GL_ACCOUNT table on the Set up general lookup/validation window (from Customers, select Set up tables > General lookup/validation).

Cost of Goods Sold

Enter the cost of goods sold account number for a product stored in a warehouse. Select the Find icon to look up an account number; individual accounts are defined for the GL_ACCOUNT table on the Set up general lookup/validation window (from Customers, select Set up tables > General lookup/validation).

Adjustments Account

Enter the adjustment account number for a product stored in a warehouse. Select the Find icon to look up an account number; individual accounts are defined for the GL_ACCOUNT table on the Set up general lookup/validation window (from Customers, select Set up tables > General lookup/validation).

Quantities

On Hand - (read only) Displays the total quantity of a product currently in inventory at a warehouse.

Reserved - (read only) Displays the reserved quantity of a product (pre-invoiced products in open order status) in inventory at a warehouse. Reserved products include backorders.

Available - (read only) Displays the quantity of a product currently available in inventory at a warehouse (On Hand products minus Reserved products).

Costs

Total - (read only) Displays the total cost of a product in inventory at a warehouse. The total cost is a cumulative running balance of receipts minus the cost of goods sold and/or inventory adjustments.

Avg/Std - (read only) Displays the average or standard cost of a product at a warehouse on a per unit basis, depending on the option selected to determine the cost of goods sold.

Last Cost - (read only) Displays the last amount paid for a product in inventory at a warehouse. The cost is calculated on a per unit basis. Only inventory receipts, and not inventory adjustments, update the Last Cost field.

The value that displays in the Last Cost field is the value entered in the Unit Cost field on the Enter and edit receipts and adjustments window (from Orders, select Manage inventory > Enter and edit receipts and adjustments).

Warehouses

Displays all of the warehouses set up for a product. Each warehouse line item displays a warehouse's code and account information.

To define warehouse parameters

Before defining warehouse parameters, make sure that you have defined the individual warehouses on the Set up warehouses window (from Orders, select Set up warehouses).

  1. From Orders, select Manage inventory > Manage products to open the Manage products window.
  2. Select a product from the list of Current Products.
  3. Click Warehouses to open the Warehouses window.
  4. Click New.
  5. Enter the location of the Warehouse (select the Find icon to look up a warehouse location).
  6. (optional) Enter the Bin in which the product is stored in the warehouse.
  7. Enter the product information.
    • Enter the product's Minimum Order Point.
    • Enter the product's Minimum Order Qty.
    • Enter the number of products On Order.
    • Enter the product's Expected Arrival date.
    • (optional) Enter the product's Standard Cost if you selected the Standard Cost valuation method on the Inventory System Setup window (from Orders, select Set up module, and click Inventory).
  8. Enter the warehouse's Income Account (select the Find icon to look up an account).
  9. (optional) Enter the warehouse's remaining account numbers. These account fields display only if the Generate Cost of Goods Sold option is enabled on the Inventory System Setup window (from Orders, select Set up module, and click Inventory):
    • Inventory Account (select the Find icon to look up an account)
    • Cost of Goods Sold (select the Find icon to look up an account)
    • Adjustments Account (select the Find icon to look up an account)
  10. Click Save.

To edit warehouse parameters

  1. From Orders, select Manage inventory > Manage products to open the Manage products window.
  2. Select a product from the list of Current Products.
  3. Click Warehouses to open the Warehouses window.
  4. Click Edit.
  5. Select a warehouse line item from the list of Warehouses.
  6. Make any necessary changes.
  7. Click Save.

To delete a product's warehouse

Once you remove a product's warehouse, you cannot post any outstanding, non-posted inventory transactions for that warehouse. If you post inventory transactions manually (recommended) and remove a product's warehouse, all non-posted inventory transactions will be removed from the Post receipts window (from Orders, select Manage inventory > Post receipts).

However, non-posted inventory transactions will still display on the Enter and edit receipts and adjustments window (from Orders, select Enter and edit receipts and adjustments).

  1. From Orders, select Manage inventory > Manage products to open the Manage products window.
  2. Select a product from the list of Current Products.
  3. Click Warehouses to open the Warehouses window.
  4. Select the warehouse you want to delete from the list of Warehouses:
    • The warehouse must be empty of all inventory.
    • The warehouse cannot be the product's Default warehouse.
    • No orders can be open for the product stored in the warehouse.
  5. Click Delete. A message displays prompting you to confirm deleting the selected warehouse.
  6. Click Yes to delete the warehouse.