Inventory Reports - Transactions

Overview

Inventory – Transactions lists all the transactions that affected inventory quantities. This report can be used to determine the source of inventory changes.

Navigation Example

Main Menu > Procurement > Inventory > Menu (button) > Transactions

Buttons Explained

Button Description
ViewGenerates an Inventory Transaction Report based on the selected filters.
OutputAvailable upon request.
MenuSee the Menu button described under Inventory Reports Settings.

Filters Explained

Filter Description
DateYou can select a date option from the dropdown list. Depending on the chosen option, Start and End Dates for the report can be set in the provided blocks.
⬅ ➡Adjusts the date field depending on the option chosen next to Date.
CustomerA dropdown list of customers allowing you to view All or a specific Customer.
CategoryA dropdown list of categories allowing you to view All or a specific Category.

Fields Explained

Field Description
Field Chooser (*)Add or remove columns.
StatusThe Status of the original transaction.
TransA code indicating the Transaction Type (e.g. SO for Sales Order).
No.The source document's number or a system-generated number for the source transaction.
FromAn abbreviation indicating the source document, and number, that the transaction was created from.
DateThe Date of the original transaction.
CompanyThe name of the Customer involved in the transaction.
ReferenceThe Reference field on the transaction.
CustomerThe name of the Customer that is linked to the inventory item.
CategoryThe inventory item's Category.
SubcategoryThe inventory item's Subcategory.
DescriptionA description of the inventory item.
CodeThe inventory item's Code.
ResolveThe action taken when the transaction was completed (e.g. issue, reserve).
LocationThe Location of the inventory item.
IDThe overall system-generated number.
TransIDThe system-generated number for the transaction.
QtyThe Quantity that is currently In Stock.
UnitAn abbreviation describing the item's Unit.
Unit PriceThe Unit Price of the inventory item.
TotalThe Total value of the transaction.
Menu (...)A submenu that can also be accessed by right-clicking an item:
  • Open Transaction: Opens the original transaction.
  • Open Stock Checks: Opens any stock check transactions created for that item.
  • Open Item: Opens the item's setup page.
  • View Item Summary: Displays a summary of the item's activity.

Report an issue with this page

For more useful feedback, select the text on the page you're reporting about, then click Feedback again — or continue without selecting anything.