Both numbers look like "the cost", and they sit near each other on an item's page. They answer different questions.
Number | Answers |
Purchase price | What will my vendor charge me for the next one? |
Average cost (MAC) | What did the stock in my warehouse cost me? |
Purchase price: what you'll pay next
You set it yourself, on the item's Pricing & Vendors tab, in two places:
Pricing by UOM, under Buy prices: one box per buy price list, for each unit you buy in. Your primary vendor's price comes from here, from the vendor's own price list.
Vendors: a Price for each vendor who isn't your primary vendor.
A primary vendor shows $ 0.00 in the Vendors table. That's expected: its price is the one on the price list. Link a product to a vendor explains primary vendors.
The purchase price stays what you set until you change it. A delivery that comes in at a different cost doesn't update the price on your price list or a vendor's Price.
Average cost: what you already paid
The average of what the units you hold cost you, worked out from every delivery and stock adjustment. It moves by itself each time stock comes in. You don't type it on a price list, but you can correct it if it's wrong. See What is average cost (MAC) and how is it calculated? and Correct an item's average cost (MAC).
Why they're usually different
Say your vendor now charges $9.00 for a spoon rest. That's the purchase price.
You hold 121 that came in over four deliveries, at $5.00, $30.00, $6.00 and $10.00. Together they average $5.70. That's the average cost.
Both are right: one is what the next one will cost, the other is what the ones on the shelf cost.
Which one is used where
Where | Uses |
A new purchase order line | For a vendor that isn't your primary vendor, its Price from the Vendors table |
The reorder report | A cost for each vendor: the price list for your primary vendor, the Price from the Vendors table for the others, and no cost if the price list has no price for the item |
Update MAC value based on Purchase Price (Bulk actions on the Inventory list) | Sets the average cost to the item's price on your Purchase price list |
The value of your stock on hand | Average cost |
The cost of goods sold when you ship a sale | Average cost |
Profit margin on a sales order | Average cost |
On a new purchase order, check the Unit cost on each line before you confirm it. If a line shows 0.00, type the price. Receiving stock at 0.00 pulls the item's average cost down.
The short version: purchase price is what you'll pay next, average cost is what you already paid. Anything about profit or stock value uses average cost.
