Printing Item Sales Analysis Reports (MISA)
Purpose: Use the Item Sales Analysis Reports to review inventory, cost, sales, and returns information for each item included on the report.
This menu option differs from many other report options in that you can define report selection criteria and sort options, and save your selections to run as needed.
In this chapter:
• Work with Report Selection Screen (MISA)
• Create Report Selection Screen
• Item Report Selection Screen (Defining Selection Criteria/MISA)
• Item Sales Analysis Save Options Screen (Additional Report Selections)
• Display Sales Analysis Report Options Screen
Work with Report Selection Screen (MISA)
How to display this screen: Enter MISA in the Fast path field at the top of any menu or select Print Item Sales Analysis Report from a menu.
Field |
Description |
User |
The user ID of the person who created the report option. Alphanumeric, 10 positions; optional. |
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 positions (in user date 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 |
Select Create to advance to the Create Report Selection Screen. |
Define and save or print a report selection |
Select a report selection to advance to the Item Report Selection Screen (Defining Selection Criteria/MISA). |
Display a report selection |
Select Display for a report to advance to the Display Sales Analysis Report Options Screen. |
Create Report Selection Screen
Purpose: Use this screen to create the header information for a new version of the Item Sales Analysis Report.
How to display this screen: At the Work with Report Selection Screen (MISA), Select Create.
Field |
Description |
Report |
The name of the report selection. Alphanumeric, 10 positions; optional. |
Description |
The description of the report selection. Alphanumeric, 30 positions; optional. |
Completing this screen: See Item Report Selection Screen (Defining Selection Criteria/MISA) for information on how to continue creating a new report selection.
Item Report Selection Screen (Defining Selection Criteria/MISA)
Purpose: Use this screen to define how to select items for inclusion on the report. For example, to produce a report for items in Warehouse 1 that were supplied by vendors 100 and 200, you complete the warehouse and vendor fields at this screen.
How to display this screen: At the Work with Report Selection Screen (MISA), select a report.
Field descriptions:
Note: When selecting items to include on the report, the system checks the item's primary assignment in the Item or SKU table. You can check an item's assignment through the Enter/Maintain Items menu option; see Performing Initial Item Entry (MITM). For example, if you specify warehouse 1 as a selection criterion, the system includes only items whose primary warehouse assignment is to this warehouse.
Field |
Description |
Whs (Warehouse) |
A code that represents the warehouse. Validated against the Warehouse table. See Creating and Maintaining Warehouses (WWHS). Numeric, 3 positions; optional. |
Dept (Department) |
A numeric code assigned to items to group them into departments for reporting purposes. Validated against the Department table; see Working with Long SKU Departments (WLSD). Numeric, 4 positions; optional. |
Class |
A code assigned to a group of items to: • sort inventory • define information templates at the item class level • assign city/state restrictions • assign customer class restrictions See Working with Item Classes (WICL). Alphanumeric, 3 positions; optional. |
Vendor |
A code that represents the supplier of an item. Validated against the Vendor table; see Working with Vendors (WVEN). Numeric, 7 positions; optional. |
Buyer |
A code that represents a person who is authorized to make purchases for this item. Validated against the Buyer table; see Working with Buyers (WBUY). Alphanumeric, 3 positions; optional. |
Cat (Category) |
A code assigned to an item to classify and group like items. Item categories are used in the Item Relationship function. Validated against the Item Category table; see 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 Working with Item Status (WIST). Alphanumeric, 1 position; optional. |
Completing this screen: When you complete this screen, you advance to the Item Sales Analysis Save Options Screen (Additional Report Selections).
Item Sales Analysis Save Options Screen (Additional Report Selections)
Purpose: Use this screen to:
• select the sort order of the Item Sales Analysis Report
• select the accounting periods to include on the report
• indicate whether to print, save, or print and save the report
• optionally, enter a different description
How to display this screen: At the Item Report Selection Screen (Defining Selection Criteria/MISA), select OK.
Field |
Description |
Sort selection |
The sort selection field specifies how the report will be sorted. Valid values: • By Warehouse $ Sold Ascending • Warehouse $ Sold Descending • By Department $ Sold Descending • By Department $ Sold Ascending • By Item Class $ Sold Ascending • By Item class $ Sold Descending • By Vendor $ Sold Ascending • By Vendor $ Sold Descending • By Buyer $ Sold Descending • By Buyer $ Sold Ascending • By Category $ Sold Ascending • By Category $ Sold Descending • By Status $ Sold Descending |
|
• By Status $ Sold Ascending • By Item $ Sold Ascending • By Item $ Sold Descending • By $ Sold Ascending • By $ Sold Descending • By Units Sold Ascending • By Units Sold Descending Required. |
Starting period |
The starting month and year used in report selection. Enter the starting date to include. Numeric, 2 positions; required. |
Ending period |
The ending month and year used in the report selection. Enter the ending date to include. Numeric, 2 positions; required. |
Selection option |
Enter the number associated with the options, as follows: • 1 = Print the Item Sales Analysis Report; do not save the selection information • 2 = Save the selection information; do not print the report • 3 = Print the report and save the selection information Alphanumeric, 1 position; required. |
Report code |
The name of the report selection. Alphanumeric, 10 positions; display-only. |
Description |
The description of the report selection. Alphanumeric, 30 positions; required. |
Completing this screen: Based on your selection option, the system prints the Item Sales Analysis Report and/or saves your selections.
Display Sales Analysis Report Options Screen
To display: Select Display for a report at the Work with Report Selection Screen (MISA) to advance to the Display Report Selection screen. This screen displays the selection criteria and sort selection for the report. You cannot change any information on this screen.
