Festive season inventory planning in ERPNext for distributors and manufacturers
Diwali falls on Sunday, 8 November this year. For a Chennai distributor of home appliances or a Coimbatore maker of pressure cookers, that means dealers are already calling for stock, trucks are booked, and the warehouse holds plenty of what sold slowly last year and not enough of what dealers want now. Festive season inventory planning is less about forecasting genius and more about reading your own last season properly, setting a few controls in ERPNext, and deciding in advance what happens to leftover stock in December.

Where festive stock usually goes wrong
The mistakes we see are rarely exotic. Purchase follows the salesperson who shouts loudest. Dealer credit gets stretched informally because “it is Diwali”. Schemes are announced on WhatsApp and applied by hand on invoices. And nobody owns the stock that is left over once the lights come down.
All four are failures of festive season inventory planning, and all four are system problems as much as people problems. ERPNext already has the reports and controls to handle them. The work is setting them up before the rush, not during it.
Start festive season inventory planning from last year’s numbers
Your best forecast is your own sales history, read the right way. Open Sales Analytics, set it to quantity rather than value, group by Item Group and Territory, and look at the weeks before last year’s Diwali.
One detail matters. Diwali moves on the calendar every year, so comparing October with October can mislead. Compare the same number of weeks before the festival instead. If your dealers ordered heavily a few weeks before the festival last year, plan for the same shape relative to the festival this year, whatever the month.
| Question | Where to look in ERPNext | Decision it drives |
|---|---|---|
| Which item groups sold most in the pre-festival weeks last year? | Sales Analytics by Item Group, quantity basis | Which items get raised reorder levels |
| Which territories and dealers drove the peak? | Sales Analytics by Territory and Customer | Where to position stock and who gets credit headroom |
| What is already coming in or committed? | Stock Projected Qty | How much more to buy or make |
| What did not move after last season? | Stock Ageing | What not to buy again, and what to clear now |
For distributors, our piece on ERPNext for distribution covers how territories, price lists and dealer hierarchies should be set up so these reports are meaningful.
Projected quantity and reorder levels
Actual stock is the wrong number for festive season inventory planning. ERPNext calculates Projected Qty as actual quantity plus planned, requested and ordered quantities, minus quantity reserved for open sales orders. It is the honest answer to “how much will I have, given everything already in motion”.
Reorder levels work off that figure. Set Reorder Level and Reorder Qty on the item, per warehouse where needed, and enable automatic Material Requests in Stock Settings. When projected quantity in the warehouse drops to the reorder level, ERPNext raises a Material Request and notifies the purchase manager. If projected quantity is above the level, it does nothing.
For festive season inventory planning, we suggest raising reorder levels for the fast item groups for a defined window, then putting them back. Write the end date down. Raised levels that nobody reverses are how December warehouses fill up with stock bought for October.
For manufacturers: let the Production Plan do the arithmetic
A manufacturer cannot buy finished goods off the shelf. The question is what to make and which components to buy. The Production Plan takes items from Sales Orders, from Material Requests, or entered manually, which is useful when dealer orders arrive late but you know the festive mix from last year.
Tick the option to skip available raw materials and sub-assemblies, and the plan subtracts projected quantity before working out what is short. On submit it creates Work Orders for what you make and Material Requests for what you buy. For a Coimbatore kitchen appliance maker, that turns festive season inventory planning into one screen instead of three spreadsheets. If your shop floor needs more structure first, our guide to ERPNext for manufacturing is the place to start.
Dealer credit limits during the festive push
Every distributor knows the tension. Sales wants to load dealers before Diwali; accounts knows some of those dealers paid late last season. Festive season inventory planning that ignores credit simply moves the risk from the warehouse to receivables.
ERPNext checks credit at three levels: on the Customer, per company; then on the Customer Group; then on the Company as a fallback. The Sales Invoice is blocked if outstanding would cross the limit, and by default the Sales Order is checked too. A “bypass credit limit check at Sales Order” option exists on the customer, but the invoice check still applies. Only users holding the role named as Credit Manager in Accounts Settings can override. The Frappe credit limit documentation explains the order of precedence.
Agree the rules before the rush, not dealer by dealer at 9 pm on a dispatch day.
| Situation | Who decides | How ERPNext enforces it |
|---|---|---|
| Dealer within limit, normal scheme | Sales team | No intervention |
| Good payer needs temporary headroom | Finance head, before the season | Raise the customer limit for a dated window |
| Dealer crosses limit on a single order | Credit Manager role holder | Override at submission, logged against the user |
| Dealer has overdue invoices from last season | Promoter or CFO | Keep the limit; ask for payment first |
Schemes and discounts without manual editing
Festive schemes applied by hand are where margin leaks, and they belong in festive season inventory planning because a scheme moves stock as surely as a purchase order does. A Promotional Scheme in ERPNext groups discount slabs and creates the matching Pricing Rules. Each slab can give a price discount or a free item, apply by Item, Item Group or Brand, and be limited to certain Customer Groups or Territories. Set validity dates so the scheme ends when it should.
Two practical notes. Manage the scheme from the Promotional Scheme record, not by editing the generated Pricing Rules one by one. And if you run cumulative schemes, the discount applies only to the transaction that crosses the threshold, not retrospectively to earlier invoices. Explain that to your sales team before a dealer asks.
Warehouse capacity and dispatch planning
Festive stock arrives faster than it leaves. If inbound material lands wherever there is floor space, finding it again costs more than the storage. Putaway Rules in ERPNext set a capacity for each item in each warehouse with a priority order. With “Apply Putaway Rule” ticked on Purchase Receipts and Stock Entries, incoming stock fills the preferred location first and overflows to the next.
On the outbound side, Delivery Trip groups Delivery Notes into one vehicle run with driver, vehicle, stops and departure time. For a distributor running several trucks a day in the last fortnight before Diwali, that alone ends a lot of phone calls. Our article on order to dispatch inventory visibility covers the full flow from Sales Order to proof of delivery.
After the season: slow-moving stock
The season ends abruptly. What remains in the warehouse in the weeks after Diwali tells you more about your planning than anything that sold. Run Stock Ageing by warehouse and item group, and decide category by category: hold it for wedding season demand where your trade sees one, move it to a territory still selling, return it to the supplier where the terms allow, or clear it with a short, dated scheme.
Then reset the reorder levels you raised and write down what you learnt while it is fresh. That note is next year’s starting point.
Festive season inventory planning checklist
- Pull Sales Analytics for the weeks before last year’s Diwali, by item group and territory, on quantity.
- Run Stock Ageing and remove last year’s slow movers from the buy list.
- Check Stock Projected Qty for the fast item groups.
- Raise reorder levels for a dated window, and enable automatic Material Requests.
- Manufacturers: run a Production Plan with “skip available” ticked.
- Review dealer credit limits and agree who can override.
- Set up festive offers as Promotional Schemes with end dates.
- Define Putaway Rules for peak inbound, and plan Delivery Trips for the last two weeks.
- Book a post-season review to reset reorder levels and clear ageing stock.
If it is mid-October and half of this is not done, start with steps three, six and seven. Those protect cash and margin this season. The rest makes next year’s festive season inventory planning start in August instead of October.
Want next season planned from your own data? We set up ERPNext for distributors and manufacturers so stock, credit and schemes work from one system. Book a free 30-minute ERPNext consultation, or get a quick figure from our ERPNext cost estimator.
Frequently asked questions
How do I forecast festive demand in ERPNext?
For festive season inventory planning, use Sales Analytics on quantity basis, grouped by item group and territory, for the weeks before last year’s festival. Because Diwali moves on the calendar, compare weeks before the festival rather than calendar months.
What is projected quantity in ERPNext?
Projected Qty is actual stock plus planned, requested and ordered quantities, minus quantity reserved for open sales orders. Automatic reorder uses this figure, not just stock on hand.
Can ERPNext create purchase requests automatically when stock is low?
Yes. Set reorder level and reorder quantity on the item, per warehouse if needed, and enable automatic Material Requests in Stock Settings. A Material Request is raised when projected quantity reaches the reorder level.
How do I control dealer credit during the festive season?
Set credit limits on the Customer or Customer Group per company. ERPNext blocks Sales Invoices that would cross the limit, and only the Credit Manager role set in Accounts Settings can override.
How do I set up a Diwali scheme in ERPNext?
Create a Promotional Scheme with discount slabs, choose price or product discount, limit it to the right customer groups or territories, and set validity dates. ERPNext generates the Pricing Rules automatically.
What should I do with slow-moving stock after Diwali?
Run Stock Ageing by item group and warehouse, then hold, transfer, return or clear each category with a dated scheme. Reset any reorder levels you raised for the season.
Festive season inventory planning: key takeaways
Festive season inventory planning in ERPNext starts with last year’s Sales Analytics, compared by weeks before Diwali rather than by month. Plan on projected quantity, raise reorder levels for a dated window, and let the Production Plan net off what is already available. Protect cash with credit limits and a named override role, put schemes into Promotional Schemes with end dates, use Putaway Rules and Delivery Trips for peak weeks, and review ageing stock once the season ends. The Frappe guide to Promotional Schemes is a useful read for your sales operations team.