Skip to content
Home » Customer Collection Letter Document Output

Customer Collection Letter Document Output

Customer Collection Letter, Document Output

Overview

Customer Collection Letters are sent to delinquent customers when they have not paid for goods or services, when the due date has already passed

Customer Collection Letter Document Outputs can either be generated by SSRS (SQL Server Reporting Services) or by using Electronic Reporting (ER).

SSRS, Customer Collection Letter Output Document

Print management setup allows the system to be configured to use the SSRS format. The report format dictates the SSRS report format.

Collection Letters 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 Collection Letter 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.

Collection Letters 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.