Select Page

Items Flow by Date

The Items Flow by Date Report answers how the stock of each item changed day by day: for each day with movements, the stock at the start of the day, the quantities of each type of document and the stock at the end of the day, in each location. Open it from Reports → Items → Items Flow by Date….

Filter

The Items Flow by Date 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 Flow by Date Report filter window with Date, the item and location filters, Sort by and the OK, Cancel and Clear buttons

The check box in front of a filter puts its column in the result. In this report a cleared check box only hides the column: the rows stay apart by day, item and location. 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 days, by the date of the documents. Choose a period from the list, or Custom Dates and a start and an end date. Without a start date the report starts with the first document, without an end date it ends today. Always shown, no check box
Item code:, Item name: The items. Shown
Barcode:, Catalogue: The items by barcode or catalogue number. Each adds three columns. Not shown
Item group: The items of a group. Shown
Location:, Location group: The locations. Shown
Item tag:, Location tag: Listed when such tags exist. They only filter. No column
Lot:, Serial number:, Production date:, Expiration date:, Lot location: Listed when you work with lots. They limit the movement columns to the lot. A shown lot column splits the rows by lot. Not shown
Sort by: Sorts by Date, Code, Item or Location, ascending or descending. Without it the rows are by date. –

Results

The result opens in its own tab. The example below has one item in Item name: and one location in Location:, with Barcode:, Catalogue:, Item group:, Location: and Location group: cleared, so each row is a day. Measure and the columns of consignments, productions, notes and returns are hidden with View.

Items Flow by Date Report results for one item with the Date, Code, Item, Beginning Qtty, Purchase Qtty, Sale Qtty, Waste Qtty, Stock-taking Qtty, transfer, Written-off Qtty and Ending Qtty columns and the Close, Document, Export, Totals, View, Filter, Actions and Refresh buttons
Column What it shows
Date The day.
Code, Item, Barcode 1 to 3, Catalogue 1 to 3, Measure, Item Group The item, as it is now in Items. Quantities are in this Measure.
Location, Location Group The location.
Beginning Qtty The stock of the item in the location before that day.
Purchase Qtty, Sale Qtty, Waste Qtty, Written-off Qtty The quantities of the purchases, sales, wastes and write-offs of the day.
Stock-taking Qtty The corrections of the stock-takings: counted minus available, negative for a shortage.
Transfer to Location, Transfer from Location The quantities transferred into and out of the location.
Consigned Qtty, Consignment Sold Qtty, Consignment Returned Qtty The quantities given on consignment and returned. A consignment sale does not change the stock, so the report leaves it out and Consignment Sold Qtty stays 0.
Production Ingredient, Production Product The quantities used and made in productions.
Debit Note Qtty, Credit Note Qtty The quantities of debit and credit notes.
Returned Qtty, Returned to Supplier Qtty The quantities of returns from customers and purchase returns.
Ending Qtty The stock of the item in the location at the end of that day.

How the numbers are counted

  • The report counts saved documents that change the stock. Drafts, documents still pending in another database and documents that do not move the stock, such as orders and offers, are left out. An annulled document no longer exists, so it is not counted.
  • A document counts on its Date, the date of the document, not on the day it was saved or edited. A row is made only for a day with movements of the item in the location.
  • Beginning Qtty and Ending Qtty count all documents of the item in the location from the first one, also those before the period, and all lots together: the lot filters do not change them.
  • Items marked Non-inventory or service and deleted items are left out.

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.

The rows of this report do not open an item: double-click does nothing and Actions has no entries. To open an item, use Items Flow with the same filter.

Permissions

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

Permission What it allows Not allowed by default for
Reports → Items → Items Flow by Date… 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.

FAQ

Why are some days missing?

A day without documents of the item in the location has no row. The stock of such a day is the Ending Qtty of the day before it in the list.

Why do two rows look the same after I clear Location?

The rows stay apart by location, only the column is hidden. For one row of all locations use Items Flow or Items Accounting Flow.

Why are the rows of different items mixed?

The rows are by date. Choose Item in Sort by:, or one item in Item name:, to follow one item.

Documentation