1. Home
  2. Knowledge Base
  3. Transactions
  4. Transactions List View Tutorials

Transactions List View Tutorials

In BOS, transactions (e.g. Customer Invoices, Quotations, Supplier Invoices) have two interfaces. The first lists the transaction with details such as the Status, DateCustomer, or Supplier, and the transaction amounts. This is known as the List View. List View is further divided into two views: Items which lists every item on the transaction and Transactions which only lists the transaction totals. The second, known as Edit View, is where transactions are captured.

A transaction type must be added to a menu before transactions can be entered. Transaction types can be added to any menu. User access is set per transaction type.

These tutorials explain how to view and filter the different transaction lists.


How to Display a List of Transaction Entries

This view lists the transactions and includes information that is most relevant to that Transaction Type.

  1. Navigate to any Transaction.
    • Note: If your interface shows Edit, you are in Edit View. Click the arrow next to the word Edit to return to List View.
  2. Click Menu (button) > Transactions.
  3. Click View (button).

How to View a List of Transaction Items

This view provides more detailed information about the line items that are on the transactions.

  1. Navigate to any of the Transactions that you have created.
    • Note: If your interface shows Edit, you are in Edit View. Click the arrow next to the word Edit to return to List View
  2. Click Menu (button) > Items.
  3. Click View (button).

How to Filter a View by Date

  • When filtering by date, the arrows next to Set can be used to adjust the date forwards or backwards.
  • The dates work with the radio buttons as follows:
    • Date: Filters the list based on the transaction dates.
    • Updated: Filters the list based on when the transaction was last updated.
    • Required Date: Filters the list based on when the goods were required. This is a date that is filled in on the status bar. The caption on the status bar is user-defined and might not be required date.
  1. When viewing a List of Transactions or Transaction Items, click the arrow on View (button) and select one of these options:
    • Today: Changes the date to today.
    • This Month: Changes the date range to the current month.
  2. or select one of these options next to Set:
    1. No Date: Displays all the transactions.
    2. User Date: Allows you to type the From and To Dates.
    3. Today: Changes the date to today.
    4. This week: Changes the date range to the current week from Monday to Sunday.
    5. This month: Changes the date range to the current month.
    6. This year: Changes the date to the current calendar year.

How to Filter a View by Status

  • The built-in filters allow you to filter per Status Group. To filter using customised statuses, use the Soft Filter Icon next to the Status column header and select the custom filters there.
  • The Soft Filter Icon appears when you hover over the column’s caption.
  1. When viewing a list of Transactions or Transaction Items, click the arrow on View (button) and select one of these options:
    • Pending
    • Active
    • Pending & Active
  2. or select one or more of the Status checkboxes in the header. If no boxes are checked, all the statuses are included.
    • Pending
    • Active
    • Complete 
    • Cancelled

How to Filter a View by Customer or Supplier

  • The filter in the header allows you to filter the transactions to a single customer or supplier.
  • To view a report with several customers or suppliers, use the Soft Filter Icon next to the Company column header and select the customers or suppliers to include there.
  • The Soft Filter Icon appears when you hover over the column’s caption.
  1. When viewing a list of Transactions or Transaction Items:
    1. Next to Customer or Supplier in the header, select the Customer or Supplier you want to view from the dropdown list.
    2. Click View (button).

How to Filter a View by User

In this context, the user is the person who created or edited the transaction.

  1. When viewing a list of Transactions or Transaction Items:
    1. Next to User in the header, select the User you want to view from the dropdown list.
    2. Click View (button).

How to Filter a View by Entity

  • The built-in filters allow you to filter to a single registered Entity.
  • To view a report with several Entities, use the Soft Filter Icon next to the Entity column header and select the Entities to include there. This filter excludes other types of entities (e.g. locations or cost centres).
  • The Soft Filter Icon appears when you hover over the column’s caption.
  1. When viewing a list of Transactions or Transaction Items:
    1. Next to Entity in the header, select the Entity you want to view.
    2. Click View (button).

How to Filter a View by Rep

  • The built-in filters allow you to filter to a single Rep. To view a report with several Reps, use the Soft Filter Icon next to the Rep column header and select the Rep to include there. The Rep column is only available when viewing Transactions (not Items).
  • The Soft Filter Icon appears when you hover over the column’s caption.
  1. When viewing a list of Transactions:
    1. Next to Rep in the header, select the Rep you want to view.
    2. Click View (button).

How to Export the List of Transactions or Items 

  1. When viewing a list of Transactions or Transaction Items:
    1. Click Output (button) > Export (.xlsx).
    2. Navigate to the folder where you want to save the report.
    3. Click Save (button).

How to Copy Transactions

  1. Navigate to the applicable list of transactions.
  2. Right click the transaction you want to copy and select Copy to … from the context menu.
    • Note: The list of copy options depends on the Copy Rules setup for the transaction. 
  3. A popup lets you select the items, groups of items, and status options.
    • Note: If there are no items, the transaction has already been copied, or there are no qualifying items based on the copy rule.
  4. Click Copy (button). 
  5. If the Open New Transaction checkbox is checked (on the popup), you are transferred to the new transaction.

How to Copy Multiple Transactions

If you copy multiple transactions, you cannot select individual items. Transactions are copied as per the copy rules.

  1. Navigate to the applicable list of transactions.
  2. Select the transactions you want to copy.  (Use Ctrl + Left click to multi-select).
  3. Click Actions (button) > Copy to …
    • Note: The list of copy options depends on the Copy Rules setup for the transaction. 
  4. Click Yes (button) on the confirmation that you want to copy x number of transactions.
  5. A confirmation message displays the number of transactions successfully copied.
  6. You are returned to the list view of the transaction you were viewing.

How to Update Multiple Transactions

  1. Navigate to the applicable list of transactions.
  2. Select the transactions you want to copy.  (Use Ctrl + Left click to multi-select).
  3. Click Actions (button) > Batch Update.
  4. Select a batch-update option on the left and provide the required information:
    1. Status: Select a new status from the adjacent dropdown list.
    2. Due Date: Select a due date on the adjacent calendar. (This is user-defined field and may differ.)
    3. Required Date: Select a required date on the adjacent calendar. (This is a user-defined field and may differ.)
    4. Entity: Select a registered entity from the dropdown list.
    5. Category: Select a category from the dropdown list.
  5. Click Update (button) 
  6. Confirm the change.

Related Articles