Search our Help.

  1. Unleashed Support
  2. Reporting
  3. Inventory

Transaction Enquiry

Follow

The Transaction Enquiry is a report used to display a per transaction breakdown of the stock movements that have been processed in Unleashed, per product. The report details the quantity of units and respective stock value that was adjusted in your stock on hand for each completed, dispatched or receipted transaction, (open transactions are excluded) based on the filters specified.

Points to note

  • Any transaction processed that has caused a product's stock on hand (SOH) or average landed cost (ALC) to change will be included in the Transaction Enquiry.
  • If you create a custom grid layout in the Transaction Enquiry and save it as a Default Grid Layout, the layout will apply to the Transactions tab in each product's record. For more details, see How to Create Default Grid Layouts.
  • Never Diminishing Products (NDP's) will not populate in the Transactions Enquiry as they do not manage stock quantities nor have an average landed cost. 

Functional descriptions

To use the Transaction Enquiry, from the main menu, go to Reports, Inventory and select Transaction Enquiry.

Header button descriptions

In the top right corner of the Transaction Enquiry, there are two header buttons available:

  • Export: Use the dropdown menu to export the report in either a PDF, CSV or XSLX format.
  • Run: Use the Run button to generate the report with any selected filters applied.

Filter field descriptions

Use the filter fields available to refine which transactions the Transaction Enquiry report displays. The filter fields available to the Transaction Enquiry are:

  • Date From: Select a date in the field's calendar.
  • Date To: Select a date in the field's calendar.
  • Transaction Type: Use the dropdown menu to filter the report by a specific transaction type:
    • Sales Shipment
    • Purchase Order: When stock is receipted.
    • Purchase Order Recost: When receipted stock has additional costs added after the Receipt Date. 
    • Recost Adjustment: When additional cost is added to receipted stock that has already shipped.
    • Credit
    • Stock Adjustment
    • Stock Take Adjustment
    • Stock Import
    • Warehouse Transfer
    • Assembly In: Displays for the assembled product's incoming quantity and value.
    • Assembly Out: Displays for the component product's outgoing quantity and value.
    • Assembly By-Product In: Displays for the by-product's incoming quantity and value.
    • Disassembly In: Displays for the component product's incoming quantity and value. 
    • Disassembly Out: Displays for the assembled product's outgoing quantity and value.
    • Supplier Return
  • Product Code: Filter by a specific product by code.
  • Product Description: Filter by a product description (will auto-populate if the Product Code filter is used).
  • Warehouse: Use the multi-select dropdown menu to filter the report by warehouse.
  • Reference: Use the free text field to filter all transactions by their Customer or Supplier Reference. The field works as a partial match and will populate any transactions that contain the filtered text. 

Grid column descriptions

By default, the following columns will populate in the Transaction Enquiry's grid:

  • Transaction Date: Displays the date the transaction was processed (completed, dispatched or receipted).
  • Transaction Ref: Displays the transaction's reference number as a quick link, which will redirect you to the transaction's page.
  • Warehouse: Displays the name of the warehouse allocated to the transaction.
  • Transaction Type: Displays the type of transaction, e.g. Sales Shipment or Stock Adjustment. 
  • Product Code: Displays the product's code as a quick link, which will redirect you to the transaction's page.
  • Products Description: Displays the product's description as a quick link, which will redirect you to the transaction's page.
  • Value: Displays the sum total value adjusted for the product, in the given transaction. 
  • Quantity: Displays the total unit quantity adjusted for the product, in the given transaction.
  • Running Total: Displays the total SOH remaining for the product in the given warehouse, after the transaction was processed. 

Hidden Columns

Using the Hidden Columns button you can choose which columns are shown on the grid and where. To add or remove a column, simply drag and drop the columns you like to and from the Hidden columns box.

The following column headers are also available to include on your Transaction Enquiry and can be found in Show Toolbar, Hidden Columns:

  • Customer Code
  • Customer Name
  • Product Group
  • Status (transaction status)

Footer descriptions

After the Transaction Enquiry has been run and populated results, the following values are displayed at the bottom of the page:

  • Total Count: Displays the total number of transactions populated.
  • Total Value: Displays the sum total value of the transactions populated. 

Using the custom grids

Depending on what sort of information you require, you can enter the relevant criteria and then click Run at the top on the banner. Using the toolbar above the grid, you can manipulate how the filtered information is displayed in the grid as follows:

  • Group By Column(s): To group by a desired column, simply drag and drop the column header it into the grey tile space above the grid's header row. As soon as you drop it the grid the enquiry page will group all results by the dropped column's values. You can group by as many columns as you like and expand all or collapse all the groups using the plus or minus icons shown on the left of the grid.
  • Customize Columns Shown: Using the Hidden Columns button you can choose what columns are shown on the grid and where. Drag and drop a column across the grid's headers to re-arrange their order and position in the grid. Similarly, adjust a column's size by dragging it's side to the desired width.
  • Sort by column: Click on a column's header to sort the report by that field. Click the header once to sort into descending order and click again to sort into ascending.  

 

Was this article helpful?
0 out of 0 found this helpful