The Items Prices History Report answers when and how the prices of an item changed: each change of a purchase price or a sale price, with the old and the new price, the document that changed it and the user. Open it from Reports → Items → Items Prices History….
Filter
The Items Prices History Report window opens first. Fill in only the filters you need: an empty filter does not limit the report. Click OK to run the report. Clear empties the filters and sets the check boxes back to their default. The window keeps the last filter you ran.

The check box in front of a filter puts its column in the result. A filter without a check box always has its column. Each row is one price change, so a cleared check box only hides its column. A text filter finds the values that contain the text. Press F4 or click … to choose from a list.
| Filter | What it limits | Column by default |
|---|---|---|
| Date: | The period, by the date and time of the change. Choose a period from the list, or Custom Dates and a start and an end date. | Shown (Date/Time) |
| Item code: | The items by code. | Shown |
| Item name: | The items. | Always shown, no check box |
| Barcode:, Catalogue: | The items by barcode or catalogue number. Each adds three columns. | Not shown |
| Item group: | The items of a group. | Not shown |
| User name: | The user who changed the price. | Shown |
| User group: | The users of a group. | Not shown |
| Item tag:, User tag: | Listed when such tags exist. They only filter. | No column |
| Price group: | One price, or All. | Always shown, no check box |
| Item old price:, Item new price:, Price change %: | The rows by the old price, the new price or the change in percent. | Always shown, no check box |
| Operation: | The changes made by one type of document. | Always shown, no check box |
| Sort by: | Sorts by Date/Time, Date, Code, Item or User, ascending or descending. | – |
Results
The result opens in its own tab. The example below has today in Date:: three items got a new retail price in the item window and three others a higher purchase price with a purchase. Measure is hidden with View.

| Column | What it shows |
|---|---|
| Date/Time | When the price changed. |
| Code, Barcode 1 to 3, Catalogue 1 to 3, Item, Item Group, Measure | The item, as it is now in Items. The prices are for this Measure. |
| Price Group | The price that changed: Purchase Price, Wholesale price, Retail price or one of the price groups, under the names they have in your program. |
| Item Old Price, Item New Price | The price before and after the change. |
| Price Change % | (Item New Price − Item Old Price) / Item Old Price × 100. It is 100 when the old price was 0. |
| Operation, Operation No. | The document that changed the price. Both are empty for a change without a document. |
| Date | The date of that document, or the day of a change without a document. |
| User, User Group | The user who was logged in when the price changed. |
How the numbers are counted
- The program adds a row each time it saves a different price for an item, one row for each price that changed:
- saving the item in the item window or with Edit → Administration → Change Prices… records the sale prices. A purchase price changed there is not recorded;
- a purchase records the new purchase price of the item, and the sale price when a row of the purchase changes it;
- a stock-taking, a price change document and the other documents that set an item price record that price;
- Edit → Administration → Recalculate Purchase Prices… records the recalculated purchase prices, without a document.
- A save with the same price adds no row.
- The prices are the item prices as the program keeps them, in the main currency, with VAT when Use prices with included VAT in Tools → Settings… → Special is on.
- The rows stay when the document is edited or annulled later, and deleted items keep their rows.
Work with the results
Document opens the print preview of the result with its filters, and Export saves it to a file. Totals adds a row with the totals of the number columns. View shows the result as bars or a pie (see View Report Results). Filter → Report Filter shows the filters next to the result and runs it again as you change them, Report Filter as New… opens the result of another filter in a new tab, and Quick Filter searches the text of the rows. Refresh runs the report again. The report can also be a panel of the Dashboard.
Double-click does not open the rows. Actions → Transform Selected Items puts the items of the selected rows in a new document (see Transform Document). Actions → Print Selected Items prints their labels when a quick print setup of Print Barcodes exists, for example after new prices.
Permissions
All permissions are set in Edit → Administration → Permissions….
| Permission | What it allows | Not allowed by default for |
|---|---|---|
| Reports → Items → Items Prices History… | The report. | Operators (the whole Reports menu) |
| Manage operators and view their operations | The changes of all users. Without it User name: is fixed to your name. | Operators |
A user without Show items purchase price in the user’s settings has no Purchase Price in Price group: and gets no purchase price rows.
FAQ
Why do I see a purchase price change I did not make?
With average purchase prices, every purchase at another price changes the average, so each such purchase adds a Purchase Price row. Choose a sale price in Price group: to see only the sale price changes.
How do I see the price history of one item?
Enter the item in Item name: and leave Date: empty. Sort by: Date/Time puts the changes in order.
Why is a change I made in the item window missing?
The item window records only the sale prices. A purchase price typed there does not add a row.