Individual Reports - Transaction Journal
The Transaction Journal report is included in the following Standard products:
- Standard Accounts (Nominal Ledger module)
- Standard Nominal Ledger
---
The Transaction Journal (also called Daily Transaction Ledger) is a summary of the entries made in the Transaction register. You cannot change the definition of this report.
When printed to screen, the Transaction Journal has the Drill-down feature common to many reports in Standard products. Click on any Transaction Number in the report to open an individual Transaction record.
If you are using Standard Accounts, you will find the Transaction Journal in the Nominal Ledger module. Use the [Module] button in the Master Control panel to enter the Nominal Ledger to produce the report. Then, as in every Standard product, click the [Reports] button in the Master Control panel and double-click 'Transaction Journal' in the 'Reports' list. The 'Specify Transaction Journal' window will be opened.
- Period
- Paste Special
Reporting Periods setting
- Enter the period to be covered by the report.
- Transaction No.
- Range Reporting
Numeric
- If you only want to print a certain range of Transactions, you can select this range using the Transaction No. field. Enter the first and the last Transaction Number, separated by a colon (:). If you leave the field blank, all records in the Transaction register from the selected period will be printed.
- The Transaction Number must include the prefix as shown in the 'Transactions: Browse' window. To print a Transaction that was entered directly to the Transaction register, enter, for example, "2011.1003" or, for a range, "2011.1003:2011.1010". If you are using Standard Accounts and you need to print a Transaction that was created remotely from one of the other transaction registers, enter, for example, "S/INV.110003" or "S/INV.110003:S/INV.110010" for a range.
- Only VAT Code
- Paste Special
VAT Codes setting
- Use this field to limit the report to Transactions in which there is at least one row with a particular VAT Code.
- Report Header
- Specify the report title here. If you do not specify a title, "Transaction Journal" will be used.
- Fwd Turnover
- If you enter an amount in this field, this amount will be added to the total turnover at the bottom of the report.
- List Transactions
- With this box checked, each Transaction used by the report, together with debit and credit totals, will be listed at the bottom of the report. If you have restricted the scope of the report using any of the fields above, only those Transactions included in the report will be listed.
- List Accounts
- With this box checked, each Account used by the Transactions in the report, together with debit and credit totals, will be listed at the bottom of the report. If you have restricted the scope of the report using any of the fields above, only those Accounts affected by the Transactions shown will be listed.
- List VAT Codes
- With this box checked, each VAT Code used by the Transactions in the report, together with debit and credit totals, will be listed at the bottom of the report. If you have restricted the scope of the report using any of the fields above, only those VAT Codes affected by the Transactions shown will be listed.
- Don't print Transaction Prefix
- Transaction Numbers are usually printed in the report together with their prefixes as shown in the 'Transactions: Browse' window. Transactions entered directly to the Transaction registerr, for example, are printed as "2011.1003" while, if you are using Standard Accounts, those created from a Sub System are printed as, for example, "S/INV.110003". If you do not want these prefixes to be shown in the report (i.e. in the examples, to omit "2011." and "S/INV."), check this box.
- Sorting
- The report can be sorted by Transaction Number or Transaction Date.
- If you are using Standard Accounts and you sort by Transaction Number, all Transactions of a similar type will be grouped together. For example, Transactions resulting from Sales Invoices will be grouped together, Transactions resulting from Purchase Invoices will be grouped together, and so on. This allows the report to provide debit and credit turnover figures for each type. If you have used different Number Series, then debit and credit turnover figures will be provided for each Number Series, identified by the Comment from the Number Series. For example, if you have created Invoices using three Number Series, the resulting Transactions in this report will be divided into three sections, with debit and credit turnover figures provided for each one.
- If you sort by Transaction Date, all Transactions of a similar type from a particular month will be grouped together. For example, Transactions resulting from Sales Invoices in January will be grouped together, Transactions resulting from Purchase Invoices in January will then be grouped together, to be followed by other Transactions from January, then the pattern will be repeated for February, and so on. This allows the report to provide monthly debit and credit turnover figures for each type. If you have used different Number Series, then monthly debit and credit turnover figures will be provided for each Number Series, identified by the Comment from the Number Series.
Click [Run] in the Button Bar. The Transaction Journal is printed.
---
In this chapter:
Go back to home pages for:
|
