The Inventory List by Warehouse Report is accessed through the Reports Window, Inventory folder and is used to display information regarding all active Inventory Stock Items within each separate Showroom/Warehouse. Further, unlike the Inventory List Report, the Inventory List by Warehouse Report can be printed retroactively to view Inventory information as it existed in prior fiscal periods.
The Inventory List by Warehouse Report displays pertinent information of the Inventory Stock Item including the Stock Number, Sales Category Code, Description, Style / Size, Color / Finish, Vendor Code, Storage Location, and Manufacturer's Catalog Number. Following such information are the current quantities, dates, and costs:
| • | On Order Quantity: The number of units of the Inventory Stock Item currently on Inventory Purchase Orders being shipped to the particular Showroom/Warehouse. |
| • | On Hand Quantity: The number of units of the Inventory Stock Item residing in the particular Showroom/Warehouse. |
| • | Unit Estimated Cost: The Unit Estimated Cost as entered by the user on the Inventory Stock Item Window - Stock Item Tab. |
| • | Unit Sell Price: The Unit Sell Price as entered by the user on the Inventory Stock Item Window - Stock Item Tab. |
| • | Paid For Quantity: The number of units of the Inventory Stock Item in the Showroom/Warehouse for which Vendor Invoices have been recorded. |
| • | Unit Average Cost: The Total Average Cost divided by the Paid For Quantity. |
| • | Total Average Cost: The cost of all of the units of the Inventory Stock Item within the Showroom/Warehouse. |
By default, the Inventory List by Warehouse Report displays information for the current fiscal month but the report can be printed retroactively by selecting the desired period on the Fiscal Month menu.Ranges for Stock Number, Style / Size, Color / Finish, and Vendor and Sales Category Codes are available to narrow the scope of the report. The Stock Inventory Items can be sorted by Stock Number, Style / Size, Color / Finish, Vendor, Storage Location, and Sales Category within the Showroom/Warehouse as determined by the Sort By selection. The full description of the Stock Inventory Item can also be optionally displayed.
The sum of the Total Average Cost is displayed for each Showroom/Warehouse and at the end of the report which should, ideally, match the current balance of the Inventory Account for the selected fiscal month. The total Units On Hand and Retail Value, which is the sum of the On Hand Quantity and Unit Sell Price for each Inventory Stock Item, are also displayed for each Showroom/Warehouse.