The Stock Status Report is a snapshot of your inventory at the present time. The report helps you maintain adequate inventory levels by providing information such as cost, quantity on hand, and reorder information. The summary version lists only those items that are currently in stock. The report includes items designated as parts (P), supplies (S) or oils (L). Items are listed by category, including the following information:
With this report, you can see at a glance how much stock you have and whether you will need to reorder shortly. For a listing of all items, including those not in stock, use the detailed version of the report.
| Note: | For the on-order quantity of an item to appear on this report, the reorder information must be entered into the system when the order is created. |
Use the following steps to print a summary Stock Status Report:
| Field | Definition | ||
|---|---|---|---|
| Category | Type a category code or range of codes. If you want to select all item numbers within a given category, make sure your High and Low fields are the same category code. Leave blank for all categories. | ||
| Item Number | Type the item number or range of item numbers if you want one particular item or several consecutive items. Leave blank for all items. | ||
| Prime Vendor | Type a vendor name to select by primary vendor. The primary vendor is the first vendor listed on the Set Up Inventory Items screen for an item. Leave blank for all vendors. | ||
| Print Time on Report | Printing the time helps you identify the most current report when the same report is printed more than once during a day. This field defaults to Y to print the time on the report. If you do not want the time to print on a report, type N. We recommend that you always print the time on a report. | ||
| Summary Only | This field appears for reports with both detailed and summary versions. Enter Y to print the summary report. We recommend printing a summary report under normal conditions. | ||
| Duplex | This field appears for terminals that have report type 2 enabled in the Set Up Printer Controls screen. Duplex mode enables printing on both sides of the paper.
|
||
| Landscape | This field appears for terminals that have report type 2 enabled in the Set Up Printer Controls screen. It prints horizontally on the paper. | ||
| Number of Printed Lines per Page | This value tells the computer how many lines to print on each page of the report. A typical 11-inch page can contain up to 66 lines, but this field defaults to 60 to allow three-line margins at the top and bottom of the page.
|
||
| Total Number of Lines per Page | This field indicates the length of the paper in the printer. A typical 11-inch page contains 66 lines. Your system interprets a 0 or 66 in this field to mean that standard 11-inch paper is loaded in the printer. Because a 66 causes a form feed to take more time, accepting the default, 0, is recommended. | ||
| Print Report To | This field tells the computer where to send the report. The following list contains the different selections available for this field.
|
||
| Command Line Options | The line at the bottom of the screen contains commands to print the report and to save or change the report settings.
|
You can set up this report on the Set Up Closing Processes screen (1-6-3) to print automatically during closing processes.
| Item | Description |
|---|---|
| Item # | Identification number of the inventory item. |
| Loc | Location. This code identifies the location or profit center (such as a lube shop or car wash). |
| Description | Description of the inventory item. |
| Vendor | Vendor ID. |
| Current Cost | Current cost of the item. |
| Extended Cost | Total cost of the stock on hand.
Extended Cost = Quantity On Hand * Current Cost |
| Unit | Unit of measure in which the item is sold and inventoried. |
| Quantity On Hand | Current quantity in stock as of the last inventory update. |
| On Order | Number of items on order, according to the system. |
| Reorder Level | The reorder level set up in your system for this item. The item prints on the Reorder Notices when the quantity on hand drops below this level. |
| Reorder Coverage | Quantity available above the reorder level. This includes the count of items that have been ordered.
Reorder Coverage = Quantity On Hand + On Order – Reorder Level |
| Category | Category of inventory items, followed by a list of the items. |
| Total Cost of Stock On Hand | Total extended cost for all items on the report. |
| Items | Total number of inventory items in all the categories on the report. |
This report is most often used to look at current cost, quantity on hand and coverage levels for reordering purposes. It is recommended that you print this report or the detailed report on a monthly basis. The summary report is useful to focus on the items you currently have in stock. Look for high reorder coverage levels, extended costs and quantities on hand to indicate that you may have more of an item in stock than necessary.
You can use the option on the Report Control Screen to print this report for a specific vendor. You may want to do this each time you place an order with a vendor to see if there are any items you should add to your list. Other reports that give history related to your inventory status include the Inventory Valuation Report, History by Type Report, and Adjustments Report. The Reorder Notices Report and Usage-Based Reorder Report are two other reports used for reordering purposes.
