Creditor accounts - Transactions tab
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 |
|
|
All - Not selected By default, this option is not selected. If a creditor (supplier / vendor) 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. Only the transactions with outstanding amounts, will be listed in the Creditor remittance advises (Reports → Creditors → Outstanding - Creditor remittance advises - Outstanding) All - Selected 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. Should there be any amount larger than 0.00 (zero) in the "Outstanding" column in the "Debit" section of the Transactions tab, you may need to process links in Open item link (Action ribbon). All the transactions, including those with no outstanding amounts, will be listed in the Creditor remittance advises (Reports → Creditors → Outstanding - Creditor remittance advises) |
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 button
1.Click on the Show transaction button.
2.Enter or select a start date and an end date, if necessary.
3.Click on the Print button to print the transactions, if required.
The printed transactions in the T-Account viewer, should display as follows:
|
|
Export button You may click on the Export button of the T-Account viewer to export the transactions to a spreadsheet. You may select to save the export file as Text files (*.txt) (default file type); or as CSV files (*.csv) (Comma Separated Values) file type. This will automatically open (launch) the exported file in the program associated with the selected file type: oText files e.g. (Export.txt) - This should automatically open the exported text file of your system's default text file program associated with Text file type (*.txt) file types (e.g. Notepad, etc). You need to close the exported text file and launch your spreadsheet program. In your spreadsheet program, Open the text file to launch the "Text Import" options. oCSV files e.g. (Export.csv) - This should automatically open the "Text Import" options of your system's default spreadsheet program associated with Comma Separated Value file type (*.csv) file types (e.g. Microsoft Excel, Apache OpenOffice Calc, LibreOffice Calc, Ultra Office, etc.). |
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 "Amount exclusive" values are as follows:
•Amount exclusive = Not selected
•Amount Inclusive = Selected (ticked)
