Menu

Report warehouse overstock

January 06, 2020 20:17

Updated

Report warehouse overstock

You can report on your warehouse quantities from the Warehouse Overstock screen. You can review products with excess stock along with a quick inventory snapshot to see what items are available in each of your warehouses. You can then generate a report and make decisions about how to manage overstock, whether that be a stock transfer of a overstock sale.

Go to Inventory > Warehouse Overstock.

On the Selection Criteria pop-up, click OK to include all products.

On the Warehouse Overstock screen that appears, select the warehouse and the number of weeks of stock .

In the From Warehouse box, type or select the warehouse on which you want to report.

In the Weeks of Stock, type the number of projected weeks of overstock to view.

Click Go.

The left pane lists the products in the From Warehouse along with details about their current overstock levels.

To create a report, right-click the Warehouse Overstock grid, point to Export To, and then choose Excel. Follow the directions on your screen to save the report.