> For the complete documentation index, see [llms.txt](https://support.ordereazi.com/central/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://support.ordereazi.com/central/order-management/reports/stock-reorder-report.md).

# Stock Reorder Report

See which products will run short, how many to order, and create a project to order them.

Running out of a fast seller loses you sales, and over-ordering ties up cash. The **Stock Reorder Report** in OrderEazi works out how long each product's stock will last at the rate you're selling. It flags what to reorder and how many, and you can turn that into a project to order the stock.

### Before you start

You'll need:

* **Stock Reorder:** In the **Reports** permission group, to run the report.
* **Stock Reorder - Create Project:** To create a project from the report.
* **Export (All Reports):** To export it.

If you don't have them, ask your OrderEazi administrator to add them to your role. The report uses your stock levels: warehouse stock on an Enterprise licence, or Simple Inventory Management on the others. You only see the warehouses you have access to.

### How to run the report

1. In the main menu, go to **Reports** > **Stock Reorder**.
2. Choose the **View Mode**: **SKU Summary** for a row per product, or **Project Detail** for a row per project that needs stock.
3. On Enterprise, choose a **Warehouse**. You can also choose a **Supplier**.
4. Choose the **Lookback Period**, the sales history to work from. It starts on 90 days.
5. Choose the **Lead Time (Days)** and **Safety Stock (Days)**. They start on 21 and 14.
6. Tick **Below zero projected net stock only** to see only products that will run out.
7. Select **Generate Report**.

### What the report shows

In **SKU Summary**, each product has a **Status**:

* **Reorder Now** (red): Your stock won't last the supplier's lead time.
* **Order Soon** (amber): It won't last twice the lead time.
* **OK** (green): You have enough for now.
* **No Velocity** (grey): The product hasn't sold in the lookback period.

The figures behind the status are:

* **Current Available:** Your stock less what's already reserved.
* **Committed SO:** What's on open Sales Orders.
* **On PO Incoming:** What's on Purchase Orders and hasn't been received yet.
* **Projected Net Stock:** **Current Available**, plus **On PO Incoming**, less **Committed SO**.
* **Avg Daily Sales:** The quantity on Sales Orders in the lookback period, per day.
* **Days of Cover:** How many days the **Projected Net Stock** will last at that rate.
* **Recommended Order Qty:** Enough to cover the lead time and the safety stock, less the **Projected Net Stock**.

The lead time is the product's default supplier's lead time. Once you've received stock from them, OrderEazi works it out from your last 5 deliveries. If it isn't set, the **Lead Time (Days)** you chose is used.

**Example:** Notebooks sell 10 a day. You have 120 available, 50 on a Purchase Order, and 70 committed to Sales Orders, so the **Projected Net Stock** is 100. That's 10 **Days of Cover**. The supplier's lead time is 21 days, so the status is **Reorder Now**. With 14 days of safety stock, you need 350 for 35 days. Less the 100 you'll have, the **Recommended Order Qty** is 250.

Select **Movements** on a row to see the product's stock movements. The **Projection** link opens the product in the [Stock Projection Report](/central/order-management/reports/stock-projection-report.md).

### How to order the stock

Tick the products to order, and select **Create Project**. See [Create Replenishment Project](/central/order-management/reports/stock-reorder-report/create-replenishment-project.md).

### How to export

Select **Export**. The Excel file always has three sheets, whichever view is open: the product summary, a summary by warehouse, and the project detail.

### Related pages

* [Create Replenishment Project](/central/order-management/reports/stock-reorder-report/create-replenishment-project.md): order the stock
* [Stock Projection Report](/central/order-management/reports/stock-projection-report.md): forecast a product's stock
* [Simple Inventory Management](/central/order-management/products/inventory/simple-inventory-management.md): your stock levels