Warehouse

Note: On the Inventory Balance Report, information by warehouse is not available at all for LIFO and FIFO costed items.

Also, when filtering by warehouse for Average Costing Method items, it is important to analyze all warehouses. This is because the Average Costing Method uses a weighted average of the costs of all items in all warehouses and maintains one actual, average unit cost for an item at all times. As a result, if you filter for a specific warehouse when the warehouse quantity is zero, some related warehouse data does not display, and the amount balance reported in the As Of column can be incorrect (more than zero).

On the other hand, when filtering by warehouse for an item that uses the Specific Costing Method and the warehouse quantity is zero, the As Of column displays zero. This is because the Specific Costing Method maintains the cost at the item location level, which is subordinate to the warehouse.

So, filtering by warehouse can be useful if you want only to check for quantities or you are using the Standard or Specific Costing Method for items.