The output of this report may be affected by Regional Processing restrictions.If you select specific products at the Product field, you inactivate the Group, Category, and Brand fields.
Merchandising and Distribution > Inventory > Inventory Management > Report Stock Status
Merchandising and Distribution > Inventory > Report Stock Status
This report shows the quantity on hand The total quantity of inventory-type items physically in the warehouse., net available, and net purchase order status of all regular, saleable The total quantity-on-hand less the as-is quantity. inventory. The report also shows the number of times the product has been invoiced and the number of units shipped month-to-date and year-to-date. The report can print either a combined report of all warehouse/store locations or each location individually. You can sort by brand, category, and/or group.
The output of this report may be affected by Regional Processing restrictions.
If you select specific products at the Product field, you inactivate the Group, Category, and Brand fields.
ProductUse this field to indicate the product or products to include in this report. One, multiple, or All products may be selected. To report on a single product select a specific product code at this field. To report on All Products, leave this field blank. To report on multiple products, use the Multiple Product Selection screen (available from Actions) to select the products for this report.
GroupUse this field to indicate the product group or groups to include in this report. One, multiple, or All groups may be selected. To report on a single group select a specific group code at this field. To report on All Groups, leave this field blank. To report on multiple groups, use the Multiple Product Group Selection screen (available from Actions) to select the groups for this report.
CategoryUse this field to indicate the category or categories to include in this report. One, multiple, or All categories may be selected. To report on a single category select a specific category code at this field. To report on All Categories, leave this field blank. To report on multiple categories, use the Multiple Product Category Selection screen (available from Actions) to select the categories for this report.
BrandUse this field to indicate the brand or brands to include in this report. One, multiple, or All brands may be selected. To report on a single brand, select a specific brand code at this field. To report on All Brands, leave this field blank. To report on multiple brands, use the Multiple Brand Selection screen (available from Actions) to select the brands for this report.
VendorUse this field is used to indicate the vendor or vendors to include in this report. One, multiple, or All vendors may be selected. To report on a single vendor select a specific Vendor code at this field. To report on All Vendors, leave this field blank. To report on multiple vendors, use the Multiple Vendor Selection screen (available from Actions) to select the vendors for this report.
CollectionUse this field to indicate the product collection or collections to include in this report. One, multiple, or All collections may be selected. To report on a single product collection, select a specific collection number at this field. To report on All Collections, leave this field blank. To report on multiple collections, use the Multiple Collection Selection screen (available from Actions) to select the collections for this report.
Enter the regions to which you want to restrict this report's output. To access this field,
Regional Processing must be active (via the Regional Processing field in the General System Control Settings),
you must not be restricted to any store or list of locations, via the Location Restrictions tab When a routine is too large to fit on one screen, it is separated into one or more tabs, so called because they resemble the tabs on filing folders. in the Create a User (Staff) file , and
the location prompt on this screen must be blank.
StoreEnter the locations you want to include in this report. If you know the code of the location, enter it directly. If you click on the Arrow, a list of locations appears from which you can choose. If you select Multiple Locations from the list, the Multiple Locations Selection Window appears from which you can choose one or more locations. You can also access the Multiple Locations Selection window if you click on the Action button An outlet to additional routines and functions. Identified by a lightening bolt image, Action buttons appear next to fields and at the bottom of a screen.. If you click on the Search button in the Multiple Locations Selection Window, you access the Multiple Selection Lookup Window. Use this window to select all locations (that is, all locations available to you) by clicking on Select All.
This field is active only if you select Warehouse File at the Source field.
At this and any other Location field, the locations you see (that is, the list of locations available to you) may be affected by Regional Processing restrictions.
Specify the source from which to generate data for the report. You have the following options:
Product File - include all product numbers that fall under the selected parameters, along with summarized data encompassing all warehouse/store locations.
Warehouse File - include both the product and individual warehouse/store location details on the report.
Select the type of inventory on which to report. You have the following options:
All Inventory - both retail and service parts products.
Retail Inventory - retail products only
Parts Inventory - service parts products only.
Suppress Zero LinesTo suppress all line items with zero quantities in all fields displaying numerical values (for example, On-Hand, Net Avail, Net on P/O, MTD Units, and YTD Units), check the box at this field. Otherwise, leave the field blank.
Exclude Special Order ProductsTo exclude special order products from the output of this report, check the box. Otherwise, leave the box blank.
Exclude Obsolete ProductsTo exclude obsolete products from the output of this report, check the box. Otherwise, leave the box blank.
This field is available if you selected Warehouse File in the Source field.
To display the available to promise (ATP) quantity on this report, check this box. If the value in the 'Net Avail' column is greater than zero, the ATP quantity and date are calculated and if the ATP date is equal to the current date, the ATP quantity is displayed in the 'Curr ATP' column on this report.
Primary SortSelect Category (C), Brand (B), or Group (G) to indicate the item by which the report data is to be sorted in the Primary (first) sort.
Secondary SortSelect Category (C), Brand (B), or Group (G) to indicate the item by which the report data is to be sorted in the Secondary (second) sort. If no secondary sort is desired, choose None Selected.
Tertiary SortSelect Category (C), Brand (B), or Group (G) to indicate the item by which the report data is to be sorted in the Tertiary (third) sort. If no tertiary sort is desired, choose None Selected.
Send Output toThe output destination of the report displays. To change the output destination, click on the Actions button and select Output Settings.
Export PathIf you select either the Personal Report Viewer (PRV (Personal Report Viewer) A STORIS printer output option that allows you to customize report results, for example to rearrange data columns.), Excel Export, or ASCII Export, this field displays the pre-set computer drive and folder location to which the system exports the report data. You cannot edit the export path using this process.
Once the run-time options have been selected, choose Run to produce the report.