Description
Separate an outstanding ordered quantity from extra units received.
Supply-chain counts distinguish individual units, case packs, dispatches, receipts, in-transit stock and returns. A signed residual can expose an inconsistent record rather than prove physical loss. Costs, clearances and expiry/retest dates use separate conventions; accurate arithmetic does not replace stock inspection, material release or contractual review.
Separate an outstanding ordered quantity from extra units received.
When to use this tool
Use Ordered Received Backordered Split when you already have orderedUnits, receivedUnits and need to separate an outstanding ordered quantity from extra units received.
How to use the tool and how it works
- Enter orderedUnits, receivedUnits. Use the units and conventions below.
- Run the tool. Correct any format, range, or cross-field input error before interpreting the output.
- Read stillOrderedUnits, extraReceivedUnits. Use the output convention below.
Require nonnegative safe whole ordered/received counts; return positive parts of ordered-received and received-ordered.1
| Input field | Meaning and units | Accepted input |
|---|---|---|
| orderedUnits | Ordered Units | Required. Safe integer; minimum 0. |
| receivedUnits | Received Units | Required. Safe integer; minimum 0. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| stillOrderedUnits | Still Ordered Units | Required. Safe integer. |
| extraReceivedUnits | Extra Received Units | Required. Safe integer. |
{
"input": {
"orderedUnits": 100,
"receivedUnits": 75
},
"output": {
"stillOrderedUnits": 25,
"extraReceivedUnits": 0
}
}Limitations and assumptions
- The result does not confirm a backorder, delivery entitlement or stock quality.
- Inputs must satisfy both the field types and the cross-field conditions above. Invalid input causes an error; a successful false flag or documented placeholder is a different result.
- Numeric calculations use binary floating point unless exact decimal-integer arithmetic is explicitly stated. No hidden measurement tolerance or decimal rounding is added; nonfinite or out-of-contract results are rejected. Numeric signed-zero results are exported as zero.
Alternative or Complementary methods
Reconcile item-level dispatch, receipt, return and inventory ledgers against physical stock and lot records. Use actual package dimensions, handling plans and release documents when a quantity margin alone cannot answer an operational question.
References
Similar or alternative tools
- Transfer Order Received Shortfall
Calculate a signed unexplained shipment shortfall after received and in-transit units.
- Outbound Order Pick Complete Flag
Check per-line picking completeness and separate shortfall from excess.