The Transaction Enquiry is a comprehensive reporting tool that provides detailed insights into your inventory movements. This report breaks down every stock transaction on a per-product basis, showing exactly how your inventory levels and values have changed over time. For each transaction, you can see the quantity of units moved and the corresponding stock value adjustments. The report focuses on completed transactions only; open or pending transactions are excluded from the results.
Navigate to the Transaction Enquiry from your main menu by selecting Reports > Inventory > Transaction Enquiry.
Click Run to review all product transactions that have been completed in your account or use filters to refine your view. And use the Export dropdown to download your report in PDF, CSV, or XLSX format, depending on your needs.
📌 Note: Never Diminishing Products (NDPs) won't appear in the Transaction Enquiry since they don't manage stock quantities or have average landed costs. And batch and serial number details are not available within this report.
Filter your Transaction Enquiry
The Transaction Enquiry offers comprehensive filtering capabilities to help you focus on specific data.
Transaction Enquiry filters | Description |
Date From | Use the date selector to filter for transactions that were completed on or after the date selected. |
Date To | Use the date selector to filter for transactions that were completed on or before the date selected. |
Transaction Type | Use the drop-down menu to filter by a specific transaction type:
|
Product Code | Filter for transactions by a specific product code. |
Product Description | Filter for transactions by a specific product description. |
Warehouse | Use the multi-select drop-down menu to filter for transactions in the selected warehouses. |
Reference | Filter for transactions by their Customer or Supplier Reference. The filter supports a partial match. |
Understanding the Transaction Enquiry
The Transaction Enquiry provides an overview, per product, of the transactions that have been created in your account. The detail that's displayed per row in the report is dependent on the columns that are on the grid. By default, the following columns will populate in the Transaction Enquiry's grid.
Transaction Enquiry grid columns | Description |
Transaction Date | Displays the date the transaction was completed and the product's inventory updated. |
Transaction Ref | Displays the transaction's unique reference or order number. |
Warehouse | Displays the name of the warehouse the completed transaction was associated with. |
Transaction Type | Indicates what type of transaction was performed. |
Product Code | Displays the product's code. |
Product Description | Displays the product's description. |
Value | Displays the total stock value adjusted by the transaction for the product. |
Quantity | Displays the total number of units adjusted in your SOH by the transaction. |
Running Total | Displays the number of units that remained in your SOH after the transaction was completed. |
Hidden Columns
Additionally, the Hidden Columns list in the Transaction Enquiry's Show Toolbar tab lists more columns that you can drag and drop to the main grid. The default Hidden Columns are described in the table below.
📌Note: Only the headers already displayed in the layout or the Hidden Columns list can be displayed in the Transaction Enquiry.
Transaction Enquiry's hidden columns | Description |
Customer Code | When the transaction type is a Sales Shipment, the unique code of the customer the shipment was dispatched to will be displayed. |
Customer Name | When the transaction type is a Sales Shipment, the unique name of the customer the shipment was dispatched to will be displayed. |
Product Group | Displays the Product Group the product is assigned. |
Status | Displays the status of the transaction, either Completed, Receipted (Purchase Orders), or Dispatched (Sales Shipments). |
Transaction Enquiry totals
After running your report, the footer displays two total values:
Total Count: Number of transactions shown in current results.
Total Value: Sum of all transaction stock values in current results.
Customising your view
Drag any column header into the grey area above the grid to group your data by that field. Add multiple grouping levels and use the +/- icons to expand or collapse sections. This is particularly useful for analyzing data by supplier, product group, or period.
Reorder columns by dragging headers, resize columns by dragging borders, and sort data by clicking column headers - first click for descending order, second click for ascending order.
To add a Hidden Column to the Transaction Enquiry's grid:
Go to Reports > Inventory > Transaction Enquiry.
Click Show Toolbar.
Click Hidden Columns.
Drag a column header from the Hidden Columns list and drop it into the grid.
To remove a Hidden Column from the Transaction Enquiry's grid:
Go to Reports > Inventory > Transaction Enquiry.
Click Show Toolbar.
Click Hidden Columns.
Drag a column header from the grid into the Hidden Columns list.
Grid Layouts
After customising your column layout, save it for future use:
Click on the Show Toolbar tab.
Select New.
Enter a unique name for the new layout.
Click Add.
The layout will now be saved to your user profile, only available to select from the Show Toolbar's Grid Layout drop-down menu.
Edits can be made to your custom grid layout at any time; just click Save in the Show Toolbar options after you've made the necessary adjustments. Similarly, custom grid layouts can be removed by clicking Delete in the Show Toolbar tab.
Default grid layouts
Initially, whenever you navigate to the Transaction Enquiry, the default grid layout "None" will be displayed.
To make one of your custom grid layouts the default view:
Click on the Show Toolbar tab.
Select the layout from the Grid Layout drop-down menu
Tick the Default checkbox.
Click Save.
🤓 Tip: The Transaction tab in product records will replicate your default grid layout selected in the Transaction Enquiry.
Share grid layouts
If you've created a grid layout that other users in your account would benefit from using, you can make it available to their user profiles too:
Click on the Show Toolbar tab.
Select the layout from the Grid Layout drop-down menu
Tick the Shared checkbox.
Click Save.
The layout will then be available to select from the Show Toolbar > Grid Layout menu when other users open the Transaction Enquiry page.
Shared layouts cannot be a default for another user's profile, but they can save the shared layout as a new layout in their own profile, then set that as their default. Any edits you make to your shared layout will not apply to their saved default version.