Select Page

Production by Items

The Production by Items Report answers how much of each item your productions used and made. It sums the quantity and the cost of the production rows that match the filter, one row per item, and keeps the ingredients apart from the products. Open it from Reports → Production → Production by Items….

Filter

The Production by Items 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.

Production by Items Report filter window with Date, the item filters, Operation, Detail note, the location and user filters, 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: Date: and Location: are cleared by default, so an item has one row for all days and locations. 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 of the production. Choose a period from the list, or Custom Dates and a start and an end date. Without dates the report covers all productions. Not shown
Item code:, Item name: The ingredients and products. Shown
Barcode:, Catalogue: The items by barcode or catalogue number. Each adds three columns. Not shown
Item group: The items of a group. Not shown
Operation: All, Production Ingredient for the used items or Production Product for the made items. Shown
Detail note: The rows by their note. An automatic production writes Automatic production of item “…” with the name of the sold item in its rows. Shown
Lot:, Serial number:, Production date:, Expiration date:, Lot location: Listed when you work with lots. A shown lot column splits the rows by lot. Not shown
Location:, Location group: Where the production was made. Not shown
User:, User group: The user in the User field of the production. Not shown
Item tag:, Location tag:, User tag: Listed when such tags exist. They only filter. No column
Sort by: Sorts by Item, Code, Operation, Detail Note, Date, Location or User, ascending or descending. It sorts only by a column that is shown. –

Results

The result opens in its own tab. The example below has the default check boxes, so each ingredient and each product has one row for all productions.

Production by Items Report results with the Code, Item, Operation, Detail Note, Total Qtty and Amount columns, the ingredients and the products on separate rows, and the Close, Document, Export, Totals, View, Filter, Actions and Refresh buttons
Column What it shows
Date The date of the productions on the row.
Code, Item, Barcode 1 to 3, Catalogue 1 to 3, Item Group The item, as it is now in Items.
Location, Location Group, User, User Group Where and by whom the productions were made.
Operation Production Ingredient or Production Product.
Detail Note The note of the production rows.
Total Qtty The quantity used or made, in the item’s Measure:.
Amount The sum of quantity × purchase price: for an ingredient its purchase price in the production, for a product its cost, the cost of the ingredients shared among the products.

How the numbers are counted

  • The report counts the saved productions of Production, also the ones made by Auto production in Tools → Settings… → Operations when an item with a recipe is sold. Drafts and productions still pending in another database are left out. An annulled production no longer exists, so it is not counted.
  • The quantities are not signed: a used and a made quantity are both positive. With Operation: cleared, an item that is both made and used, for example a sauce made in one production and used in another, gets one row with both quantities added together. Keep Operation: selected, or choose one type in it, to see them apart.
  • A production counts on its Date, the date of the document.
  • Amount is in purchase prices, in the main currency of the program. The report has no sale prices and no VAT column.
  • Item names, codes and groups come from the items as they are 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 Total Qtty and Amount; with both types in the result the total adds the ingredients and the products. 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. To open a production itself, use the Production report.

Permissions

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

Permission What it allows Not allowed by default for
Reports → Production → Production by Items… The report. Operators (the whole Reports menu)
Manage operators and view their operations The productions of all users. Without it User: is fixed to your name. Operators

A user with a Locked location: in the user’s settings gets that location fixed in the filter. A user without Show items purchase price there does not see Amount.

FAQ

Why is an item on several rows?

The rows differ in a shown column: an item can be an ingredient and a product, or its rows can have different notes, for example one note for each sold item that an automatic production made it for. Clear Detail note: to add the notes together.

How do I see what the automatic productions used for one product?

Type the name of the sold item in Detail note: and choose Production Ingredient in Operation:.

How do I see how much was produced each day?

Select the check box of Date: and choose Production Product in Operation:. Each day gets its own row for each product.

Documentation