Setting up Customer Statements
With Payment Management, you can print customer statements with a payment reference allowing customers to pay multiple invoices using a single payment reference.
This feature is primarily developed for the DK localization of Payment Management, as it mainly supports the Danish payment references.
When a customer uses the payment reference number, Payment Management uses it in the following two places:
Cash receipt journal: When you import payments to the cash receipt journal, Payment Management detects the payment reference and automatically applies all the related customer ledger entries in the journal.
Bank account reconciliation: When the payment reference appears in either the description or among the additional information received from the bank, Payment Management identifies the payment reference and creates a reconciliation suggestion. You can access the reconciliation suggestion when the line is reconciled and see all the related suggestion entries. Additionally, on the bank account reconciliation line, you can open the related customer statement by selecting Bank Statement Lines > Show Customer Statement.
To add a payment reference to the customer statement, there are a few things you need to set up:
A default number series for customer statements is set up with Continia Payment Management's installation and is ready to go. However, if you want to change the number series, navigate to Payment Management Setup > Payment Receipt Import > Customer Statement No. The number series can only contain numbers.
You must select a payment reference type to specify how the payment reference should be structured.
- Select the icon, enter Sales & Receivables Setup, and then the related link.
- On the General FastTab, in the Payment Reference Type field, specify the relevant reference type.
Using a Payment Management report layout would be best to include the payment reference type in the customer statement layout.
- Select the icon, enter Report Layouts, and select the related link.
- Search for report ID "1316", and select the word layout "Customer Statement" created by Continia Payment Management (see the Extension column).
- In the action menu, choose Set Default.
You can choose to use a different layout than the one created by Payment Management, but you must be sure the layout includes the payment reference. You can only use a Word layout.
- Select the icon, enter Customers, and select the related link.
- Select a customer.
- On the customer card, in the action menu, select Reports > Statement.
- On the Customer Statement page, specify the details for the statement you want to print and select OK.
The customer statement is now being printed with the payment reference specified.
The payment reference is not displayed on the customer statement if you use the preview functionality.
When the customer statements are printed, you can view them in Business Central. Here you can see the payment reference and the related customer ledger entries.
- Select the icon, enter Customers Statements, and select the related link.
- Select the relevant customer statement to view the details and related customer ledger entries.
When using customer statements, data accumulates over time. You can use the retention policy in standard Business Central to make sure tables related to customer statements will be automatically deleted after a specified period. There is already a retention policy created for the customer statement data in Payment Management, but to use it, you must enable it.
To enable the retention policy for customer statements, follow these steps.
- Select the icon, enter Retention Policies and select the related link.
- Select the table ID of the "Customer Statement" retention policy.
- For the retention policy, specify the retention period and enable Enabled.