Validation Notice Fields for Local Print and Vendor letters in ACE

This article provides information on the validation notice fields available for use in local print letters and letter vendor files in ACE. Understanding these fields is essential for creating accurate and compliant validation notices.

Prerequisites

• LibreOffice Setup: Ensure you have the supported version of LibreOffice installed. See LibreOffice - ACE Supported Version(s) for more details.

• Sample Template: Download and review the Sample Model Validation Notice Template for reference.

Updating the Letter Data Source

To access the latest validation notice fields, you need to update your Letter Data Source in LibreOffice:

1. Download the Latest Letter Data Source:

   1. From your ACE application, download the most recent version of the Letter Data Source spreadsheet (*.ods file).

2. Update the Registered Data Source:

   1. If you already have the Letter Data Source registered in LibreOffice, you can overwrite the existing file with the new one.

   2. If overwriting doesn't update the fields, you may need to register the database again under a different name.

Validation Notice Fields for Local Print Letters

The following fields are available for use in local print letters when creating validation notices:

Client Fields

• client.itemizationDateSource

• client.itemizationDescription

Debt Fields

• debt.itemizationDate

• debt.itemizationDateSource

• debt.itemizationDescription

• debt.validationNoticeEndDate

• debt.validationNoticeReturnedDate

• debt.validationNoticeSentDate

• debt.validationNoticeSentDateAge

Debt Buckets Fields

• debtBuckets.itemizationAdjustmentsBalance

  • Includes all credits only.

• debtBuckets.itemizationCurrentBalance

• debtBuckets.itemizationCurrentBalanceTotal

• debtBuckets.itemizationFeeBalance

• debtBuckets.itemizationInterestBalance

• debtBuckets.itemizationInterestBalanceTotal

• debtBuckets.itemizationOwingBalance

• debtBuckets.itemizationPaymentsBalance

  • Includes all payments only.

• debtBuckets.itemizationReceivedBalance

  • Includes all payments and credits.

Validation Notice Fields for Letter Vendors

The following fields can be included in letter vendor files for validation notices. These fields may slightly differ from those available for local print letters.

• client.itemizationDateSource

• client.itemizationDescription

• debt.itemizationDate

• debt.itemizationDateSource

• debt.itemizationDescription

• debt.validationNoticeEndDate

• debt.validationNoticeReturnedDate

• debt.validationNoticeSentDate

• debt.validationNoticeSentDateAge

• debt.itemizationAdjustmentsBalance

• debt.itemizationCurrentBalance

• debt.itemizationCurrentBalanceTotal

• debt.itemizationFeeBalance

• debt.itemizationInterestBalance

• debt.itemizationInterestBalanceTotal

• debt.itemizationOwingBalance

• debt.itemizationPaymentsBalance

• debt.itemizationReceivedBalance

Notes

• Differences in Field Availability: There are slight differences between the fields available for local print letters and those for letter vendors. Ensure you are using the correct fields based on your letter generation method.

• Testing Templates: It is recommended to test and review the template example provided in the Sample Model Validation Notice Template to identify how these fields are used.

Additional Resources

For additional information view the articles linked below:

Sample Model Validation Notice Template

Validation Notice Dates