How to Track Primary & Secondary Sales in ERPNext (2026)

Most FMCG and consumer-goods brands in India sell through distributors into a very large number of retail outlets, yet their ERP sees only the first hop. The result is predictable: overstocked distributors, schemes that don't move product, and forecasts built on sell-in instead of real demand. Our page for brands that sell this way is distribution ERP for wholesale and trading.

ERPNext, the open-source ERP built on the Frappe Framework, has the pieces you need to track secondary sales. They just aren't assembled into one feature, and the Frappe forum thread on this exact question has little to go on. This guide is our answer.

What is the gap between primary and secondary sales?

Get the definitions straight first, because the whole setup depends on them.

The gap between the two is where margin leaks. When you track only primary sales, a great month can mean you pushed stock onto distributors who can't move it. A couple of months later you face returns, expired schemes, and a sales team chasing targets against demand that isn't there.

Tracking both in one system lets you calculate the number that runs a distribution business: stock cover, how many days of stock each distributor holds at their real sell-out rate.

Can ERPNext track secondary sales?

Yes, with a little design. 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 beside ERPNext. Both break reporting within weeks. The reliable approach is the three steps below: model the network, capture the data, then report on it.

Step 1: how do you model your distribution network?

ERPNext warehouses form a tree, and that tree is what makes distributor stock visible. The question is where the tree lives, so that distributor stock never sits in your own accounts.

With a separate channel-tracking company, a typical tree looks like this:

Channel Stock (separate company, tracking only)
└── 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 in your own company, the same quantity is posted into that distributor's saleable warehouse in the tracking company, by an import or a small automation. Every secondary sale then draws stock out of it, so the distributor's on-hand quantity follows reality while your own books stay correct. Agree the setup with your accountant, so the tracking company's stock is never read as yours.

This one decision, a stock structure per distributor kept apart from your own, is what most "ERPNext can't do secondary sales" complaints are missing.

Step 2: how do you capture secondary sales data?

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

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

Step 3: how do you build a primary vs secondary sales report?

With data flowing in, the payoff is one 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:

• 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 see which distributor is overstocked, which is about to run dry, and which schemes moved product. For non-technical users, put the same numbers on a Dashboard so the answer is one click away every morning.

A worked example: distributor stock cover in days

The most useful number this setup unlocks is stock cover: how many days of stock a distributor holds at their real sell-out rate. It tells you who is about to run dry and who is quietly sitting on dead stock. Here is the calculation, with numbers.

Say you pull the last 30 days for one SKU across two distributors from their stock balances and secondary sales:

Both distributors look similar on primary sales: you shipped each a healthy quantity last quarter. Secondary sales tell the real story. Mumbai turns its stock in 18 days and will need a replenishment order within the fortnight; Pune is sitting on four months of cover and is a candidate for a return, an expiring scheme or a transfer to a neighbouring territory. Without secondary data, both show as "sold" and you would ship Pune more.

In ERPNext this is a Query Report: closing stock comes from the Stock Balance report for each distributor's warehouse in the tracking structure, and average daily sell-out from secondary sales grouped by item and distributor. Colour the stock-cover column against your limits, and your sales heads can triage the whole channel at a glance every morning.

How do you automate schemes and claims on secondary sales?

Trade schemes are where distribution margins are won or lost, and ERPNext automates most of the work with Pricing Rules.

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

Distributor claims for those schemes are then tracked in one of 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 sell-out that justified them, turns scheme spend from a guess into a measured line. How GST applies to scheme credit notes, and whether TDS applies to a claim, are questions for your CA.

Should you use ERPNext or a dedicated DMS/SFA?

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

If you already run ERPNext for accounting and stock, extending it for secondary sales usually costs less than buying and integrating a separate DMS. If your priority is a large field sales force on rural beats, pair ERPNext with a focused mobile app rather than replacing it. Our ERPNext implementation work starts with exactly this kind of fit check.

What should your rollout plan look like?

A focused rollout gets you to live reporting without a long project. How long each stage takes depends on how many distributors you have and how clean their data is.

Because ERPNext is open source on Frappe, everything you build (the custom record, the API sync, the reports) stays yours, whoever hosts or supports it later.

The brands that get this right stop arguing about whose numbers are correct and start acting on one set. That is the point of tracking secondary sales in ERPNext: not more data, but the right data, in time to act on it. The distribution page shows the ordering and stock flows running live on a demo company.