Viewing the Transaction History of an Account
Account > Creditors/Debtors > {double Click the account name} > (Transactions)
(Understanding this Path above)
You can easily and quickly view the transaction history of an account in MYOB EXO Business on the Transactions tab of the account. From this window, you can also perform a range of tasks, including:
-
creating a new invoice
-
creating a new credit note
-
creating a new payment
-
allocating transactions for the account
-
issuing credit notes
-
searching for an invoice number
-
emailing Debtor invoices and statements
Note: Although the Transactions tabs for Debtor and Creditor accounts differ slightly, the majority of the content is common.
In this Topic
Field Descriptions | Menu commands | Shortcut Menu | Search Options | Transaction Age Numbering
The transaction history of a Creditor/Debtor is period-based, typically (but not always) monthly periods.
To view the transactions of a Creditor/Debtor:
-
From the Creditor/Debtor Account Details (search) window, select the creditor/debtor by double-clicking the required account’s name.
-
Click the Transactions tab on the Creditor/Debtor Account Details window.
The Transactions tab is displayed:
Field Descriptions
The grid header fields are detailed in the table below:
Field |
Description |
Trans # |
The unique transaction ID. |
Date |
The date the transaction was created. |
Pd stat seq |
The unique period number for the period, also identifying the period as Creditors, Debtors, GL or Stock. |
Age |
The period number of the transaction (where for example if 0 is the current month of July, '1' is June, '2' is May, and so on). |
Transaction |
The transaction type, such as Invoice or Payment. |
InvNo |
The invoice number. |
Ref 1 |
An internally set reference text/number that varies according to the kind of transaction. For example, if a sales order, the sales order number is displayed; if a payment, the payment type is displayed. |
Ref 2 |
An internally set reference text/number that varies according to the kind of transaction. For example customer reference number if invoice, or cheque number if Ref 1 is Cheque. |
Ref 3 |
An internally set reference text/number that varies according to the kind of transaction. For example, if cheque payment type, then the bank name is displayed; if invoice, then 'invoice' is displayed. |
Branch Code |
The branch code of the transaction, such as SYD or AKL. |
Due Date |
The due date of the invoice, based on the credit terms of the creditor account. |
Amount |
The total amount of the invoice. |
Outstanding |
The outstanding amount of the invoice. |
Status |
The allocation status of the invoice, for example, Unallocated, Partly Allocated, Allocated. |
Branch Account |
If this is a branch account, this is the branch account number. If not, this column will display '-1'. |
GLBatchNo |
The GL batch number if this was posted to GL as part of a GL batch. |
Exchrate |
If multiple currencies are being used, the exchange rate used for this transaction. The local currency is '1'; otherwise the actual exchange rate used displays as a decimal, e.g. '0.83'. |
Debtor transactions only |
|
Gateway TrxID |
Each transaction processed by the gateway service provider is issued a reference known as a TrxID. This is typically a long alphanumeric code. See the whitepaper on payment gateways. |
Batch No |
This is the batch number of the banking batch. |
Gateway No |
The is the number of the defined gateway for this transaction. |
? |
Right-click on the transaction line and choose Toggle Query Status to put a question mark on the transaction, to reflect that the transaction is in question. This can then be reported on. |
Creditor transactions only |
|
Auth |
The authorisation status of the invoice |
Paystatus |
The payment status of this invoice, for example, Released, paid. |
Menu Commands
Debtor and Creditor |
Debtor Specific |
-
New Invoice: Create a new Creditor invoice or Debtor invoice.
-
New Payment: Enter a Payment on a Creditor invoice or receive a Debtor payment.
-
Allocate transactions for this account: Enter a payment on a Creditor invoice or allocate a Debtor receipt to an invoice.
-
Issue a Credit Note: Enter a credit note for a Creditor or create a credit note for a Debtor.
-
Invoice Number search: Search for an invoice.
-
Refresh: Provides an updated transaction list.
-
Automatically allocate payments to the oldest invoice: (Debtors only). This will also allocate credits (negative value invoices) and refunds (negative payments) and zero value transactions.
-
Email Invoice: Click this button to email the selected invoice to the Debtor as a PDF attachment.
-
Email Statement: Click this button to email a statement to the Debtor as a PDF attachment.
Shortcut Menu
Right clicking on any invoice summary line opens the following shortcut window. The table below this diagram details the actions of the shortcut commands.
Creditor shortcut menu |
Debtor shortcut menu |
Shortcut Command |
Description |
View the invoice in a report format. |
|
Print Invoice |
|
Print Receipt |
Prints a payment receipt. Only available for a payment transaction. |
Edit Invoice |
Opens the invoice to edit its details. This option is only available if the Permitted level of access to debtor transaction editing or Permitted level of access to creditor transaction editing User-level profile setting is set to "Full invoice editing allowed". |
Edit Ref Fields |
Edit the transaction reference fields for the invoice. This option is only available if the Permitted level of access to debtor transaction editing or Permitted level of access to creditor transaction editing User-level profile setting is set to "Full invoice editing allowed" or "Invoice header fields editing allowed". |
Duplicate Invoice |
Select to create a duplicate of a Debtor invoice. |
Generate Credit |
Provides a copy of the negative invoice. |
Reverse Payment |
|
Journal |
Opens the Debtors Adjustment Entry window to make a Debtors journal adjustment entry transaction. |
Margin Pie Chart |
Displays a graph for the invoice showing margins. |
View Allocation Info |
Displays a list with the allocation information in a separate window. |
Reverse Allocation |
Reverse all allocations associated with this transaction (payment or invoice). This option is only available if the Allow reversal of debtor/creditor allocations User-level profile setting is enabled. This option is not available for transactions with deposits or foreign currencies. |
Refresh |
Updates the entire transaction list. |
Authorise this Transaction |
Where M-Powered Payments are used, this option authorises the selected transaction. |
View Reconciliation Info |
Provides a list with the reconciliation information. |
View Purchase Order Invoice History |
Displays the Purchase Order History window. |
Allocate To Oldest |
Allocates a payment transaction to the oldest outstanding invoice. |
Toggle Query Status (?) |
Puts a question mark on the transaction, to reflect that the transaction is in question. This can then be reported on. You may need to add the ? column by right-clicking on the column header and selecting Select visible columns. |
View Banking Batch |
Opens the Debtors Banking Batches window. |
View GL Batch Transactions |
Opens the GL Batch Transactions window, showing all GL transactions associated with this transaction. This option is only available for transactions that have been posted to the GL, and requires the Allow Sub ledgers drill through to GL Transactions User-level profile setting to be enabled. |
View Job |
Where the Job Costing add-on module is used, displays the job associated with the transaction. |
View Sales Order History |
Displays the Sales Order History window. |
View Analysis Codes |
Displays the Analysis Codes associated with the transaction. |
Preview Journals |
Displays the GL Batch Transactions window, showing the Debtor Ledger and Stock Ledger transactions that will be generated for the transaction. This is a preview only - no transactions are saved when the window is closed. |
Search Options
Group by Period
Checking the Group by Period checkbox groups the transactions by period:
Clicking on a period line lists all the transactions for that period in the grid in the area below the period groups. Once the group has been selected it can be minimised by clicking the minimise icon ( ). Maximise this view by clicking the icon again. Minimising this view provides a greater display area for the group's individual transactions in the grid below.
The transactions by Period grid has its own grid fields, which are defined in the table below:
Shortcut Command |
Description |
Age |
In MYOB EXO Business, transaction ages are numbered from current (0) backwards. See for details on this numbering system. |
Period Name |
This is the period name that correlates to the |
Invoices |
This is a total for all invoices submitted over this period. |
Credits |
This is the total for the credits issued to this debtor over this period. |
Payments |
This is the total for all types of payments received from the debtor for this period. |
Refunds |
This is the total for all refunds issued to the debtor for this period. |
Dr Adjustments |
This is the total for all debtor adjustment transactions for the selected period. |
Cr adjustments |
This is the total for all creditor adjustment transactions for the selected period. Creditor adjustments are similar to Creditors Payment Entry, this function creates adjustment entries against a creditor account, with predefined reasons for the adjustment. |
Balance |
The current debtor account balance for the selected period. |
Show Only Unallocated
Checking the Show only unallocated checkbox filters the transaction list to display only the transactions that are not allocated to an account. This is useful when it is necessary to allocate transactions that have not been previously allocated.
Transaction Page Numbering
While MYOB EXO Business stores transaction dates, it is not a purely date-based system. It does not rely on dates for critical procedures such as transaction ageing and posting between ledgers, nor are dates used by any of the standard reports within EXO Business to calculate control totals.
MYOB EXO Business employs a method of tagging all transactions with a nominated period number at the time of posting. As an extra validation, EXO Business can ensure that the transaction date given is valid for the period that the transaction is being posted to. This method is used to avoid the traditional problems associated with incorrectly entered dates and extra processing overhead required to ‘age’ transactions into periods which often makes purely date based solutions very limited in scale.
In MYOB EXO Business, transaction ages are numbered from current (0) backwards. This may be different from the system you are familiar with, however it does give you some useful logic consistency.
Example:
0 = current period
1 = One period ago (last month)
2 = Two periods ago
54 = Fifty-four periods ago etc.
MYOB EXO Business knows which period in the period table is the current one, and uses this as a point of reference to display the name of the period on reports and within data entry screens.