Product Cost
What the system believes a product cost you — the number every profit figure is measured against.
DigitalKey ERP — Docs · digital-key.co/docs/products/costing
Overview
Each product carries one cost (shown as Purchase Price on the product form). It is a weighted average of everything you have bought, not the price on the last invoice. Three rules keep it honest:
- Receiving stock blends the new cost into the average — it never overwrites it.
- A sale freezes the cost of its lines at the moment of sale.
- Stock that comes back returns at the cost it left at.
Receiving blends the cost
When goods arrive at a different cost from what is on the shelf:
| Parameter | Type | Required | Description |
|---|---|---|---|
On the shelf | 10 × 1,000 | Optional | Ten units held at a cost of 1,000 each — 10,000 of stock. |
Received | 10 × 1,200 | Optional | Ten more arrive at 1,200 each — 12,000. |
After | 20 × 1,100 | Optional | Twenty units worth 22,000, so the cost becomes 1,100. |
A receipt line can be told to treat the cost differently — typed by hand, or left alone — and customs or transport can be added on top. See Landed Costs & Cost Mode.
A sold line keeps its cost
When a sale is made, each line is stamped with the product's cost at that moment. For a sales order the stamp happens at completion, because that is when the stock moves; a draft carries no cost yet.
Stock coming back
| Parameter | Type | Required | Description |
|---|---|---|---|
Sale voided | cost it left at | Optional | The units come back at the cost stamped on the sale line. |
Order voided | cost it left at | Optional | The same, for a completed sales order. |
Customer return | cost it left at | Optional | Returned units come back at the cost of the line they are returned against. |
Invoice edited | by difference | Optional | Units taken off come back at the cost they left at; extra units leave at today's average. |
Using today's average instead would make a movement and its reversal disagree, and stock value would drift with every void.
Damaged stock
A damage write-off values the lost units at the product's current average cost. Inventory falls by quantity × average and the loss booked is the same number. The loss appears in profit and loss, but it is not cash going out — the stock left, not the money.
What reads which cost
| Parameter | Type | Required | Description |
|---|---|---|---|
Cost of goods sold, profit | frozen | Optional | The cost stamped on each sold line. |
Stock value, inventory value | live | Optional | Today's average cost of what you still own. |
Below-cost price check | live | Optional | A typed price is compared with today's cost. |
Who can see cost
Cost prices and profit are hidden from a staff member unless the owner leaves See purchase price & profit switched on for them. Without it the cost columns disappear, and a refused below-cost price does not reveal the cost.
Cost history
Related
- Receiving Goods — where the average moves.
- Landed Costs & Cost Mode — customs, transport and hand-typed costs.
- Profit & Loss — where the frozen costs are read.