Report Stock Status

(Stock Status Report)

Access

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 Inventory item that can be sold on orders; "regular" inventory that is not designated As-Is. Can also represent 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. Once the run-time options have been selected, choose Run to produce the report.

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.

The run-time options for this report are:

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.

 Region

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 blue button with a white ellipsis, Action buttons appear next to fields.. 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.

Source

Inventory Type

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.

Calculate ATP

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.