Posting transactions for multiple warehouses

While the process of posting inventory transactions for multiple warehouses and standard inventory is the same, you need to be aware of the following when posting transactions for multiple warehouses:

Removing warehouses

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 and remove a product's warehouse, all non-posted inventory transactions will be removed from the Post receipts window. 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).

Inventory transfers

Transferring inventory from one warehouse to another affects both product cost and inventory field values when a transfer is posted.

Cost of Goods Sold - Regardless of whether the Average or Standard Cost valuation method is selected when the Cost of Goods Sold option is enabled on the Inventory System Setup window, the following rule applies when posting inventory transfers:

Warning!  

The extended amount of the transferred product cannot exceed the current total cost of the From Warehouse.

If the extended amount of the transferred product exceeds the current total cost of the From Warehouse, then iMIS will perform the following calculations:

  1. The average cost of the From Warehouse will be multiplied by the quantity transferred in determining that the average cost does not exceed the total cost:
  2. If the average cost does not exceed the total cost, then the extended amount will be recalculated by multiplying the average cost by the quantity transferred. The unit cost of the transferred product then will be updated by dividing the extended amount by the quantity transferred.
  3. If the average cost does exceed the total cost, then the extended amount will equal the total cost of the product inventory. The unit cost of the transferred product then will be updated by dividing the extended amount by the quantity transferred.

Field recalculation

The following fields will be recalculated when transferring inventory from one warehouse to another:

  • From Warehouse

    • Qty on Hand (Manage products window) will be reduced by the Quantity (Enter and edit receipts and adjustments window) transferred.

    Total cost (Warehouses window) will be reduced by the Ext Amt (Enter and edit receipts and adjustments window) of the product transferred.

    Avg/Std cost (Warehouses window) will be updated by dividing the Total cost (Warehouses window) by the Qty on Hand (Manage products window).

  • To Warehouse

    • Qty on Hand (Manage products window) will be increased by the Quantity (Enter and edit receipts and adjustments window) transferred.

    Total cost (Warehouses window) will be increased by the Ext Amt (Enter and edit receipts and adjustments window) of the product transferred.

    Avg/Std cost (Warehouses window) will be updated by dividing the Total cost (Warehouses window) by the Qty on Hand (Manage products window).

To post inventory transactions

  1. From Orders, select Manage inventory > Post receipts to open the Post receipts window.
  2. (optional) Sort the inventory transactions using the drop-down list.
  3. Select the transaction(s) you want to post.
  4. Click Post. A message displays prompting you to verify posting the selected transaction(s).
  5. Click Yes to post the transaction(s). A Product Posting report generates automatically.