This financial report shows payment details for each Payment Account in DEAR. All data about payments, money tasks and bank transfer operations is included in the report. Use this report to view detailed transaction information for the selected account such as customer/supplier, transaction reference, date, currency, payment total and value in base currency.
NOTE: This report is different from the Customer Payment Details Report, which shows payment details for sales orders by customer. For more information, see Customer Payment Details Report.
This report can be automatically generated and sent out to authorised users using the Report Scheduling feature available to DEAR customers with Automation module subscriptions. See Report Scheduling for more information.
The report is accessible to users with the following access levels:
- Sales Reporting
- Purchase Reporting
- Financial Reporting.
Data from this report can be exported in Excel, PDF or RTF format.
|Account Code||Select the account to show transaction details for.|
|Reporting Period||Allow user to select the reporting period from a list of options are set custom a custom date range|
|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.
The following output fields are available for this report.
|Account||Select a payment account in DEAR or select All Accounts|
|Supplier/Customer Name||The name of the supplier or customer who made or received the payment|
|Date||Date of payment|
|Document #||Invoice/credit note/purchase order/sale quote number, as related to payment. When clicked, the document is opened in another window.|
|Document Total||Invoice/Credit note/Expense etc. document total|
|Currency||Bank account currency|
|Amount||Monetary amount of payment in document currency|
|Base Currency Amount||Monetary amount of payment in base currency|