Chapter 82: Printing Item Stock Status Reports (MISS)

Field	Description
Report	The name of the report. Alphanumeric, 3 positions; optional.
Description	The description of the report. Alphanumeric, 40 positions; optional.
Date	The last date the report was printed or the report selection was updated. Numeric, 6 position (MMDDYY format); optional.
Time	The last time the report was printed or the report selection was updated. Numeric, 6 positions (HHMMSS format); optional.

Screen Option	Procedure
Create a report selection	Press F6 to advance to the Create Report Selection Screen (MISS).
Define and save report selections	Enter 1 next to a report selection to advance to the Item Report Selection Screen (MISS).
Display report selections	Enter 5 next to a report selection to advance to the Display Stock Status Report Options Screen.

Create Report Selection Screen (MISS)

Purpose: Use this screen to define the name and description of the report selection.

How to display this screen: At the Work with Report Selection Screen (MISS), Press F6.

MSR0305 ENTER Create Report Selection 6/20/97 11:20:46

The Mail Order Company

Report . . . .

Description .

F3=Exit F12=Cancel

Field

Description

Report

The name of the report selection which is used for future reference. The selection criteria are saved to the Item Report Selection file with this name the first time the report is run. In the future, you can call up these selection criteria by entering this report name.

Alphanumeric, 10 positions; optional.

Description

The description of the report selection which is used for future reference. If the report selection is saved, the report description is displayed on the selection screen, provided you choose to list all of the previously saved report selections.

Alphanumeric, 30 positions; optional.

Item Report Selection Screen (MISS)

Purpose: Use this screen to define the information that will be included on the report. For example, to produce a report for items in Warehouse 1 that were supplied by vendor's 100 and 200 you would define the warehouse and vendor fields at this screen.

How to display this screen: At the Work with Report Selection Screen (MISS), enter 1 next to a report.

MSR0147 CHANGE Item Report Selection 6/20/97 11:22:27

Item Stock Status The Mail Order Company

Report code : SUMMER

SUMMER ITEMS

Opt Whs Dept Class Vendor Buyer Categ Sts

Type options, press Enter.

4=Delete

F3=Exit F12=Cancel

Field descriptions:

Field	Description
Whs (Warehouse)	A code that represents the warehouse, validated against the Warehouse file. See Warehousing Chapter 41: Creating and Maintaining Warehouses (WWHS). Numeric, 3 positions; optional.
Dept (Department)	A numeric code used to group items into departments for reporting purposes. Validated against the Department file; see Chapter 9: Working with Long SKU Departments (WLSD). Numeric, 4 positions; optional.
Class	A user-defined code that identifies a group of items. Item Class codes are used as a high level method to: • sort inventory • define information templates at the item class level • assign city/state restrictions • assign customer class restrictions • apply a promotion discount See Chapter 5: Working with Item Classes (WICL). Alphanumeric, 3 positions; optional.
Vendor	A user-defined code that represents the primary vendor or supplier of the item. Validated against the Vendor file. See Chapter 19: Working with Vendors (WVEN). Numeric, 7 positions; optional.
Buyer	A user-defined code that represents a person who is authorized to make purchases for this item. Validated against the Buyer file. See Chapter 17: Working with Buyers (WBUY). Alphanumeric, 3 positions; optional.
Cat (Category)	A user-defined code assigned to an item to classify and group like items. Item category is a level below the item class. Validated against the Item Category file. See Chapter 4: Working with Item Category Codes (WITG). Alphanumeric, 4 positions; optional.
Sts (Status)	A code that represents an item's status such as obsolete, discontinued, etc. This information is used for inventory reporting purposes only. See Chapter 7: Working with Item Status (WIST). Alphanumeric, 1 position; optional.

Item Stock Status Save Options Screen

Purpose: Once you have defined the report information, you are ready to save this information and to print the Item Stock Status Report.

How to display this screen: At the Item Report Selection Screen (MISS), Press Enter.

INR0566 ENTER Item Stock Status Save Options 6/20/97 11:27:41

The Mail Order Company

Sort selection . . . . . *Blank

Backorder calculation options:

Include on order . . (Y/N)

FIFO option . . . .

Selection Option . . . . 1. Print Only

2. Save Only

3. Save and Print

Report function . . . . I1

Report code . . . . . : SUMMER

Description . . . . . . SUMMER ITEMS

F3=Exit F12=Cancel

Field	Description
Sort selection	The sort selection field specifies how the report will be sorted. You can use the prompt (F4) to view the list of available values. Valid values: • A1 = Item, warehouse • A2 = Warehouse, item • A3 = Department, item, warehouse • A4 = Department, warehouse, item • A5 = Item class, item, warehouse • A6 = Item class, warehouse, item • A7 = Vendor, warehouse, item • A8 = Vendor, item, warehouse • A9 = Buyer, item, warehouse
	• B1 = Buyer, warehouse, item • B2 = Category, warehouse, item • B3 = Category, item, warehouse • B4 = Status, item, warehouse • B5 = Status, warehouse, item • D4 = Backorder $ (ascending) • D5 = Backorder $ (descending) • D6 = Backorder units (descending) • D7 = Backorder units (ascending) Alphanumeric, 2 positions; required.
Include on order	Y = The on-order (purchase order) quantity should be included in the quantity available calculation on the Item Stock Status Report. N = The on-order quantity should not be included in the quantity available calculation on the Inventory Stock Status Report. Alphanumeric, 1 position; required.
FIFO option	The FIFO option identifies whether the report should include held orders in the backorder calculation. Valid values: B - Both open and held orders O - Open orders only Alphanumeric, 1 position; required.
Selection option	Type the number associated with the option, as follows: 1. Print only = Prints the Item Stock Status Report and does not save your selections. You must select the sort option the next time you run this report. 2. Save only = Saves your selections, but does not print the report. 3. Save and print = Saves your selections and prints the report. Numeric, 1 position; required.
Report function	This value represents the system-assigned function name of the report that is run. As each report is selected and run, the system will update this field with the name of the report. You cannot change this field. Alphanumeric, 1 position; display only.
Report code	The name of the report selection. The selection criteria is saved to the Item Report Selection file with this code. Alphanumeric, 10 positions; required.
Description	The description of the report selection. If the report selection is saved, the report description is displayed on this screen. Alphanumeric, 30 positions; required.

Completing this screen: Based on your selection option, the system prints the Item Stock Status Report and/or saves your selections.

Display Stock Status Report Options Screen

Display a report selection: Enter 5 next to a report at the Work with Report Selection Screen (MISS) to advance to the Display Report Selection screen. You cannot change any information on this screen. See Item Report Selection Screen (MISS) for field descriptions.

Item Sales Analysis Report

Contents

SCVs

Search

Glossary

Reports

XML

Index

Item Stock Status Report

ME12_03 CWDirect 18.0 August 2015 OTN