Printing Standard Inventory Reports

The Inventory Extended Dollars Report shows you how much money you have invested in inventory. It shows the value of the merchandise you have on hand, as well as how much you can anticipate paying for items that are on order.

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

  2. In the A/D/R/P field, specify the cost or price to use for this report. Select a code from the following:
     

    Code

    Description

    From

    A

    Average landed cost

    Cost $ box in the Item Master tab

    D

    Manufacturer's cost

    Direct Buy and Cost boxes in the Item Master tab

    R

    Wholesaler's replacement cost

    Cost box in the Item Vendor tab

    P

    Selling price

    List $ box in the Item Master tab

  1. In the Location field, press Tab to include all locations on the report. To specify a particular location, enter it. To include all locations with separate subtotals for each location, enter 00 in this field. 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.

  2. Use the Sorts fields to specify the order in which information prints. To sort first by item number and then by company, press Enter while the cursor is in the Sort 1 field. Go to Step 6.

    To specify sorts for your report, enter the appropriate sort codes in the Sort 1, 2, and 3 fields. (The sort codes are to the right of the Break Page fields.) For example, to specify vendor as the first sort, enter V in the Sort 1 field. You can specify up to three sorts. For more information, 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 corresponding sort group. For example, if you specify vendor in the Sort 1 field and specify to break the page in the Break Page 1 field, each time the vendor changes, the information for the new vendor begins at the top of a new page. This field can also be used to leave a blank line between sorts or to print subtotals for the sort.

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


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

 

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 specify fewer than three sorts, press Enter.

  1. The cursor moves to the first limit field, the Avg Cost Gt Rep field. You can limit a report using any combination of limits. To be included in a report, however, an item must meet all the limits you set.

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


To print every item on the report, press Enter until the cursor moves to the Printer field. Go to Step 7.

For details on available limits and how to use them, see Inventory Sorts and Limits.

To limit the report to item records that belong to a particular group, type Y. To limit the report to item records that do not belong to 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.

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.

  1. Use the Printer field to specify where to print the report.

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

  1. Use the Copies field to specify how many copies of the report to print.

  2. Use the Records To Print field to specify the number of records to print. For example, if you enter 50, information for the first 50 items prints. The sorts and limits determine which 50 records print.

  3. Use the Totals Only field to omit detail and print only the following totals for all items on the report:

  4. Inventory value for each department

  5. Backordered dollar value

  6. Inventory value for the entire report

  7. On-order dollar value

  8. On-hand dollar value

  9. Allocated dollar value.

To print totals only, type Y. To print the report with details, press Enter.

  1. The report prints according to the sorts and limits you set.

See also:

About Inventory Reports

Printing the Inventory Extended Dollars Report (Custom)