Any transactions which have been processed for that creditor (supplier / vendor) account will be listed:

  • Batch (Journal) transactions which have been updated (posted) to the ledger.
  • Document transactions (i.e. Purchases and Supplier returns) which have been updated (posted) to the ledger.

To maximise the Transactions tab and / or Debit / Credit transactions section of the screen, click on the   button to maximise the Transactions tab. You may also click and drag any part of the screen up / or down.  

All selected - All transactions listed. Those transactions which are fully linked or settled, will display an 0.00 amount in the Outstanding column: 

All

By default, this option is not selected. If a creditor account is set to Open item account (Accounting information tab) only the transactions which are not linked (matched) in the Open item feature (i.e. amounts in the Outstanding column smaller or larger than 0.00), will be listed. 

All - If you select this option, all the transactions which are  linked (matched) in the Open item feature (i.e. amounts in the Outstanding column = 0.00), will be listed. 

All not selected - This is the default option. Only those with outstanding amounts will be listed: 

Before sending  remittance advises to your creditors (suppliers) , it is recommended that any amounts in the debit section be linked to any outstanding invoices or credit transactions. 

If the creditor (supplier / vendor) account is not set as an open item, account, all transactions will be listed. 

It will list transactions as follows:

  1. Debit - Documents (i.e. Supplier returns), Purchase returns journal, Payments journal, Opening Balances take-on, etc. It will list any transactions, for which amounts are entered in the Debit column of batches.
  2. Credit - Documents (i.e. Purchases), Purchase journal, Generate multiple transactions (Creditors with charge amount), Opening Balances take-on, etc. It will list any transactions, for which amounts are entered in the Credit column of batches.

You may click on the column headings (i.e. Reference, Description, Date, Amount or Outstanding) to change the sort sequence from the ascending to the descending sequence.

You may also click and drag any of the column headings to the left or right to change the sequence in which the columns are to be displayed.

View Transactions - Show transactions context menu

  1. Select a transaction and click on the Show transactions context menu.
  2. On the "Transactions" screen, click on the Print button. 

The Documents tab lists all posted and unposted documents and orders. The Show transactions context menu option will not do anything, if an order or an unposted document is selected.

The Amount exclusive values are as follows:

  • 0 = Amount exclusive
  • 1 = Amount inclusive 

View Transactions - Show Transactions button

T-Account viewer

  1. Click on the Show transactions button.
  2. Enter or select a start date and an end date, if necessary. Click on the Print button to print the transactions, if required. 

You may double-click on a selected batch number to view only the transactions for the selected document. For example, if you need to view and print the transactions for Supplier return "PU000005" only, double-click on the batch number "10081" 

Show contra - By default, this option is not selected. The contra accounts will not be printed in the "ledgerdetail" report when you click on the Print button.

Show contra option selected you may view the Contra accounts in the T-Account-viewer. If you click on the Export button, the contra accounts will be included in Column A of a Spreadsheet. 

The Contra accounts consists of the following, separated by a comma:

"G750000 Stock control,T860020 Input VAT - Standard rate -15%"

Documents

  • Ledger account and account description set as the contra account of the batch type linked to the document type. (i.e. Contra account of the Purchase jnl linked to Purchase and Supplier return document types in Setup documents). 
  • Tax account (tax code) and description as linked to the Input tax (VAT/GST/Sales tax) on the Ledger tab of the Stock item selected on the Document lines.

Batches 

  • Ledger account and account description of the contra account selected in Batch setup generated as balancing entries; or selected in the "Account" column for Batch transactions.
  • Tax account (tax code) and description as selected in the "Tax" column for Batch transactions and / or generated as balancing entries.

Lookup document

You may right-click on a selected document and select "Lookup document" on the context menu of the "T-Account viewer".

The posted document will be displayed in a stand alone "Document entry" screen.

You will not be allowed to edit or change the posted document.

T-Account viewer - Print transactions

 To print the transactions, in the "T-Account viewer", click on the Print button. 

View a specific selected batch transaction (e.g. Supplier return "PU000005" (batch number "10081) 

T-Account viewer - Export transactions 

To export the transactions, in the "T-Account viewer", click on the Export button. This will export the transactions, as selected displayed in the T-Account viewer, as a comma separated text file as a "Export.txt" file. The Exported file will automatically be opened in your in your system's app (program) associated with the CSV (Comma Separated Values) file types.