Inventory On Hand With No Sales Report

Running the Inventory On Hand With No Sales Report

Use the Inventory On Hand With No Sales Report lists to identify inventory on the shelf that is not selling. Typically, branch managers run this report. However, purchasing managers at the branch or regional level can run the report to figure out what stock should be evaluated, sold, and phased out of inventory.

Warehouse managers can also use the report, depending on your company's policies and procedures. At the corporate level, whoever is responsible for the inventory dollars at year end should run the report before reporting to the government how much money is tied up in an inventory investment that is depreciating. Also, if items or boxes of inventory are unopened, determine if the items can be returned to the vendor for refund or exchange.

Note: Depending on the amount of sales information, this report can take a while to run. If unit sales information is not available for two, three, and four years, the system prints a zero (0) in those report columns.

You can also create a return purchase order for the items on the report and return them to your vendor. After running the report, view the report in the report spooler. Use the Process option and select Create Return Purchase Order. The system creates the return purchase order including all items listed on the Inventory On Hand With No Sales Report for you to return to the vendor. Process the return purchase order as usual.

Note: Use this report to gather data regarding dead stock to post to the Trading Partner Connect web site.

To run the Inventory On Hand with No Sales Report:

From the Reports > End of Month Reports menu, select Inventory On Hand With No Sales to display the Inventory On Hand With No Sales Report window.

Complete the remaining fields as indicated.

Field	Description
Branch	Enter the branch or territory to be included in this report. Type All to include all branches and territories.
As of Date	Enter the date on which to begin calculating the aging. You can enter a calendar date or variable date in this field. The default is the current date.
Days Since Last Sale	Enter the minimum number of days since the product last sold for it to be included on the report. The default is 365, which selects products that were last sold over a year ago. If you select Include or Only in the Overstock field, this field changes to 1. You can change the number of days in this field, however, overstock is best run with a low number of days since last sale.
Line Type	Accept the default Prc to run the report for price lines or enter Buy to run the report for buy lines. The option you select in this field determines the variable field name that follows.
Price Line/Buy Line	Do one of the following: Leave the field blank to run the report for all price or buy lines. In the field, enter the line ID to run the report for one price line. Use the Multi button to select more than one buy line or price line for which to run the report. Note: The report runs for products on the primary buy lines only, not the secondary buy lines.
Cost Basis	Enter the global price basis used to calculate the inventory cost values. The default is COGS-COST.
Detail Level	Select one of the following: Branch - Displays the branches that have not had sales. Product - Displays products that have not had sales in any of the selected branches.
Rank Br	Indicate whether rank selection should apply only to the branches for which you are running the report or to all branches. All - Selects ranked items in all branches. Report - Selects only ranked items from the branches for which you are running the report.
Order Types	Select which type of orders to include in the report. The default is Sales. Use the Multi button to select more than one order type.
Product Location Quantity Type	Indicate the type of stock for which to run the report. Select one of the following: S - Stock O - Over Shipment F- Defective R - Review L- Display T- Tagged
Sort By On Hand Quantity	Indicate if you want to sort the report by on-hand quantity. Products with the greatest on-hand quantity are listed first. The default is No, which sorts by product by branch.
Contact Info for Recent Sales	Enter the number of recent sales detail lines you want to include for each product for the customers who most recently purchased the products on the report. The detail lines on the report show the customer, contact name, phone number, last sale quantity, last sale price, outside salesperson, and date. A sales representative can use this information to move dead stock to a more appropriate location. Note: It takes a long time to build the report when you use this option. We recommend that you not run the report for all buy lines at once.

In the Nonstocks field, indicate whether to include, exclude or print the report only for nonstock products. The default is Include.

Note: If you select exclude, the system displays only stock items. All other statuses are excluded.

In the Transfers field, indicate whether to include, exclude, or print the report only for transfer receipts. The default is Include.

In the Overstock field, indicate whether to include, exclude, or print the report for only products considered overstock.

If you use the Vendor Scorecard and have built a Vendor Scorecard file, the system uses the same overstock days as in that file to determine which products are considered overstock. If you have not run a Vendor Scorecard build, the default overstock days is 90.

Important: To use this report for insight into the overstock inventory metric in the Vendor Scorecard, select to run the report for only products considered overstock. The overstock quantity takes into consideration products that have future committed sales. For example, if you have 10 of a product to return, but 4 are on an open sales order that will ship on a future date, only 6 of the product are shown as overstock.

In the Exclude Items area, indicate number of days to exclude from the report products created or received within the last designated number of days. The default is 180.

In the Price Line Break area, indicate whether you want the report to insert a blank line after each price line. If you want to have each price line on a separate page. Select Page. The default is No.

In the Rank Selection area, enter one product rank or multiple product ranks separated by commas, such as A, C, D, that you want to include on the report.

In the Must Match Any/All Rankings field, specify which products with the designated ranks to select for the report.

All - Selects products that have not sold in any branches.

Any - Selects products that have not sold in any one of the branches.