Inventory Component by Item Listing |
The Components by Item Listing report enables you to list all component items and the primary items they relate to. It includes the program, discontinued flag, item status code, on hand, on order, and allocated quantities. It also compares (at the component level) YTD quantity sold and sales volume to LY quantity sold and sales figures.
Listing Setup
Program ID. Enter the program ID for the components to list. If the program ID is not known, enter "?" to display the Active Programs window. Select the program to list by entering the sequence number to the left of the program ID.
Starting Component #. The prompt will read Enter Starting Component #, Spacebar=Beginning, F4=End. Enter the starting component to list. If all components are to list, enter Spacebar.
Ending Component #. Enter the ending component to list. If all components are to list, enter Spacebar .
Include Discontinued. If discontinued items that are being used as components are to be listed, enter "Y". If discontinued items used as components are not to be listed, enter "N". At this point the system will ask if the selections are correct. If correct, enter "Y". If not, enter "N" and reenter the setups.
The listing provided will show:
Component and Description.
Item and Description. This is the item that is using the component.
Prog. The program the item using the description is under.
DF. Discontinued (Y/N)
SC. Status code.
On Hand quantities .
On Order and Allocated quantities.
YTD Qty. YTD purchases.
YTD Sales.
LYR Qty and Sales. Last year's purchases and sales.
Components by Item Listing - IFL 2 DPU490 |
|||
RECORD PULLED AND FILE NAME |
AVAILABLE CRITERIA |
INFO DISPLAYED (IN SEQUENCE) |
SORTS BY |
Program Master File - UD70 |
Starting-Ending Component Number (Individual, Range, or |
Comp/Item (Lists component then indented |
Component Number |
Inventory Item Master File - UD71 |
All) |
with the items that use the component) |
|
Item Sales by Month/Year - UD72 |
Include Discontinued? (Y/N) |
Description |
|
System Control - SD00 |
|
Prog (Program) |
|
Item Component File - UD71D |
|
DF (Discontinued Y/N) |
|
Temporary Sort File - tD00 |
|
SC (Item Status Code) |
|
|
|
On Hand |
|
|
|
On Order |
|
|
|
Allocated |
|
|
|
YTD Qty |
|
|
|
YTD Sales |
|
|
|
LYR Qty |
|
|
|
LYR Sales |
|