Introduction
In Xilnex, the Replenishment Module is designed to streamline and automate the stock allocation process across outlets, ensuring optimal distribution and improved operational efficiency.
Key capabilities include:
- Location Ranking for Replenishment
The system evaluates and prioritizes outlets based on predefined ranking criteria, ensuring that outlets with higher urgency or importance are replenished first.
- System-Generated Suggested Order Quantity (SOQ)
Once ranking is established, the system generates an SOQ for each outlet, providing a clear guideline for quantity needed.
- Fulfilled Quantity Assignment
The system compares the SOQ with each outlet’s current stock levels and assigns the appropriate fulfilled quantity to balance demand with available inventory.
- Stock Request Generation
After reviewing the SOQ and fulfilled quantities, users can finalize the replenishment plan by pressing Confirm, which automatically generates a stock request from the current location to the respective outlets.
This structured process reduces manual effort, minimizes stock discrepancies, and ensures that outlets receive timely replenishments according to priority and demand.
Module details
Module location
In order to start the Replenishment process, go to Inventory > Replenishnemt.
Before start proceed replenishment process, users need to create Model Stock Profile from System Configuration > Item > All Outlets > Model Stock.
The Model Stock Profile serves as the baseline reference for replenishment planning. It defines the ideal or target stock levels that each outlet should maintain for every product, ensuring availability without overstocking. This profile is crucial in guiding the system when calculating Suggested Order Quantities (SOQ) and assigning Fulfilled Quantities.
Key Roles of Model Stock Profile:
Defines Target Inventory Levels
- Specifies the optimum quantity of each item an outlet should carry.
- Acts as a benchmark to determine whether an outlet is understocked or overstocked.
Drives Replenishment Calculation
- The system uses the difference between the Model Stock Profile and the outlet’s current stock on hand to calculate the SOQ.
- Example: If the model stock for Item A is 50 units and Outlet X currently has 20 units, the SOQ generated would be 30 units.
Supports Location Ranking & Allocation
- When multiple outlets require replenishment, the system aligns outlet needs against their model stock profiles.
- Ensures fair allocation, especially when current stock at the supplying location is limited.
Ensures Consistency Across Outlets
- Outlets of similar type, size, or sales potential can share standardized stock profiles, ensuring alignment with demand patterns.
- Helps maintain consistent customer experience across all locations.
Adaptability to Business Needs
- Model stock profiles can be tailored by product, category, outlet type, or seasonality.
- This allows replenishment planning to be both dynamic and demand-driven.
Create new Model Stock
First, start with the Configure button to create a new model stock profile by inserting required information such as Model Stock Name, Default Quantity, Pack Quantity.
- Model stock name: Unique name for each model stock profile which is able to use to search in the model stock profile creation.
- Default quantity: If the item is not added in Model Stock, the quantity will follow the default quantity in the profile.
- Pack quantity: Define each replenishment required pack quantity for the item not in the model stock item list.
- Proceed to Add Item from inventory into the model stock profile.
- After adding the item, configure the Min Qty and Pack Qty for each item in the list.
- Press Save to complete the model stock profile creation.
Assign outlet to Model Stock
- After creating the Model Stock, the next step will need to assign outlets to the model stock created.
- Use the Add button to create a new row of configurations and select Outlet and Model Stock.
- After modifying the Outlet selection with Model Stock, press Save to save the changes.
- After assigning outlet with Model Stock, proceed to configure the Model Stock Profile by outlet and model stock in order to configure the date count for sales data:
Insert the necessary information as:
- Profile name: Indicate the name for the model stock profile.
- Outlet (Model Stock): Select the model stock to take effect in the model stock profile.
- Sales Start Date Count: Indicate the sales start date count during calculation of replenishment.
- Sales End Date Count: Indicate the sales end date count during calculation of replenishment.
- Example:
Current date: 01/09/2025
Sales start date count: 30
Sales end date count: 1
Thus, the sales generation date will be from 01/08/2025 to 31/08/2025.
- Press Add to create the model stock profile.
- The Stock Replenishment generation process will follow the Outlet Ranking setup by individual outlet.
- In order to configure Outlet Ranking, go to Company Info > Additional Information > Outlet ranking.
- Users need to assign each ranking value to each outlet and be able to add a specific rank name. Press Save to store the configuration.
- After being saved and exiting from the Outlet Ranking configuration, the value will be displayed in the Outlet Ranking field by outlet as below:
Stock Replenishment process
Select one profile which is created from Model Stock Profile and press Generate to compile the SOQ list based on outlet configured.
- The sequence of location in the listing will be followed by the value in the Outlet Ranking configuration.
- When there are outlets with the same ranking, the system will order by outlet name.
Other information used during generation:
- Outlet List Applied: Selected outlet based on the location configured in the Model Stock Profile.
- Sales Start Date & Sales End Date: Auto generate date based on the days count configured in the Model Stock Profile.
- Request Date From & Request Date To: By default will generate 1 month record from current date to compile the quantity for Total Requested Quantity.
- Press the Assign Stock button to assign fulfilled quantity by outlet ranking with current login outlet's stock Onhand Quantity.
- After fulfilled quantity being inserted, press Confirm to proceed generate stock request.