Purpose

The Replenishment Based on Sales module is used to generate stock replenishment suggestions based on sales performance within a specified date range. This ensures fast-moving items are restocked appropriately according to store demand and warehouse availability.

Prerequisites

• Access to Replenishment Module > Replenishment Based on Sales.

Steps

Step 1 – Create a Replenishment Document

1. Go to Replenishment Module > Replenishment Based on Sales.

2. Click Add.

3. In the top panel:

   • Select From Date and To Date (sales period).

   • Input values in Sales Unit From and To (filter by sales range).

   • Select Warehouse using the 3-dotted button.

   • Choose Store or Store Group using the 3-dotted button.

Step 2 – Load Data

1. At the top panel, click Load.

2. The system will generate a replenishment list including:

   • Product

   • Store Name

   • Store Sold Quantities

   • Store On Hand Stocks

   • Store To-Replenish Quantity

   • Warehouse Stock

   • Daily Sales Quantity

Step 3 – Review & Amend Quantities

1. Review the auto-generated replenishment quantities.

2. Amend values in the Replenish column as required.

Step 4 – Finalize Document

1. Click Save to keep as draft.

2. Once verified, click Confirm to finalize.

   • A Store Delivery Request document will be generated in the Store Delivery Request module.

   • Picking jobs will also be generated for warehouse users to prepare and ship items to the store.

3. If the document is no longer valid, click Cancel.

4. (Optional) Click Export to download the replenishment list in Excel.

Notes / Tips

• This module only generates data for products with sales history within the selected date range.

• Use Sales Unit From/To filters to exclude very low or excessively high sellers.

• Quantities in the Replenish column can always be manually adjusted before confirming.

• Use Export for further analysis or reporting outside the system.