Item Sales Report (ICR720)

Using Reports

Use this program to obtain an Item Sales Report based on the accumulated sales history stored for each item in the item file.

Report information includes:

warehouse	sales dollars
item number	cost
description	GM $ (MTD, YTD and prior year)
date of last sale	GM % (MTD, YTD and prior year)
number of units	report totals
stocking unit of measure	total number of items listed

To access this program, choose Inventory Control-->Reports & Prints -->Item Sales Report.

Use the following fields to print an Item Sales Report:

1. Order

Enter whether to print in Item, Alpha, Vendor, or Item Class order. Press Enter (CR) to default to Item.

2. Beginning [Order Choice]

Press Enter (CR) or $image\ex_allft_shg.gif$ to default to the FIRST record on file, or you can enter specific information to narrow the focus of your report.

3. Ending [Order Choice]

Press $image\ex_allrt_shg.gif$ to default to the LAST record on file, or you can enter specific information to narrow the focus of your report.

4. Item Type

Enter the item type to print: Stocked items or Nonstocked items. Press Enter (CR) to default to SN.

5. Vendor/Item Class

Enter the vendor or item class to print. Press F1 or $image\all_shg.gif$ to default to ALL.

6. Item Description

Enter whether to print item description 1, 2, or Both from Item F/M. Press Enter (CR) to default to 1.

7. Warehouse

Enter up to 20 two-character warehouse codes side by side to print. Press Enter (CR) to default to the warehouse assigned to the terminal. Press F3 or $image\all_shg.gif$ to default to ALL.

8. Print By

Enter whether to print by Warehouse or Item. Press Enter (CR) to default to W.

9. Total Only

If W was entered in field #7 this field is skipped. Indicate whether to print totals of items only.

10. Time Period

Enter Month-to-date, Year-to-date and/or Prior year as figures to print. Press F1 or $image\all_shg.gif$ to default to ALL.

11. Figures

Enter Sale, Units, Cost, Gross margin, and/or Gross margin percent(%) as figures to print. Press F1 or $image\all_shg.gif$ to default to ALL.

12. Cutoff

Enter whether there is No cutoff or items Above or Below a cutoff should be excluded. The cutoff is based on the first letter selected in the Figures field #11. For example, if SCP were the figures entered then the cutoff could be based on an amount above or below a Sales figure. It is important that the user is aware that if no cutoff is selected, the report will include all sales figures for the selection being printed. For example, if items are being printed and no cutoff is set, all zero sales items (i.e., those never sold) print on the report. Press Enter (CR) to default to N and skips to field #13.

13. Amount

If N was entered in field #12 this field is skipped. The basis of the cutoff is the first figure entered above and the type of cutoff that has been determined. The user now enters the cutoff amount. For example, if the figures chosen were SCP and the cutoff was set to Below and the amount was $500, then items with sales figures below $500 (for the time period chosen) do not print.

Item Sales Report (ICR720)

Using Reports

Report information includes:

Use the following fields to print an Item Sales Report:

See Also

Using Reports