keybd

Inventory

Item by Vendor X-Reference List

 

Items by Vendor X-Reference List is a cross reference list for vendors and the items purchased from those vendors.  This is a good report to reference where items are being purchased from when a new vendor is being pursued, or an existing vendor offers the identical item.

 

 

Listing Setup

 

Program ID.  Enter the program ID for the items to list.  If the program ID is not known, enter "?" to display the Active Programs window.  Select the program from the window by entering the sequence number to the left of the program ID.  If all programs are to list, press Spacebar.

 

Fulfillment/Co-op.  Enter the item class of the program items to print on the list, F=Fulfillment or C=Co-op.  If both Fulfillment and Co-op are needed, press Enter.

 

Partial Program Item Number Prefix.  Enter the item number to reference on the list.  If only a partial item number is known, enter the partial.  If all items are to list, press Spacebar.

 

Single Vendor Selection.  The prompt will read Enter Vendor Number, ?=Display, F4=End.  Enter the vendor number of the vendor to list.  If the vendor number is not known, enter "?" to display the Vendors window.  Select the vendor to list by entering the sequence number to the left of the vendor number listed.  If further information is still needed to select a vendor, enter F9 to expand the Vendors window.  This will show contact, city and state to further narrow down the search for the correct vendor.  Enter F9 again to shrink the window.  If all vendors are to list, press Spacebar.

 

Include Discontinued Items.  The prompt will read Include Discontinued Items? (Y/N/O).  If discontinued items are to list, enter "Y".  If discontinued items are to be omitted from the list, enter "N".  If only the discontinued items are to list, enter "O".

 

Item Status Codes.  The prompt will read Enter Item Status Codes (Up to 10), Spacebar=All.  Enter the items status codes to list.  The field will accept up to ten (10) items status codes.  If all item status codes are to list, press Spacebar.

 

Only Items Purchased This Year.  If only the items purchased in the current year are to list, enter "Y".  If all items are to list, enter "N".

 

Print All Quantity Breaks.  The prompt will read Print Existing Quantity Breaks (Y/N).  If the existing quantity breaks are to list, enter "Y".  If no existing quantity breaks are to list, enter "N"

 

Print Imprint Instructions.  The prompt will read Print Existing Imprint Instruction? (Y/N).  If the imprint instructions entered in Inventory Item Maintenance using F7=Imprint Template are to display on the list, enter "Y".  If the imprint instructions are to be omitted, enter "N".

 

Double Space Items Within Vendor.  If the items are to list with a double space in between the items, enter "Y".  If a single spaced list is to print, enter "N".

 

The list will print out with the page divided by the vendors requested.  The list will show:

 

Ven Item and Description.  This is the vendors item number and description.

 

Cost 1.  This is the cost entered under Quant 1 in the Item Component Detail Maintenance window in Inventory Item Maintenance on the IFM menu.

 

Prog Item Number and Description.  This column lists the program ID, the item type, and the inventory number and description.

 

D.  Discontinued.

 

S.  Item Status Code.

 

Quantity Breaks.  The quantity breaks and the costs associated with the breaks are listed under the item the breaks are entered on.

 

Items by Vendor X-Reference List - IFL 3

DPU407

RECORD PULLED AND FILE NAME

AVAILABLE CRITERIA

INFO DISPLAYED (IN SEQUENCE)

SORTS BY

Vendor Master File - UD20

Program ID (Individual or All)

Ven Item# (Vendor Item Number)

Vendor Number then

Program Master File - UD70

Fulfillment/Coop (F-Fulfillment, C-Coop, Enter- All)

Description

Item

Inventory Item Master File - UD71

Partial Program Item Number Prefix

Cost 1

 

Item Component File - UD71D

Partial Vendor Item Number Prefix

Program/Item/Number (Program ID/Fulfillment

 

Item Imprint Template (text) - UD71I

Single Vendor Selection (Individual or All)

or Coop/Catalog Item Number)

 

 

Include Discontinued Items? (Y-Yes, N-No, or O-Only)

Description

 

 

Item Status Code (Up to 10 or All)

D (Discontinued)

 

 

Only Items Purchased This Year? (Y/N)

S (Status Code)

 

 

Print All Quantity Breaks? (Y/N)

Page divisions by Vendor

 

 

Print Imprint Instructions? (Y/N)

Quantity Breaks Listed if Requested

 

 

Double-Space Items Within Vendor? (Y/N)

Imprint Templates Displayed if Requested