Item Master Listing report is an item master file listing by program.  Item Master Listing can be utilized to evaluate the activity of a company's inventory.  It lists all the pertinent information from the item setup file, including average cost, price and cost quantity breaks, component costs, and catalog price.  Also included are imprint templates and item note pads.  Each item is separately printed on a page with the various instructions that may accompany the item on an order.  The current on hand, on order, and allocated quantities, billable quantity on hand (BQOH), and reorder points are reported.

Listing Setup

Program Type. The prompt will read Enter Program Type, C=Co-op, F=Fulfillment, F4=End.  If the program is a co-op program, enter "C".  If the program is a fulfillment program, enter "F".

Program Name. The prompt will read Enter Program Name, ?=Display.  Enter the program ID of the program 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 name.

Item Range. The prompt will read Enter Starting Item, ?=Display, Enter=All.  Enter the starting item number to list.  The list can be for all items, a range of items, or for one item only.  After the starting item number is entered, the system will prompt for the ending item number.  To display a list of the items in the program, enter "?" to display the Items window.  From the Items window, select a starting item number by entering the sequence number to the left of the item number.  Repeat this process for the ending item number.    To list all items, press Enter for the starting and the ending item number.

Sales Info Only. If a summary list showing each item's sales information is needed, enter "Y".  This entry will only print a summary list.  If a master list of all setups and parameters are needed, enter "N".  This option enables the printing of a detail or summary list.

Detail/Summary. If the Sales Info Only field is answered "Y", only the summary list can be printed.  If answered "N", either may be printed.

The detail list that prints will display most of the setups and parameters entered in Inventory Item Maintenance or Co-op/Drop Ship Item Maintenance.  If the item notepad or the item imprint template has entries, these will also print on the listing.  Only the first six (6) cost and price quantity breaks will print on the listing.

The summary list that prints will show a simple listing of the item number and description.  If Sales Info Only is answered "Y", the summary listing will print the item number and description, YTD quantity purchased and sold, YTD cost and sales, and last year's sales for each item.  This report has been modified to add item type and the component multiplier.