Navigation:  REPORTS > Inventory by Location Report >

2.Make Selections

Previous pageReturn to chapter overviewNext page

 

Use options 1 through C to select the items to print on the report and the report format, then choose Start Report to run the report. If you do not specifically want to choose a specific criterion (e.g. For Vendors) you shouldn’t choose that option. If you want to report ALL items, just choose Start Report.

 

For Vendors*} Use this option to restrict the selection to items from one vendor only, or a series of vendors. To choose items from just one vendor, enter the vendor code as both the starting and ending vendor code. If nothing is entered, ALL vendors will be reported.

 

For Brands*} Use this option to restrict the selection to items from one manufacturer only, or a series of manufacturers. To choose items from just one manufacturer, enter the manufacturer code as both the starting and ending manufacturer code. If nothing is entered, ALL manufacturers will be reported.

 

For Major Class Codes *} Use this option to restrict the selection to items from one major class code only, or a range of major class codes. To choose items from just one major class code, enter the major class code as both the starting and ending major class code. If nothing is entered, ALL major class codes will be reported.

 

For Minor Class Codes *} Use this option to restrict the selection to items from one minor class code only, or a range of minor class codes. To choose items from just one minor class code, enter the minor class code as both the starting and ending minor class code. If nothing is entered, ALL minor class codes will be reported.

 

For Dates Received *} Use this option to restrict the selection to items from one date received only, or a range of dates received. To choose items from just one date, enter the date as both the starting and ending date. If nothing is entered, ALL dates received will be reported.

 

For Prices *} Use this option to restrict the selection to items from one price only, or a range of prices. To choose items from just one price, enter the price as both the starting and ending price. If nothing is entered, ALL prices will be reported.

 

For Invoice Number*} Use this option to restrict the selection to items from a specific invoice on which you received merchandise from a supplier. If nothing is entered, ALL invoices will be reported. If more than one of your suppliers sometimes use the same invoice numbers, you should also specify that vendor code in the vendor code option above.

 

Sort By Sku no., Brand, or Vendor *} The report can be printed in order of SKU number, brand, or vendor. Press <Enter> on this option to select the sort option that you want.

 

Display, Print, Wide, Compressed*} The report can be displayed on the screen or printed on the printer. If the report will be printed, you can print on regular size paper or, if you have one, you could print on a wide-carriage printer that has room to print more detail. The wide report can also print the same detailed report on a standard-size printer by using small (compressed) characters. To change this selection, highlight the option and press <Enter>.

 

Regular, Class Code, Style or Reorder Report*} The Regular report shows each stock number in the inventory file, the Class Code report shows a summary of your inventory report with a subtotal for each major class code. The Style report summarizes both sales totals and inventory totals for each style number (it is possible to have several different SKU numbers for each style number, but this report summarizes each style number into one line). The Reorder report is similar to the Style report except that it also shows reorder levels for those items for which you have specified reorder levels. (For more details on reorder levels, see Adjust, Transfer & Edit Inventory from the Inventory Menu.)

 

If you choose the reorder report you will be asked the following question when you start the report:

 

 

Do you only want to see items below the Low or High reorder qty’s or All?

 

 

If you choose the Low quantity, only those items whose stock level has fallen below the low reorder quantity will show up. If you choose the High quantity, only those items whose stock level has fallen below the high reorder quantity will show up. Of course, if the level has fallen below the high quantity, then the level will also have fallen below the low quantity too. (see Adjust, Transfer & Edit Inventory from the Inventory Menu, page  for examples.). Note that the reorder report must be printed on paper, not displayed on screen.

 

 

               Do you need to sort the files? Yes No  <Esc>=Quit

 

 

Include Zero Quantity Inventory *} To include in the report only items where the quantity is not zero, choose Exclude. To include only items with a quantity of zero, select Only. To include items regardless of quantity, select All.

 

Include Layaway Items*} To include in the report only items that are NOT on layaway (i.e. to only show items that are available for sale) select Exclude. To include only those items that have been put on layaway, select Only. To include all items regardless of whether or not they are on layaway select All.

 

Physical Inventory Exception Report*} The physical inventory exception report option allows you to type in all the inventory numbers physically in stock. Then the program will print a report showing you just those items for which the program’s estimate of the inventory level differ from the quantities you typed in. See the Physical Inventory Exception Report chapter further on in this section, page  for more details.

 

Start Report*} Choose this option to start the report according to your selections. The report will display on-screen or on paper depending on your selection above.

 

When the report has finished, the report screen will re-appear. Return to step 1 to print another report, or press <0> to return to the previous menu.