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.
See also
- Transfer stock between warehouses
- Create, view, and edit requests to transfer stock between warehouses
- Receive stock into your warehouse from a transfer
- Link a sales order to a warehouse transfer
- Configure warehouse transfer lead times
- View a product's open stock transfers
- Transfer warehouse overstock