Creating a Payment Diary Report
Filters
Show
Sort
Payment Diary report shows all payments for the selected period. You can set desired filters for the report, after which a report is generated on the screen based on the provided information.
Creation of the Payment Diary Report
- Go to the Reports – Payment Diary view
- Make the selections you want for the report
Filters
You can select from the Doc. Type- field dropdown menu either a single document type or all document types for which the recorded invoices are to be reported.
Document Number -You can enter either a single document number or a range of document numbers that you want for the report.
Payment Date – Select the time period by clicking the calendar icons to display the invoice payments on the report. Both the start and end dates of the period must be specified in the filter. If a receipt/invoice date range is defined for the report, and Invoices Transferred to Accounting is selected in the report filters, the report will show those invoices from the specified time period that have been transferred to accounting.
Supplier – If you want all suppliers' invoices to be displayed on the report, select all.
If you want to limit the view to invoices from a specific supplier, select the supplier's name from the dropdown menu or type the beginning of the supplier's name, which will narrow down the list.
Show
Select whether to display all payments or only the payments transferred to accounting.
- All payments selection shows all payments on the report.
- Payments transferred to accounting selection displays payments that have been posted to the accounting within the specified time frame.
Sort
Select the order in which payments are displayed on the report: By receipt type, By date, By payment accounts, By accounts payable accounts, or By suppliers.
- By document type: the report is sorted by document types
- By date: the report is sorted by the dates of the payments
- By payment account: the report is sorted by payment accounts (e.g., bank accounts)
- By purchasing dept: the report is sorted by purchasing dept.
- By supplier: the report is sorted by suppliers
When the Payments option is activated, the report will display payments without accounting entries.
Postings by Payments – When postings by payments is selected, the report will display the assignments of the payments, either gross or net. Note! A summary of the assignments will also be printed automatically for this report.
Subtotals – This option prints intermediate totals according to the order - selection (By Document Types / By Date, By Manual Payment or Accounts Payable, or By Supplier).
Report Generation
- Show – prints the report on the screen
- PDF – prints the report to a PDF file
- CSV - prints the report to a CSV file