The inventory price is based on your unit of measure
The price at which goods are added to inventory is calculated as follows:
inventory price = unit price on the invoice line ÷ Quantity per unit of the goods
Quantity per unit is the field on the product card, under Inventory - Stock, next to the UOM field.
Two examples, in both directions:
You buy a case of 24 pieces for 120 lei per case, and the product has Quantity per unit = 24: the goods are added to inventory at 120 ÷ 24 = 5 lei per piece. This is correct.
You buy the product by the piece for 4.68 lei, but the product is managed in KG and has Quantity per unit = 0.55: the goods are added to inventory at 4.68 ÷ 0.55 = 8.51 lei per KG. This is also correct.
The quantity moves symmetrically, using the same factor: the quantity on the invoice multiplied by Quantity per unit is the quantity added to stock.
If the same invoice line is received both as a finished good and as a raw material, and the raw material is managed in a different unit from the finished good — milliliters vs. liters, grams vs. kilograms — the price is divided by 1,000 one more time (and, conversely, multiplied by 1,000 when converting from ML to L or from G to KG).
For example, a 1 L bottle received against a raw material managed in ML is therefore added at the price divided by 1,000.
The printed GRN (Goods Receipt Note) shows the price based on the invoice, meaning the inventory price multiplied back by Quantity per unit.
Inventory - History and the Average Purchase Cost column in Inventory - Stock show the price per your inventory unit of measure.
This is why the GRN matches the invoice, while History may appear not to: they represent the same amount of money, expressed in different units.
The unit price on the invoice line is excluding VAT and before the line discount.
The actual price at which the goods are added to inventory is the unit price minus the line discount.
A fixed-value discount is also converted to your inventory unit by dividing it by Quantity per unit. A percentage discount remains unchanged.
If you look at the VAT-inclusive total on the invoice, you are comparing different figures.
How to check it in 5 steps?
Take one invoice and one product from that invoice. Do not try to check the entire batch at once.
Open the product under Inventory - Stock and note its UOM and Quantity per unit.
Go to Inventory - History and find the Receipt movement for that product. Search by the product name, rather than by a date range around the invoice date: the movement is recorded using the receipt date from the GRN, not the invoice issue date, and the two dates can be weeks or even months apart.
Multiply the price shown on the movement by Quantity per unit (and by 1,000 if the raw material is managed in ML or G while the product is managed in L or KG).
Compare the result with the unit price on the invoice line, excluding VAT and after the discount. If they match, the import is correct and there is nothing to correct.
If the figures do not match:
You cannot find a Receipt movement for that product at all:
The problem is not the price, but the fact that the line was never added to inventory — either the GRN was not generated, or the invoice line was not linked to a product.
See the “I created the GRN, but the product does not appear in stock” section of the “Creating a Goods Receipt Note” article.
The error is on the invoice line itself — the supplier invoiced a different price or quantity, or did not apply the discount:
The correction must be made on the invoice.
An invoice imported from S.P.V. is read-only, so you must copy it, correct the copy, generate the GRN for the copy, and only then delete the original.
The steps are described in the “Adding invoices to Costs” article, under “Correcting an invoice imported from S.P.V. — copy the invoice.”
The invoice line is correct, but the recorded price is still different after conversion:
Do not recreate the documents.
Contact us via chat and provide:
the invoice number;
the product name;
the price on the invoice line; and
the price on the Receipt movement.
We will check it for you.
Do not copy or recreate invoices before checking the above.
Tags: [inventory price differs from invoice, invoice imported incorrectly from SPV, incorrect SPV import, product added at a different price, GRN price does not match supplier price, incorrect average purchase cost, case price per piece, quantity per unit price, movement history price]