How to check and correct a price list: prices, currency, valid-until
Check a price list and correct anything the reader got wrong: a price, the stock, the currency, the expiry date, or a line it missed.
- Who can do this
- JuniorTeam leadProcurementAdmin
- Read first
- Video
- 2:01below the steps
In this guide
- 01Check the facts
- 02Correct a cell
- 03Stock, currency, valid until
- 04Remove, Undo, read again
Check the facts first
Open the list. The facts at the top show the lines read, the lines that price, how many need a look, and the date it is valid until. If some need a look, Show the N that need a look lists only those lines.
Correct a cell
- Search lines for the item or code, such as PTZ.
- Click the price cell, type the correct price, and press Enter. It says Saved. Esc cancels.
Item, code, category, unit, price, currency and lead time can all be changed the same way. Setting a real price on a line that needed a look lets it price again.
Stock
The In stock column is a switch. Click it to mark an item in stock or out of stock, and the message that follows has Undo. Out-of-stock items are never used for pricing.
Currency and rates
- Fix the currency cell if the reading got it wrong. Three letters, like AED or USD.
- Set the rate in Settings, under Currency rates. One rate per currency for the whole workspace, typed by hand with its date, and never looked up. Add a rate adds one, and Change updates it when it moves. A new rate far from the one your workspace set gets a warning, but still saves.
Valid until
If the vendor extends their quote, change the Valid until date at the top, or tick No expiry date, and click Save.
A line the reading missed
At the bottom, click Add a missing line. Fill in the item, code, category, unit, price, currency and lead time, and click Add line. The form stays open for the next one; Done adding closes it.
Remove a line
The ... button at the end of a line has Remove line. The message that follows has Undo, which puts the same line back as it was.
The wrong columns, on a spreadsheet
If a spreadsheet was read with prices or names in the wrong place, use Which column is which above the items.
- Click Choose the columns. It lists each column heading with a few of its values, and a first guess of what each one is.
- Set Use it as for each column: item name, code, description, unit price, unit, currency, lead time, minimum order, keep as a detail, or not used.
- Click Read with these columns. Every line is read again from your choice. A sheet laid out with different columns is left out, and named.
Your choice is remembered. Read again reads the list by the same columns, and Change the columns opens your choice to adjust it. To let TrueQty work the columns out again, tick Let TrueQty work out the columns in the Read again dialog.
Switch a list off
If a list is out of date, More, then Switch off, stops it pricing anything without deleting it. Switch on brings it back.
Watch it done
Open on YouTubeThe same steps, on the sample tender, in 2:01.
Finished this guide?
Mark it done to track your way through the Academy.
Follow along on your own tender. Every guide works the same on a real drawing.
Start free trial