Itemization Transaction Letter Loops

Definition

 Itemization Transactions include transaction values occurring after the itemization date provided by the client (direct) along with transaction values entered or loaded to the account after the assignment date.

Purpose

If a customer needs or wants to include a page with itemization details with a validation notice, itemization transaction loops allow for that in local print letters and a list of Itemization Transaction Data can be included as rows of data under the letter in the Letter Vendor file.

Itemization Letter Loops

Seven table loop properties are now available for local print letters in ACE as follows.

1. itemization_trans_loop (includes all)
2. itemization_trans_interest_loop
3. itemization_trans_fees_loop
4. itemization_trans_payments_loop
5. itemization_trans_credits_loop
6. itemization_trans_owing_loop
7. itemization_trans_received_loop

See the attached reference files:

• a letter template with examples of the looping tables that can be copied, pasted and altered in your letter templates (ITEMIZATION_TRANSACTION_LOOP_EXAMPLES_TEMPLATE_20210120.odt)
• a pdf printed (with fictitious data) from a sample account with itemization transactions demonstrating the looping tables from the example template (ITEMIZATION_TRANSACTION_LOOP_EXAMPLES --- EXAMPLE as printed to pdf.pdf)

Itemization Transaction Data for Letter Vendors

All itemization transaction data can also be sent to letter vendors using a special value

To include itemization transactions with a letter to the letter vendor, in the letter vendor setup section for Export Fields, add a new line (no preceding comma) following the letter file fields and enter this value:

${itemization_trans_loop}

The file generated and delivered to the letter vendor will include the following:

• a file with a row representing the letter and all of the letter file fields in the Export Fields section
• following the letter row, there will be a row for each itemization transaction with the following 15 fields represented in order without column headers
  1. First column represents the ItemizationTranID which correlates to one of these two values
     • Itemization Trans ID (if the itemization transaction was originally entered or loaded as an Itemization Transaction)
     • Spread ID (if the itemization transaction was originally entered or loaded as an Account Transaction)
  2. Debt ID
  3. Client ID
  4. Customer ID
  5. Trans Date
  6. Amount
  7. Receiver
  8. Operator
  9. Bucket
  10. Type
  11. Note
  12. Create Date
  13. Created By
  14. Last Update
  15. Last Updated By

See the attached reference file:

• a letter vendor file with two letters including the related date described above (itemization (transaction letter vendor file example.txt)
• Please note: the letter file fields you will have in your field will likely be different than those included in this letter vendor file; the example is only provided as a reference to the manner in which the itemization transaction data rows will show up in a data file
• All data in the file example is fictitious
  itemization transaction letter vendor file example.txt