How to Track Primary and Secondary Sales in ERPNext (2026 Distributor Guide)

If you sell through distributors, your ERP only tells half the story. Primary sales — what you ship to distributors — are easy to see. Secondary sales — what distributors actually sell to retailers — are where most brands go blind. This guide shows you exactly how to set up ERPNext for distributor secondary sales tracking, step by step.

Most FMCG and consumer-goods brands in India route stock through a distributor-to-retailer network of an estimated 12 million-plus outlets. Yet their ERP captures only the first hop. The result is predictable: overstocked distributors, dead schemes, and forecasts built on sell-in instead of real demand.

It does not have to be this way. ERPNext — the open-source ERP built on the Frappe Framework — has every primitive you need to track secondary sales properly. The catch is that nobody has written it down. The top-ranking Frappe forum thread on this exact question still has zero replies. Consider this the answer.

Primary vs secondary sales and the visibility gap

Before configuring anything, get the definitions straight, because the entire setup depends on them.

The gap between the two is where margin leaks. When you track only primary sales, a great month can simply mean you pushed stock onto distributors who cannot move it. Two months later you face returns, expired schemes, and a sales team chasing targets against phantom demand.

Dimension	Primary sales (sell-in)	Secondary sales (sell-out)
Who transacts	You to distributor	Distributor to retailer or consumer
What it measures	Stock pushed into the channel	Real market consumption
ERPNext document	Sales Invoice / Delivery Note	Portal invoice, custom DocType, or import
Stock movement	Into the distributor warehouse	Out of the distributor warehouse
Why it matters	Revenue recognition, dispatch	Forecasting, scheme ROI, stock cover

Tracking both inside one system lets you calculate the metric that actually runs a distribution business: stock cover — how many days of inventory each distributor holds based on their real sell-out rate.

Can ERPNext track secondary sales?

This is the question on the Frappe forum, and the honest answer is more useful than a flat yes.

The mistake most teams make is treating secondary sales as an afterthought — dumping it into the same warehouse as company stock, or tracking it in a spreadsheet bolted onto ERPNext. Both break reporting within weeks. The reliable approach is the three-step structure below: model the network, capture the data, then report on it.

Step 1 — Model your distribution network with a warehouse tree

ERPNext warehouses are a tree, not a flat list. That tree is what makes distributor stock visibility possible. Create one parent (group) warehouse per distributor, with child warehouses beneath it for saleable stock and returns.

A typical structure looks like this:

All Warehouses
├── Plant - Finished Goods
├── Depot - North
└── Distributors (group)
    ├── Distributor - Mumbai (group)
    │   ├── Mumbai - Saleable
    │   └── Mumbai - Returns
    └── Distributor - Pune (group)
        ├── Pune - Saleable
        └── Pune - Returns

When you raise a primary Sales Invoice (or Delivery Note) to a distributor, set the target warehouse to that distributor's saleable warehouse. Stock now sits against the distributor in ERPNext. Every secondary sale later draws stock out of the same warehouse, so on-hand quantity always reflects reality.

This single decision — a warehouse per distributor — is what most "ERPNext cannot do secondary sales" complaints are missing.

Step 2 — Capture secondary sales data with these 5 methods

Now you record what distributors sell to retailers. The right method depends on how digitised your channel is. Here are five proven options, from fully integrated to lightweight.

Most brands start with bulk import for a quick win, then graduate the largest distributors to the portal or an API sync. Whatever the method, the rule is the same: every secondary transaction must post against the distributor's warehouse so stock and sales stay reconciled.

Step 3 — Build a primary vs secondary sales report

With data flowing in, the payoff is a single report management can trust. ERPNext gives you three tools, in increasing order of power: the Report Builder, Query Reports (SQL), and Dashboard Charts with Number Cards.

The fields that matter most in a channel report are:

• Primary quantity and value (sell-in) per distributor and item.
• Secondary quantity and value (sell-out) for the same dimensions.
• Closing distributor stock and stock cover in days.
• Scheme cost as a percentage of secondary sales.
• Returns and damages as a percentage of primary.

Group these by month and territory, and your sales heads finally see which distributor is overstocked, which is about to run dry, and which schemes actually moved product. For non-technical users, surface the same numbers as a Dashboard so the answer is one click away every morning.

The brands that win at distribution are not the ones with the fanciest dashboard. They are the ones who can answer one question on any given morning — which distributor is sitting on dead stock, and which is about to run out. ERPNext answers that for the cost of setting it up once.

Automate schemes and claims on secondary sales

Trade schemes are where distribution margins live or die, and ERPNext automates most of it with Pricing Rules.

A Pricing Rule applies quantity-based, value-based, or free-item schemes automatically at billing — scoped by item group, customer group, or territory. So a "buy 10 get 1 free" or a 5 percent slab discount triggers without manual entry, on primary or secondary invoices.

Distributor claims for those schemes are then tracked two ways:

• As credit notes against the distributor when the claim is approved.
• As records in a custom Claim DocType, reconciled against the secondary sales that earned them.

That reconciliation — claims matched to the actual sell-out that justified them — is what turns scheme spend from a guessing game into a measured line item. For deeper India-specific accounting (GST on credit notes, TDS), see how we approach this in our guide on ERPNext vs Odoo for Indian businesses.

ERPNext vs a dedicated DMS or SFA

A fair question at this point: why not just buy a dedicated Distributor Management System (DMS) or Sales Force Automation (SFA) tool? The honest comparison:

Capability	ERPNext (configured)	Dedicated DMS / SFA
Secondary sales tracking	Yes — portal, DocType, import, API	Yes — core feature
Distributor stock visibility	Yes — warehouse tree	Yes
Schemes and claims	Yes — Pricing Rules + custom DocType	Yes
Channel reports and dashboards	Yes — Report Builder	Yes
Field beat planning and GPS	Limited — needs an add-on app	Strong
Offline mobile order capture	Limited	Strong
Accounting, GST, inventory in one system	Yes — it is a full ERP	No — separate system to integrate
Licence model	Open source, zero per-user fee	Recurring per-user subscription
Data ownership	Full — self-hosted on your infra	Vendor-hosted

If you already run ERPNext for accounting and inventory, extending it for secondary sales is far cheaper than buying and integrating a separate DMS. If your priority is a large field salesforce in rural beats, pair ERPNext with a focused mobile app rather than replacing it. Our Frappe and ERPNext implementation practice does exactly this kind of fit assessment.

Your rollout plan for secondary sales tracking

You do not need a six-month project. A focused rollout gets you to live reporting quickly.

Because ERPNext is open source on Frappe, every customisation you build — the custom DocType, the API sync, the reports — stays yours, regardless of who hosts it or who supports it later.

The brands that get this right stop arguing about whose numbers are correct and start acting on a single source of truth. That is the whole point of tracking secondary sales in ERPNext: not more data, but the right data, in time to act on it.