This report is a "snapshot" of all inventory products, providing
an accurate picture of the quantity of each product on the
shelf.
Note: 1.) If you have
set up warehouses and bins, the report includes subtotals for each
location for each item.
2.) Shipped and packed products that
have not been billed yet are considered to be part of the Committed
figures, however they are broken out as a separate value for each
item and are excluded from the Net on Shelf figure.
Note: Place your mouse
over the fields to view a description of the field.
If
you cannot see the report, please click the following button.
Field definitions for the Master Inventory Report
Stock Number - The
defined stock number for the stock item.
Description - The defined description of the stock
item.
Net on Shelf - The quantity of item that should be on the
shelf. This number consists of inventory available for sale (in
stock) as well as inventory already sold but not invoiced
(committed).
CHECK BOX - This is for your own use when using the report
to do physical inventory counts.
In Stock - This field is calculated as the Net on Shelf
minus Committed.
Low Level - LOW indicates that the quantity has fallen below
the established low level threshold, OUT indicates that the
quantity is currently at "0", NEED indicates that the quantity is
at "0", and that the item has back orders pending.
Back Ordered - The quantity of the stock item back ordered
on customer orders.
On Order - The quantity of the stock item ordered with
suppliers but not yet delivered.
Committed - The quantity of the stock item that has been
sold in customer orders but has not yet been invoiced.
Warehouse - The defined location(s) of the stock
item.
Average Cost - The calculated average cost of the stock
item, based on all purchasing history to date.
Inventory Value - The Net on Shelf quantity of the stock
item multiplied by the Average Cost figure for the stock item.
