Inventory List Report

Top  Previous  Next

The Inventory List Report is accessed through the Reports Window, Inventory folder and is used to display information regarding all active Inventory Stock Items.

 

invent list report window

 

The Inventory List 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 total number of units of the Inventory Stock Item currently on Inventory Purchase Orders but have not yet been received.
On Hand Quantity:  The current number of units of the Inventory Stock Item in the company's possession.
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.
Inventory Purchase Order Number (PO #):  The number of the most recent Inventory Purchase Order upon which the Inventory Stock Item was included.
Inventory Purchase Order Date (PO Date):  The date of the most recent Inventory Purchase Order upon which the Inventory Stock Item was included.
Paid For Quantity:  The total number of units of the Inventory Stock Item for which Vendor Invoices have been recorded.
Unit Average Cost:  The Total Average Cost divided by the Paid For Quantity.
Total Average Cost:  The total cost for the Stock Inventory Item.

 

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.  By default, Inventory Stock Items with no On Order Quantity, On Hand Quantity, Paid For Quantity and a Total Cost of zero would not be displayed on the report.  To show such Inventory Stock Items, select Yes on the Include Zero Items selection.

 

The sum of the Total Average Cost is displayed at the end of the report and should, ideally, match the current balance of the Inventory Account.  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 at the end of the report.