Benefits of the inventory replenishment report

The replenishment report summarizes closing inventory, items sold, and days' cover. This report includes options to add reorder points and amounts, along with other metrics to help you to stay on top of what you need to order and when.

You can use this report to:

• Make sure you always keep your top-selling products in stock and never miss a sale.
• Predict when products might run out.
• Understand customer demand for products with seasonal swings.
• Estimate the cost of an order.

The report is located by navigating to Reports > Inventory reports > Replenishment.

Filtering the report

You can use the available filters to customize your report.

• Report type: Selects the report metric.
  • Product: Only lists products sold during the selected period.
  • SKU name: Lists all products.
  • Brand: Only lists brands with products sold during the selected period.
  • Outlet: Only lists outlets that sold products during the selected period.
  • Supplier: Only lists suppliers with products sold during the selected period.
  • Product category: Only lists categories with products sold during the selected period.
• Date range: Customize the date range the report will cover, as well as choose to focus on Historical or Forecast information.
• Primary measure: Allows you to choose from a variety of metrics. This selection tailors the report to focus on specific aspects of sales performance.
• Comparison period: Enables comparison of the selected date range with a secondary time period for analysis.

Clicking More filters additionally gives you the option to filter the results by All inventory, On-hand inventory, Low inventory, or Out of stock inventory. You can filter the report by brand, channel, customer, or using another keyword. You can also toggle on and off whether the report will show inactive inventory.

Changing historical and forecast measures

You can use the Date range filter to show specific historical data or predictive forecast data.

Filtering by historical measures

1. Select the Date range dropdown.

2. Select the Historical tab.

   

3. Choose All to show all historical data, Specify period to choose a period, or Specify date to choose a date range.
4. Select your dates using the calendar date picker or by entering the date ranges in the From and To fields.
5. Click Apply.
6. Click Search.

Filtering by forecast measures

1. Select the Date range dropdown.

2. Select the Forecast tab.

   

3. Enter a number in the Forecast Period field and select the number of Days, Weeks, or Months from the dropdown.
4. (Optional) If you want to include missed sales, enable the Factor missed sales into the demand forecast checkbox. If you don't enable the checkbox, missed sales won't be included, and the forecast will only include moving average data.
5. Click Apply.
6. Click Search.

Understanding the report columns

The replenishment report presents information about your current product inventory and your sales data, for both historical and forecast measures.

Historical measures columns

• Closing inventory: Your inventory at the end of your selected date range. If that is today, then it equals your current stock on hand.
• Items sold: The total items you sold in your selected date range, minus returns.
• Missed sales: Estimated number of sales missed due to stockouts.
• Estimated sales: Total estimated sales, calculated as the sum of items sold plus missed sales.
• Average cost: The average cost of an item at the end of the reporting period.

Forecast measures columns

• Inbound inventory: Amount of incoming inventory from dispatched purchase orders and sent transfers.
• Forecasted demand: Estimated number of items required to meet demand during the forecast period.
• Suggested order quantity: Calculated by taking forecasted demand amount minus closing inventory and inbound inventory.

Additional columns

In the first column, click the + to add columns with additional information. Check the boxes for relevant filters, then click Apply. You can add Supplier code, Brand, Supplier, Category, and/or Tag columns.

To the right of the displayed columns, click the + to choose a variety of other measures to include. Check the boxes for the columns you want to be included in your report, then click Update report.

Using the replenishment report

Finding out what you have and what’s running low

By default, the report shows your top-selling products first. Click More filters and use the Filter results by dropdown to select On-hand inventory to focus on products you currently have in stock. Change this to Low inventory to focus on products below their reorder point. Changing to Low inventory also shows products with quantities of 1 or less.

If you have Reorder point and Reorder amount measures enabled on your report, the overall totals won't show at the top of the report, as these are product-specific data points.

Ordering based on customer demand

You can find data based on customer demand. For example, you can use the Date range dropdown and tabs to filter by different date periods. Use the Historical tab to see the types of products that were selling well in the past, or use the Forecast tab to predict which products will be in high demand in the coming season.

Filtering based on genuine sales

Select More filters to include or exclude customers, customer groups, or promotions in your report. This allows you to fine-tune your forecast data by factoring in or removing staff purchases or promotional sales and focusing instead on genuine sales.

By refining your forecast data, you can:

• Ensure projections are based on typical customer purchasing behavior.
• Avoid inflated sales as caused by internal transactions or promotions.
• Make more accurate inventory and demand planning decisions.

Planning and managing stock transfers between outlets

If you have multiple outlets, select Format results, choose By outlet, and click Apply to see customer demand and inventory in each store to plan your stock transfers.

The Inbound inventory column shows inventory that has been removed from the sending location but has not been received by the recipient outlet yet. These products aren't included in total inventory counts for either outlet.

Planning supplier orders

You can export the replenishment report and use it to calculate how much inventory you need to cover your next period.

Click Export report and choose XLSX format or CSV format. The report will download to your computer automatically.

Saving the report

You can save the report in Retail POS or export it to save it to your computer.

To save to Retail POS:

1. Click Save report.

   

2. Enter a Report name.

   

3. Click Save report.

The report will be saved as a tab in your Sales report page.

Exporting the report

To export the report:

1. Click Export report.
2. Choose XLSX format or CSV format.

Your report will download to your computer automatically.

What's next?