Skip to content
ERPNext Data Model
Esc
navigateopen⌘Jpreview
On this page

Selling

Customer, Quotation and Sales Order — the order-to-cash chain up to the point a Delivery Note or Sales Invoice is raised.

The order-to-cash pipeline upstream of invoicing: Quotation, Sales Order, Customer, Sales Partner, and the selling-side pricing structures.

What it does

Selling turns demand into a commitment. A Quotation is an offer; converting it produces a Sales Order, which is the hub the rest of the chain pulls from — Delivery Note and Sales Invoice in Stock and Accounts, Production Plan and Work Order in Manufacturing, Material Request in procurement. Every downstream line keeps a back-reference to its Sales Order row, which is how billed and delivered percentages are tracked.

Key features

  • Customer — credit limits, default price list and payment terms, plus a customer-wise item and tax setup.
  • Quotation → Sales Order — with per-line delivered_qty / billed_qty roll-ups and over-delivery tolerances.
  • Product Bundle — sell a kit as one line while issuing its components from stock.
  • Pricing and promotions — Price List, Pricing Rule, Coupon Code and Sales Partner commission.
  • Blanket Order — a long-term quantity/rate agreement that Sales Orders draw down against.
  • Sales team — Sales Person targets, Sales Team allocation on the transaction, and Territory-based reporting.

Entity relationships

Each diagram below is one connected cluster of entities. Edges are labelled with the fieldname that carries them — see relationship notation for how to read the crow’s feet.

Customer

Customer anchors the selling model, connecting quotations and orders with credit limits, sales teams, permitted items, and customer-specific identifiers.

Document composition

Parent documents and the child tables they own.

Entity reference

Look it up

Was this page helpful?