Select Page

Items not in Use in Operations

The Items not in Use in Operations Report answers which items no document of a chosen type has used in a period, for example the items that did not sell in the last three months, with their stock now and their prices. Open it from Reports → Items → Items not in Use in Operations….

Filter

The Items not in Use in Operations 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.

Items not in Use in Operations Report filter window with Date, the item and location filters, Quantity, Operation, Sort by and the OK, Cancel and Clear buttons

The check box in front of a filter puts its column in the result. A cleared check box also adds the rows up over that column: Location: is cleared by default, so an item has one row for all locations where it was not used, or one row for each location group while Location group: is selected. A filter without a check box always has 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 in which the item was not used. Choose a period from the list, or Custom Dates and a start and an end date. Without dates the report lists the items without any such document. No column
Item code: The items by code. Shown
Item name: The items by name. Always shown, no check box
Barcode:, Catalogue: The items by barcode or catalogue number. Each adds three columns. Shown while Show barcodes or Show catalog numbers is selected in the item window
Item group: The items of a group. Shown
Item tag:, Location tag: Listed when such tags exist. They only filter. No column
Location: The locations. Not shown
Location group: The locations of a group. Shown
Quantity: The rows by the quantity in stock now, for example more than 0 for the unused items you still have. Always shown, no check box
Operation: The type of the documents. All looks at the documents of every type. Transfer looks at the transfers in both directions and Production at the ingredients and the products. No column
Sort by: Sorts by Code, Item, Location or Quantity, ascending or descending. –

Results

The result opens in its own tab. The example below has Sale in Operation:, the last ten days in Date: and one location in Location:, so it lists the items not sold there in these days. Barcode:, Catalogue: and Location group: are cleared.

Items not in Use in Operations Report results with the Code, Item, Item Group, Cost, retail price, Quantity and Measure columns and the Close, Document, Export, Totals, View, Filter, Actions and Refresh buttons
Column What it shows
Code, Item, Barcode 1 to 3, Catalogue 1 to 3, Item Group, Measure The item, as it is now in Items. Quantities are in this Measure.
Location, Location Group The location where the item was not used.
Cost The purchase price of the item now.
Retail price The item’s retail price now, under the name the price group has in your program.
Quantity The quantity in stock now in these locations.

How the numbers are counted

  • An item is listed for a location when no saved document of the chosen type and period has the item in that location. Drafts and documents still pending in another database do not count as a use. An annulled document no longer exists, so it does not count either.
  • A document counts on its Date, the date of the document, not on the day it was saved or edited.
  • The report reads the stock records of the items. With Average price, Average price per location or Last purchase price in Item management: (Tools → Settings… → Operations), an item has a record in every location from the moment it is created, so the items that were never used are listed too. With the other methods an item gets a record in a location with its first document there.
  • Deleted items are left out. The prices are those of the items now.

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 quantity 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 a row or use Actions → Edit to open its item. Actions → Transform Selected Items puts the selected items in a new document (see Transform Document). Actions → Print Selected Items prints their labels when a quick print setup of Print Barcodes exists.

Permissions

All permissions are set in Edit → Administration → Permissions….

Permission What it allows Not allowed by default for
Reports → Items → Items not in Use in Operations… The report. Operators (the whole Reports menu)

A user with a Locked location: in the user’s settings gets that location fixed in the filter. With Show items available quantity cleared there, the user does not see Quantity, and with Show items purchase price cleared not Cost.

FAQ

Why is an item listed that was sold?

With Location: cleared, an item is listed when it was not used in at least one location, and Quantity is its stock in those locations. Choose a location in Location:, or select Location: to see each location on its own row.

How do I find the items that did not sell for three months but are still in stock?

Choose Sale in Operation:, the last three months in Date: and more than 0 in Quantity:.

How do I see how much of each item was used?

Use Items Use in Operations with the same filter.

Documentation