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.
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.
The report is accessible to users with the following access levels:
- Sales Reporting
- Purchase Reporting
- Financial Reporting.
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 inputs are shown in the table below.
|Payment account code|
|Beginning date of report|
|Closing/end date of report|
|Refreshes the report results based on the latest data|
|Sets filter on fields used in the report|
|Allows export of report data to Excel, PDF or RTF|
|Set to the Default layout. Allows selection of saved layouts, if any.|
After setting the inputs described above, pressing the Update button refreshes the report based on the selected inputs. The output fields are shown in the table below.
|Payment Account||Payment account in DEAR|
|Supplier/Customer Name||The name of the supplier or customer who made 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.|
|Reference||Reference for payment|
|Currency||Bank account currency|
|Payment Amount in Document Currency||Monetary amount of payment in document currency|
|Payment Amount in Base Currency||Monetary amount of payment in base currency|