How do I separate a supplier shortfall from received items rejected at inspection?
The query basis assumes an invoice for all ordered units. Rejected stock must be counted within received stock.
Open Delivery discrepancy slipTry the worked example
These are the example inputs from Delivery discrepancy slip. Replace them in the tool to run your own case.
| Units ordered (units) | Units arrived (units) | Damaged or rejected (units) | Invoice unit price (€/unit) |
|---|---|---|---|
| 540 | 520 | 16 | 6.2 |
Example result
Accepted units · 504 units
Who uses this?
Goods-in coordinator. The free online tool runs the calculation in your browser. To edit the files and use the tools offline in one business, see the €49 offline edition.
Where the idea came from
A person reviews the output and handles exceptions before buying. This independent application adapts that idea to separate a supplier shortfall from received items rejected at inspection.
Original video