Printing Standard Inventory Reports

The Inventory Usage Report gives detailed sales history for each item. This report can also list items that have not sold.

Note: A column called L-Purch prints on this report. This column is reserved for future use.

  1. In the (RR) Inventory Reports screen, select the [U] Usage type code.

  2. Use the Sales field to specify the items to print based on sales information. To include all items, press Tab. To include only those items that have sold this month or in the last three months, type Y. To include only those items that have not sold this month or in the last three months, type N.

  3. Use the Location field to indicate the location to include on the report. To limit the report to one location, enter a location number. To include all locations, press Tab. To include all locations with subtotals for each location, type ØØ.

  4. You can use sorts to establish the order and grouping of any records included in the report. For more information, see About Report Structure.

    To accept the default sorts and page breaks (sorting first by item number and then by company, with no page breaks), press Enter while the cursor is in the Sort 1 field. Go to Step 5.

    To specify sorts for your report, enter the appropriate sort codes in the Sort 1, 2, and 3 fields, respectively. The sort codes appear on the screen to the right of the Break Page fields. You can specify up to three sorts. For a description of the sorts you can use, see Inventory Sorts and Limits.

    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 sort group you specified. For example, if you specify vendor in the Sort 1 field and specify to break page in the Break 1 field, each time the vendor changes, the information for the new vendor begins at the top of a new page. If you choose to break pages, a heading and subtotal print for each sort group. This field can also be used to place a blank line between sorts or to print subtotals for the sort.

    To specify a new page for the sort, subtotals for the sort group, or a blank line between each sort, enter the appropriate code in the corresponding Break Page field from the following list:

 

Code

Description

N

No page break for the particular sort

Y

Each new group within the sort prints on a new page and a heading and subtotal print for each new group

D

Place a blank line between the sorts with no page break

S

Print subtotals for the particular sort with no page break

 If you do not complete all three Sort fields, press Enter.

  1. You can set limits for your report. For a description of the limits you can set, see Inventory Sorts and Limits.

Note: There are no default limits. If you do not specify limits, the report includes information for every item in the database.

To include information for every item, press Enter. Go to Step 6.

There are two types of limit fields. The first includes the fields from Avg Cost Gt Rep through Hits. The second type includes the fields from Desc through Date O/S/U/To fields.

The first type of limit fields lets you print a report with or without certain information. These fields can be used to omit information. To set limits in the first type of limit fields, tab to the appropriate field for each limit to set. To limit to item records in a particular group, type Y. For example, specifying Y in the On Hand field limits the report to items with on-hand quantities.

To limit the report to item records outside a particular group, type N.

To omit items that belong to a particular group, type O.

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.

The second type of limit fields lets you specify a range of items to include on the report. To set limits in the second type of limit fields, tab to the appropriate fields for each limit you want to set. Enter the beginning of the range to include in the first field, and enter the end of the range in the corresponding To field. When limiting to a single value, you can enter the value in the first field, and leave the To field blank. If you enter all of the limits you need before the cursor reaches the Date O/S/U fields, press Enter.

  1. In the Printer field, enter the printer name.

  2. In the Copies field, enter the number of copies to print.

  3. In the Records To Print field, press Tab to include every record that meets the limits you set, or specify the number of records to print. For example, if you enter 50, information for the first 50 items prints. The sorts and limits you set determine which 50 records print.

  4. In the Totals Only field, press Tab. This field does not apply.

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.

See also:

Printing the Inventory Usage Report (Custom)

About Inventory History Reports