Printing Inventory
Reports
Printing Low-Stock and Overstock Reports (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) screen, select the
[L] Low-Stock type action code.
Press Enter in the L/O field to
print the Low-Stock report, or type O
to print the Overstock Report.
Enter the number of weeks in a
cycle In the Weeks field.
In the Sales field:
Press Tab to include all
items.
Type Y
to include only items sold this month or in the last three months.
Type N to include only those
items that have not sold this month or in the last three months.
In the A/D/R/P field, specify
the cost or price to use for this report. Select a code from the following:
Press Enter at the Keep Low Stock
File for P/Os prompt to delete the suggested order quantities in a
low-stock file. Go to Step 8.
Type Y to save suggested order
quantities in a low-stock file. Low-stock files are automatically
deleted after all items are placed on purchase orders.
Enter a name for the file at the
File Name prompt. You cannot have more than one low-stock file with
the same name.
In the Location field:
Press Tab to include all
locations.
Enter a location to limit
the report to just that location.
Type 00
to include all locations with a separate total for each
location.
Note: To print
a Low-Stock Report using calculations based on the Min and Max boxes,
enter a specific location or location 00.
However, in the LOW-STOCK file, all information is saved under location
1.
Use the Sorts fields to specify
the order in which information prints. Press Enter to sort the report
by item number and company, and go to Step
11. Otherwise, enter the appropriate sort codes in the Sort
1, 2, and 3 fields.
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
Next, set limits. You can limit
a report using any combination of limits.
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
group.
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.
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 these reports. 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.
See also:
About the Overstock
Report
About
the Low-Stock Wholesaler Report — Cycle
About
the Low-Stock Wholesaler Report — Min/Max
Building the United Direct P/O
Printing
Low-Stock Reports (Custom)
In the (LE1)
Screen