Printing the Contract Report (Standard)

From the Master Menu, double-click . The Reports Menu opens.
From the Reports Menu, double-click . The text-based (RR) Inventory Reports screen opens.
In the (RR) Inventory Reports screen, select the [C] Catalog type action code.
Use the Right Hand Columns fields to add information to the report. You can add up to three columns to the right of the standard information on the report. The additional information you specify prints for each item on the report. To add no additional information, press Enter and go to Step 5. To add information to the report, enter codes from the following list:

Code	Additional Printed Info for Each Item	From
A	Average landed cost
R	Replacement cost	List $ box in the Item Vendor tab
P	List price	List $ box in the Item Master tab
1-5	Corresponding quantity break price	Qty box in the Item Master tab
%	Gross profit percentage	Gross % box in the Item Master tab
D	Maximum standard customer discount	Max Discount % box in the Item Settings tab
S	Assortment code	Assortment box in the Item Master tab
B	Primary bin location	P Bin box in the Item History Inventory tab. When you use this code, you must specify a bin location in Step 3
H	Number of times an item is placed on an order	YTD Hits box in the Item History History tab
W	Weight of the item	Weight box in the Item Settings tab
O	Total quantity of the item on Curren P/Os	On Order box in the Item History Inventory tab
M	Minimum and maximum stock levels	Min and Max boxes in the Item History Inventory tab
J	Item quantity currently in stock	On Hand box in the Item History Inventory tab
K	Backorder quantity	Backorder box in the Item History Inventory tab
L	Quantity assigned to customers' orders

Note: If you select the (%) Gross% option, two columns print on the Contract Report: the G/P% column and the Con% column. The G/P% column is the current gross profit based on the current cost in the Item Master tab. The Con% column shows the original gross profit percentage at the time the contract was created. If you set the costs for items on contracts, you can also choose one other option when printing a contract report. This option (C=Contract Cost) is not displayed on the screen. To print the costs manually entered when the contract was created, specify C in the Right Hand Columns field.

Use the Location field to limit the report by location. Press Tab to include all locations, or enter one location to limit the report to a specific location. Enter 00 in this field to include all locations with separate subtotals for each. This feature works only if you include one or more of the following in right-hand columns: on-order, on-hand, backordered, or allocated quantities.
Use the Sorts fields to specify the order in which information prints. Press Enter to sort first by item number and then by company and go to Step 8. Otherwise, enter the appropriate sort codes in the Sort 1, 2, and 3 fields. You can enter up to three sorts.
For the first two sorts you select, the cursor moves to the corresponding Break Page field. This field lets you begin a new page each time there is a change in the corresponding sort group. Enter the appropriate code from the following list in the corresponding Break Page field:
- N: No Page Break
- Y: Each New Group Prints on a New Page
- D: Blank Line Between Sorts With No Page Break
- S: Print Subtotals With No Page Break

Note: If you choose to break the page, a heading and subtotal print for each sort group.

Next, set limits. You can limit a report using any combination of limits, however, you must limit contract reports to a range of contracts. There are no default limits for this report. If you do not specify limits, the report includes information for every item in the database.
- Press Enter to skip setting limits, and go to Step 9. There are no default limits for this report. If you do not specify limits, the report includes information for every item in the database.
- Type Y to limit the report to item records that belong to a particular group.
- Type N to limit the report to item records that do not belong to a particular gruop.
- Type O to omit items that not belong to a particular group.
- Enter the beginning of the range in the first field and the end of the range in the To field to limit by a range of items in a particular group.

Note: These limits are often used in combination. For example, to limit a report to items that do not have on-hand quantities, but omit those items that are on-order, specify N in the On Hand field and O in the On Order field. To limit by a range of items, enter the beginning of the range in the first field, and enter the end of the range in the To field.

At the Requesting Items In Contract Not on File prompt, type Y to limit the report to items that are on a contract but that have been deleted from your inventory database, and go to Step 11. Type N to not limit to deleted items on a contract. At the Enter Customer For
If you typed N in Step 9, the Enter Customer From prompt appears. Enter the account number of the customer for whom you are printing the report and press Enter.
Enter the printer with which to print in the Printer field.

Note: You must use wide paper or set your printer for compressed print (17 characters per inch) to print this report. To set your printer for compressed print, change the print setting manually. Refer to your printer manual for instructions.

Enter the number of copies to print in the Copies field.
Enter the number of records to print in the Records To Print field. For example, if you enter 50, information for the first 50 items prints. The sorts and limits determine which 50 records print.
Press Tab in the Totals Only field. The report prints according to the sorts and limits you set.

Return to:

Contract Reports