Customer transaction enquiry

Find this screen

How to

View customer transactions

1. Select the Customer account.

   A list of transactions are displayed for the selected account.

2. Select a transaction to display its details.

   More tips for using the list

   • Search for items by typing in the box at the top of a column.

   • Use filters to show items that contain particular text or a range of values.

     • To filter a column, select the filter button in the column heading, or select the filter button from the menu in the column header.
     • If you want to filter by a date, use the filter button from the menu in the column header.
   • Sort the list by selecting the column heading. Select the heading once to sort in ascending order, and select it again to sort in descending order.
   • To add or remove columns, select the menu button in the column header, then select the columns button.
   • To pin a column, select the menu button in the column header, then select Pin Column and choose the column.
   • To move a column, select and hold the column heading, then drag it to a new position.

   Note: You'll not see the menu button in the column header until you either: hover over the column heading with a mouse, press and hold the column heading on a touch screen, or navigate to the column heading using a keyboard Tab key (use Ctrl + Enter to open the menu).

3. To only show transactions that are unallocated and left outstanding, select Only outstanding.

   Note: You can choose whether this is selected by default by selecting Show outstanding transactions only in Customer Defaults and Settings.

4. You can view additional details about the transaction on the tabs.

   • Transaction Detail: Shows basic details about the selected transaction.

   • Nominal: The nominal accounts that the transaction was posted to.

     Note: You can only view Transaction Analysis details if you have enabled Allow additional transactional analysis in Customer Defaults and Settings.

   • Allocation Session: The details and amounts of transactions that have been allocated.
   • Allocation History: An overview of allocation sessions, including the dates, allocated amounts and exchange rate information.
   • VAT: A breakdown of the VAT element of the selected transaction.
   • Bank: Bank account information related to the selected transaction.
   • Memo: View memos for the selected transaction. See Use transaction memos.
   Note:

   • These additional details will only be available if the transactions exist and have not been purged from the relevant files.

   • For foreign currency transactions with settlement discounts, you may see rounding discrepancies with the VAT discount and VAT values displayed here.

Use transaction memos

You can add memos to transactions, and choose whether they're active or inactive.

• To add a memo for a transaction:

  1. Select the transaction.
  2. Select Add Memo.
  3. Select Add to add a new memo line, and enter the Text for the memo.

• To edit or view a memo:

  1. Select the transaction.
  2. Select Edit Memo.

• To set the status of a memo as active or inactive:

  1. Select the transaction.
  2. Select Edit Memo.

  3. Select the Active column for the memo to change the status. A tick means the memo is active.

     Note: You might want to set a memo to inactive to show that it's not currently applicable, but don't want to delete the memo.

---

Useful info

About the customer transaction enquiry

The transaction enquiry provides a detailed breakdown of each transaction held on the customer's account, for current transactions.

• View the current status of a transaction, to establish whether it has been fully paid, part paid or remains outstanding.

• Check if a transaction has a query flag against it. A query flag prevents the transaction from being processed until the query is removed, and is different from applying an On Hold flag to the whole account. The reserved query characters indicate W for bad debt write off, and F for finance charges.

• View the URN The unique reference number assigned to a complete transaction to assist in tracing the progress of the transaction through Sage 200. This number is 12 digits long and comprises of: 3 digits for the user number, 2 digits for the source module in which the transaction was created, and a 7 digit sequential reference number. (unique reference number) which can be used to trace the transaction to the Nominal Ledger.
• View additional details about the transaction, nominal accounts, allocations, VAT, bank accounts, and memos.