INV03 — Item Transactions

Operational Reports > Inventory

Who would use this report?

Warehouse, purchasing, and sales staff

What is in this report?

inv03Selected transactions sorted by item, warehouse or batch reference within selected date range, for reconciliation, investigation, and data verification.

How do I use it?

Sort options:

Group & Sort bygroupIn security, a list of users or other groups that can be used to assign access permissions and capabilities. Groups can be referenced from other authentication sources or can be local to Pronto Xi Business Intelligence. Local groups are managed from BI Administration. The list of groups that an authentication user is a member of is part of the user's passport for an Pronto Xi Business Intelligence session. In reporting, grouping is the action of organising common values of query item together and only displaying the value once. Headers and footers often appear after each instance of a common value in a grouped column and sortArrange elements of a list in a certain order. The most-used orders are numerical order and lexicographical order. by item code, warehouse, or batch reference.

FiltersSelectively remove data from view. include:

  • Item Code — search by item code, item keyword or the item code or item code range
  • Batch Reference — search by batch reference code, batch reference keyword, or batch reference range

  • Transaction Date Selection — for the transaction date, select the period

Other filters include Warehouse, Product Group, and Transaction Type.

What can I do in the report?

You can group and sort by item code, warehouse, or batch reference.

You can filter by Transaction Date Selection and Transaction Type.

The Cost value includes cost adjustment transactions.

Right-click any of the drill-down links and select Open link in new tab to viewA set of data connected to a cube, deliberately laid out to communicate business information. the data in Pronto Xi.