Customer Account Statement, Document Output
Overview
The Customer account statement report displays external customer account statements that you can send to your customers. If the account statement includes transactions for more than one currency, the opening balance and the closing balance are displayed in each currency.
Customer Account Statement Document Outputs can either be generated by SSRS (SQL Server Reporting Services) or by using Electronic Reporting (ER).
SSRS, Customer Account Statement Output Document
Print management setup allows the system to be configured to use the SSRS format. The report format dictates the SSRS report format.
Customer Account Statements can be configured to be:
- Sent to Print Archive
- Report rendered to screen
- Physically printed to a printer
- Saved to a file
- Emailed
A typical SSRS document layout output is shown below:
ER, Customer Account Statement Output Document
Print management setup allows the system to be configured to use the ER Excel format. The report format dictates the Excel report format.
The Customer Account Statement is available to select as the Report Format after it has been published to the ER Configuration
ER has it’s own Reporting Destination configuration which differs from the Print Management configuration for SSRS.
Customer Account Statements can be configured to be:
- Emailed
- Sent to the Print Archive
- Saved to a file
- Rendered to screen
- Sent to Power BI
Additionally, ER formats for Excel and Word can be automatically converted to PDF by enabling the “Convert to PDF” functionality through Feature Management
Once enabled the Office document is automatically converted to PDF
The Electronic Reporting format will be used when the “Use Print Management” criteria is selected.
A typical Excel document layout output is shown below:
Enhancements to Document Outputs
The ER functionality for Configurable Business Documents allows your IT Team to develop changes to the report layout using familiar tools such as Microsoft Word and Microsoft Excel. The advantage of using ER using the office tools and configuration through ER allows document changes to be applied to any environment including Production without any downtime.
Otherwise, the document output can be developed using the X++ language by developing changes in Visual Studio and consequently deploying a Deployable Package to an environment through the normal release process.