The Deleted Items in Sales Report answers what was taken off sales and restaurant orders: each time a row is deleted, its quantity lowered or the whole sale or order cancelled, the program keeps a record of the item, the quantity, who did it and why. The report lists these records. Open it from Reports → Items → Deleted Items in Sales….
Filter
The Deleted Items in Sales 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 record, 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 |
|---|---|---|
| Operation No.: | The numbers of the sales and orders, from one number to another. | Shown |
| Last modification: | The period, by the date and time the record was saved. Choose a period from the list, or Custom Dates and a start and an end date. | Shown |
| Item code: | The items by code. | No column |
| Item name: | The items. | Always shown, no check box |
| Barcode:, Catalogue: | The items by barcode or catalogue number. Each adds three columns. | Shown when the item window shows barcodes and catalogue numbers |
| Item group: | The items of a group. | Shown |
| Location:, Location group: | Where the sale or order was made. | Shown |
| User:, User group: | The user of the sale or order. | Shown |
| Logged in user:, Logged in user group: | The user who was logged in when the record was saved. | Shown |
| Item tag:, Location tag:, User tag:, Logged in user tag: | Listed when such tags exist. They only filter. | No column |
| Deletion reason: | The reasons to include. All are selected except Hardware error. | Not shown |
| Sort by: | Sorts by Operation No., Last Modification, the deletion reason, Item, Quantity or Total Sale Amount, ascending or descending. | – |
Results
The result opens in its own tab. The example below shows a sale in which the cashier lowered the quantity of one row and deleted another row before saving it. It has today in Last modification: and one location in Location:, Deletion reason: selected, and Barcode:, Catalogue:, Item group:, Location group:, User group: and Logged in user group: cleared.

| Column | What it shows |
|---|---|
| Operation | Deleted Sale for a sale, Deleted Restaurant Order for a restaurant order. |
| Operation No. | The number of the sale or order. |
| Last Modification | The date and time the record was saved. |
| Item, Barcode 1 to 3, Catalogue 1 to 3, Item Group | The item, as it is now in Items. |
| Location, Location Group | The location of the sale or order. |
| User, User Group | The user of the sale or order. |
| Logged In User, Logged In User Group | The user who was logged in when the record was saved. |
| Quantity, Measure | The quantity taken off, in the measure of the row. |
| Total Sale Amount | The quantity taken off at the sale price of the row, after its discount and with VAT. |
| Deletion Reason | Why the quantity was taken off (see the next table). |
| Deletion reason | What happened |
|---|---|
| Corrected before saving, Corrected | The quantity of a row was lowered, before the sale or order was first saved or after it. Quantity is the part taken off. |
| Item removed before saving, Item removed | A row was deleted, before the sale or order was first saved or after it. An annulled sale records all its rows as Item removed. |
| Operation cancelled before saving, Operation cancelled | The whole sale or order was cancelled, before it was first saved or after it. |
| Hardware error | The sale or order was taken back because a device, such as the fiscal printer, failed while it was saved. |
| Pending operation voided | A pending sale or order that could not be saved was voided. |
| Unspecified | A record saved before the program kept the reason. |
How the numbers are counted
- The report lists the records of the taken-off quantities, not the sales. A record does not change the stock, and the sales reports do not count it.
- Only sales and restaurant orders keep such records. Other documents, such as purchases or consignment sales, are not in the report.
- A record counts on its Last Modification, the moment it was saved, not on the date of the sale.
- Amounts are in the main currency of the program. Item, location and user names are the current ones.
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 Quantity and Total Sale Amount. 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.
The rows are records, not documents, so double-click does not open them. Select one Deleted Sale row and use Actions → Show Changes History to see the earlier versions of the rows of that sale (see Edit Sales).
Permissions
All permissions are set in Edit → Administration → Permissions….
| Permission | What it allows | Not allowed by default for |
|---|---|---|
| Reports → Items → Deleted Items in Sales… | The report. | Operators (the whole Reports menu) |
| Manage operators and view their operations | The records of all users. Without it User: and Logged in user: are fixed to your name. | Operators |
A user with a Locked location: in the user’s settings gets that location fixed in the filter.
FAQ
How do I see what was taken off sales that were already saved?
In Deletion reason: keep only Corrected, Item removed and Operation cancelled. Choose a cashier in User: to see only their sales.
Why are the rows of a sale that the fiscal printer refused not listed?
Hardware error is not selected by default. Select it in Deletion reason:.
Why does one sale have several rows?
Each lowered quantity, deleted row or cancellation makes its own record, so one sale or order can have a row for every change.