Home / Insights / Inventory
INVENTORY

Consignment sales made simple with ERPNext.

Your stock sits on the customer’s shelf, and you bill only for what they use. Here is how to run it cleanly in ERPNext.

DIRishad25 Oct 2026 · Data to InsightREADING TIME5 min readTOPICInventory
Consignment sales made simple with ERPNext.
01

Why consignment gets messy

Consignment selling should be simple. Your stock sits on the customer’s shelf, and you bill only for what they use.

In practice, many businesses run it on spreadsheets, phone calls and month-end guesswork. Stock goes missing between “sent” and “sold”. Invoices go out late. Nobody is sure what is still lying at the customer’s site.

After setting this up for several clients, our view is clear: with the right structure, ERPNext makes consignment one of the easiest models to run.

02

What consignment selling really means

In a consignment model, you place stock at the customer’s location but you still own it. The customer pays only when they sell or use it.

It is common in pharma and hospital supplies, spare parts, FMCG distribution, building materials and retail. The model is simple. Tracking it is where things go wrong:

  • Ownership: the stock is yours, but it is not in your building.
  • Visibility: you need to know what is on each customer’s shelf, today.
  • Billing: you should invoice only what was used, and on time.
  • Control: expiry, damage and slow-moving stock happen at someone else’s site.
03

The model: one warehouse per customer

The cleanest setup is to treat each consignment customer as a warehouse in your system.

  1. Create a group warehouse called Consignment Stock.
  2. Under it, create one warehouse per customer, for example Consignment – ABC Hospital.
  3. Map each warehouse to its customer, through naming and a link field.

The stock stays on your books, but you can see exactly where it is. Your own warehouse shows what is in-house. Each customer warehouse shows what is on that customer’s shelf. The group warehouse shows your total consignment exposure in one number.

One warehouse per customer: a Consignment Stock group warehouse with a warehouse for each customer site
04

How it runs in ERPNext, step by step

The whole cycle uses standard ERPNext documents. No heavy customisation is needed.

  1. Send stock. A Stock Entry (Material Transfer) moves goods from your main warehouse to the customer’s warehouse. Ownership does not change, so no sale is booked.
  2. Track it. The Stock Balance report, filtered by the customer warehouse, shows live quantity and value at that site.
  3. Record usage. The customer shares what was used, through a periodic report, a count or a portal entry.
  4. Bill it. A Sales Invoice with Update Stock ticked, using the customer warehouse as source, books the sale and reduces stock in one step.
  5. Reconcile. A Stock Reconciliation after each physical count fixes any gap, with a full audit trail.
  6. Pull back. Expired or slow-moving items return to your main warehouse with another transfer.

The result: you bill only what was used, you bill it on time, and every unit has a trail.

Six steps, all standard ERPNext: send, track, record, bill, reconcile, pull back
05

Why ERPNext fits consignment so well

The warehouse model works because of what ERPNext already includes.

  • No limit on warehouses. Warehouses are a core part of the system, not a paid add-on. Add 5 or 500 customer sites without a bigger licence bill.
  • Warehouse tree. Group warehouses roll up stock by region, sales rep or customer type.
  • Batch and serial tracking. Know which batch sits at which customer. Critical for expiry-driven products like pharma and food.
  • Stock Ageing report. Spot slow-moving stock at each site before it turns into a write-off.
  • Perpetual inventory. Consignment stock keeps its value on your balance sheet, with accounting entries posted automatically.
  • Reorder levels per warehouse. Set a minimum for each customer and let ERPNext raise a Material Request to top it up.
  • Customer portal and permissions. Customers or field staff can see or report only their own site’s stock.
  • Open source. Add a custom field, a print format or an approval rule when your process needs it.
Built for consignment: eight ERPNext features that support consignment
06

The takeaway

“Consignment is not a hard model. It only becomes hard when the system cannot show where your stock is, or when the pricing punishes you for modelling it properly.”

One warehouse per customer, standard documents and a few good reports are enough. With ERPNext, that structure costs nothing extra.

At Data to Insight, we design and implement consignment workflows on ERPNext for distributors and manufacturers. If you are running consignment on spreadsheets today, let’s talk.

KEY TAKEAWAYS
  • Treat each consignment customer as its own warehouse, under one group warehouse.
  • Move stock with a Material Transfer; bill usage with a Sales Invoice from that warehouse.
  • Reconcile after every physical count, so every unit has a trail.
  • ERPNext has no warehouse limit, so 5 or 500 customer sites cost nothing extra.
Working through this in your business?

Tell us where you are today. We’ll help you find a practical next step.

Talk to our team
Keep reading

More insights.

All insights

Choose a system that fits your business, and your team.

Read the insight

A dashboard is only as useful as the data behind it.

Read the insight
The next step starts with a conversation

Let's build better systems,
better visibility and
better decisions.

Tell us what is slowing your business down.
We’ll work out the right place to start.

Book a consultation