Overstocked Items Report — Printing

Sage ERP Accpac Inventory Control 6.0

Printing the Overstocked Items Report

The Overstocked Items report lists each item at each location for which the quantity on hand (plus the quantity on PO minus the quantity on sales order) exceeds the maximum or projected sales quantity assigned for the item and location.

You can report item quantities for locations that are over the maximum level or over the projected sales figures entered for the items in the Reorder Quantities form. You can include cost figures on the report to see the costs of carrying the extra inventory items.

Use the Annualized Turn And Earn Ratio version of this report to find out how many times your company's average inventory was sold during the year to date. The report also shows the profit margin, total sales, and total cost for each item in the year to date.

For more information on the contents of this report, see Overstocked Items — Features.

Before printing

Run Day End Processing if you want to include the latest costing information in the report.

To print meaningful data on some versions of this report, you must first enter figures for the items in the Reorder Quantities form.

When to print

Print the Overstocked Items report when you want to estimate the cost of excess stock, or when you want to determine whether to redistribute overstocked items to other locations.

To print the Overstocked Items report

Double-click the Overstocked Items icon in the Stock Control Reports folder.
Make your selections as follows:

Sort by. Specify the order in which to list item records.

From [ ] To [ ]. Specify the range of item numbers, categories, segments, or optional field entries to include in the report.

From Location [ ] to [ ]. Enter a range or use the Finder to select a range of locations.

Print Items with. Select the criterion you want to use to determine whether items are overstocked.

To begin printing, click the Print button.

If you are printing to a printer, Inventory Control displays the Print Destination dialog box to let you confirm your printer selection and change the number of copies to print. Click OK if the settings are correct; otherwise, click Cancel or Setup.

If you are printing to a file, Inventory Control displays the name of the file, so you can change it or cancel printing.

If you are printing to the screen (preview), Inventory Control displays the report. You can then export it to a file or send it to the printer.