This report shows detailed financial transactions within the selected time period. Use this report to view all transaction details including type, transaction reference, description, debit/credit accounts, amount and date.
This report is only available to users with Financial Reporting permissions.
Prerequisite:
Data from this report can be exported in Excel, PDF or RTF format.
Input:
Reporting Period | Allow user to select the reporting period from a list of options are set custom a custom date range. This report is filtered by transaction date. |
Layout | Set to the Default layout. Allows selection of saved layouts, if any. |
Save Layout As | Allows saving of a layout for potential future use. |
Reset Layout | Resets layout to the default layout or selected saved layout. |
Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters.
Output:
The following output fields are available for this report.
Fields | |
Supplier/Customer | Supplier or Customer associated with the transaction if applicable |
PO/SO | Purchase order or sale order number associated with the transaction if applicable |
Type | Transaction type |
Reference | Document reference number and link to document |
Debit | Debit account |
Credit | Credit account |
Description | Transaction description |
Date | Effective date of transaction |
Year | Year in which the transaction took place |
Quarter | Quarter in which the transaction took place |
Month | Month in which the transaction took place |
Debit Job # | Debit sub-account of Job # if applicable |
Credit Job # | Credit sub-account of Job # if applicable |
Invoice # | Invoice # of the transaction if applicable |
Data Headers | |
Amount | Value of transaction in base currency. |