- Home
- Blog
- Glossary (EDGEBIC)
- What Is a Sales Order Reference Number?
A sales order reference number is the short human-readable identifier for one customer order, required on every order and unique within that customer. It is the handle everyone quotes when they talk about an order, the key that groups jobs under it on reports, and the point where your numbering and your customer's numbering are reconciled.
This entry defines the reference number and shows how it reads inside EDGEBIC by User Solutions. For the wider index of terms, see the manufacturing glossary; for the document it names, see EDGEBIC sales orders explained; and for the rows beneath it, see what is a sales order line.
How It Works
A sales order has a header and a set of lines. The header names the customer and holds the order-wide details, and the reference number is the header field that identifies the order to people. Lines carry the demand; the reference carries the identity. On a bulk load the reference does a second job, gathering file rows into one order through sales order reference grouping.
Two rules govern it. The first is uniqueness, and its scope is the customer rather than the whole system. The pair of customer and reference must be distinct, so two customers may both have an order numbered 1001 without any conflict, but one customer cannot have two orders numbered 1001. Attempting the second is refused outright with a message naming the value already in use, rather than being allowed through and creating an ambiguity that surfaces months later when someone searches.
Scoping uniqueness per customer is a deliberate choice. Customers run their own numbering schemes, and those schemes routinely collide with each other. Forcing global uniqueness would mean you could never record a customer's own purchase order number verbatim, because sooner or later a second customer would use the same string.
The second rule is that the reference is required. Leaving it blank does not produce a number for you, it refuses the save. Your numbering is therefore a decision you make and keep, not one the system makes on your behalf. For orders that originate inside your business and have no external paperwork to mirror, adopt a house series such as SO-2026-0047 and continue it yourself.
A Concrete Example
A customer already has an order on file with the reference ORD-2026-001. A planner tries to enter a second order for the same customer and types the same reference again, because the paperwork on the desk carries that number.
The save is refused, with a message stating that ORD-2026-001 is already in use for this customer. That refusal is the point: it catches the duplicate at entry, when it costs thirty seconds to resolve, rather than three weeks later when two jobs have been scheduled and someone is trying to work out which order a shipment belongs to.
The planner checks and finds the customer did indeed send a second purchase order, reusing their own numbering. They enter it as ORD-2026-001-B, which keeps the customer's number legible while making the two orders distinct.
A different order that same afternoon has no customer paperwork at all, because it is an internal stocking commitment. There is nothing to copy from, so the planner follows the house series: forty-six internal orders already exist for the year, so this one is entered as SO-2026-0047 and saved.
How EDGEBIC Uses It
In EDGEBIC, the reference number lives on the sales order header and is checked for uniqueness against the other orders for the same customer. A collision is rejected with an explicit message rather than being silently accepted or silently renamed.
Left blank, the order is refused rather than numbered for you, so the series for internally originated orders is one you maintain. Kept consistently, it sits comfortably alongside customer-supplied references for the rest.
The reference is what groups work downstream. When manufacturing orders are linked to a sales order, reports and grids present those jobs under the order's reference, so customer service can answer how the whole order is progressing without walking job by job. It is also the value bulk imports match on when they group incoming rows into orders, which is why a consistent convention matters more than a clever one.
Choosing that convention is worth a short conversation. Use the customer's purchase order number when there is one, because that is the string both sides will say out loud, and let the system generate the reference when there is not. What causes trouble is mixing the two arbitrarily, which lets the same real order be entered twice under two different labels.
For the lifecycle the header controls, see what is a sales order status. For the partner the reference is scoped to, see what is a customer id, and for how the order's demand reaches the plan, see what is firm demand in planning.
A sales order reference number is the short human-readable identifier that names one customer order, such as ORD-2026-001 or a customer's own purchase order number. It is what people quote to each other on the phone and what appears on grids, filters, and reports when jobs are grouped by the order they belong to. It is a label for the whole order document rather than for any single line, and it is the handle used to find the order again later.
It must be unique per customer, not globally unique across the whole database. Two different customers may each have an order called ORD-001 without conflict, because the pair of customer plus reference is what has to be distinct. Trying to reuse a reference number on a second order for the same customer is rejected with a message naming the value already in use. Scoping uniqueness this way lets you record each customer's own numbering scheme without forcing their schemes to agree with one another.
The order will not save. The reference is required, and leaving it empty is refused with a message saying so. That means your numbering is a decision you make rather than one the system makes for you. When the order comes from a customer purchase order, type that number in so the two systems agree. When it originates inside your business and has no external paperwork to mirror, use a house convention such as SO-2026-0047 and keep the sequence yourself.
You cannot store the same reference twice against one customer, because the customer-plus-reference pair has to be unique, so the second order will be rejected. The practical fix is to qualify the reference with something that varies, such as appending the period to give ORD-500-2026-07 and ORD-500-2026-08, which keeps the customer's own number visible while making each order distinct. The alternative is to use your own internal reference and record the customer's number elsewhere, though that makes cross-referencing harder for whoever is on the phone. Qualifying the reference is usually the better trade because the number stays greppable in a grid filter.
Cancel the duplicate rather than deleting it, so the trail of what was entered and withdrawn survives. A canceled order stops producing firm demand, which means its lines drop out of the inventory projection and the master schedule immediately, and the plant stops planning to build the same goods twice. Before canceling, check whether any manufacturing orders were already linked to the duplicate, and relink or cancel those as well so no orphan job keeps consuming capacity. Then, to stop it recurring, agree on one convention for the reference: either always the customer purchase order number or always the generated one, but not a mixture that lets the same order look new to the second person entering it.
Expert Q&A: Deep Dive
Q: Our customer sends a new purchase order every month and reuses the same number each time. What do we do?
A: You cannot store the same reference twice against one customer, because the customer-plus-reference pair has to be unique, so the second order will be rejected. The practical fix is to qualify the reference with something that varies, such as appending the period to give ORD-500-2026-07 and ORD-500-2026-08, which keeps the customer's own number visible while making each order distinct. The alternative is to use your own internal reference and record the customer's number elsewhere, though that makes cross-referencing harder for whoever is on the phone. Qualifying the reference is usually the better trade because the number stays greppable in a grid filter.
Q: Two people entered the same customer order twice under slightly different references. How do I clean it up?
A: Cancel the duplicate rather than deleting it, so the trail of what was entered and withdrawn survives. A canceled order stops producing firm demand, which means its lines drop out of the inventory projection and the master schedule immediately, and the plant stops planning to build the same goods twice. Before canceling, check whether any manufacturing orders were already linked to the duplicate, and relink or cancel those as well so no orphan job keeps consuming capacity. Then, to stop it recurring, agree on one convention for the reference: either always the customer purchase order number or always your own internal series, but not a mixture that lets the same order look new to the second person entering it.
Frequently Asked Questions
Ready to Transform Your Production Scheduling?
User Solutions has been helping manufacturers optimize their production schedules for over 35 years. One-time license, 5-day implementation.

User Solutions Team
Manufacturing Software Experts
User Solutions has been developing production planning and scheduling software for manufacturers since 1991. Our team combines 35+ years of manufacturing software expertise with deep industry knowledge to help factories optimize their operations.
Share this article
Related Articles
The EDGEBIC Scheduling Glossary Index
A themed index to the EDGEBIC glossary: scheduling engine, capacity and calendars, materials and planning, shop floor, reporting, quoting, and data import terms, defined in plain language.
What Is the Critical Chain in Manufacturing Scheduling?
The critical chain is the longest dependent path through a plan once shared machine contention is counted, not just step precedence. Here is how it differs from the critical path.
What Does Finite Capacity Mean in EDGEBIC?
Finite capacity means the scheduler refuses to book more hours on a machine than that machine actually has. See exactly how EDGEBIC enforces it, day by day and shift by shift.
