Collection Letters in Dynamics 365 Finance & Operations Complete Understanding

<h2Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 24px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Collection Letters in Dynamics 365 Finance & Operations<h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Introduction<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Collection letters, also known as dunning letters, are formal communications sent to customers with overdue invoices.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>These letters follow a predefined sequential process, escalating urgency if payments remain unpaid. Example In D365 F&SCM we need to first post/print Collection letter 1 only after that system will allow to generate Collection letter 2.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Key Benefits of Collection Letters in Dynamics 365 Finance & Operations:

Prompt Payment: Encourages customers to pay outstanding invoices on time.

Minimum Overdue Balance: Set a minimum overdue balance to automatically generate the collection letter. If overdue is less than minimum overdue balance no collection letter is generated.

Fees & Blocking: Optionally apply fees to overdue balances and specify whether to block customer invoicing during letter posting/printing.

Customer Relations: Personalise collection letters using electronic reporting or Docentric to enhance customer relationships. The default report format is SSRS, but customisation options are available.

Open Transactions: Automatically lists all open transactions for the customer, reducing manual effort.

Multiple Collection Letter Levels: Create up to five collection letter levels in Dynamics 365.

Automation & Flexibility: Generate, print, and send collection letters with ease, apply interest to overdue balances, and build customised collection letter sequences.

Collection letters follow a sequential process, meaning a 2nd letter cannot be created/posted/printed unless the 1st letter is processed.

<hrSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; height: 1px; margin: 0px 0px 32px; padding: 0px; width: 584px;” /><h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Define and Configure a Collection Letter Sequence<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>A Collection Letter Sequence determines the sequence under which collection letters are sent.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Before configuration we need to ask following questions from the business.

How many collection letter stages do you need? (like 3 letter or 5 letters)

After how many days past the due date should each collection letter be sent? (this will be setup in days column)

What fee should be applied at each collection letter stage, and which main account should it post to? (remember only fixed fees can be applied)

What should be the payment term for the fees? (the terms of payment section determine the due date for fees charge when posting the collection letter)

Do you want to block the customer after processing the collection letter? if yes then at what collection letter stage do you want this setting?

<h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Navigation Path:<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;”>📍 Credit and collections > Setup > Set up collection letter sequence

<h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 32px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Key Fields in Collection Letter Sequence:<divSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px -24px; padding: 0px; vertical-align: baseline;”>

1st Collection Letter: Grace period is calculated from the invoice due date.

2nd & Subsequent Letters: Grace period is based on the posting or printing date of the previous collection letter (as defined in Accounts Receivable Parameters).

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;”>💡 Once created, a Collection Letter Sequence must be mapped to a Posting Profile for the system to generate collection letters.

<hrSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; height: 1px; margin: 0px 0px 32px; padding: 0px; width: 584px;” /><h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Assign Collection Letter Sequence to a Posting Profile<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>The collection letter sequence must be linked to the customer posting profile to ensure correct processing.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Also, in the customer posting profile in the Table restriction fast tab the collection letter toggle should be turned on.

<h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Configuration Steps:<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>1️⃣ Go to Credit and Collections > Setup > Customer Posting Profiles.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>2️⃣ Expand the Table Restrictions tab and enable Collection Letter Processing.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>3️⃣ Under the Setup FastTab, select the appropriate Collection Letter Sequence.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>4️⃣ If left blank, collection letters will not be generated for transactions under this posting profile.

Ensure that all posting profiles requiring collection letters have an assigned Collection Letter Sequence.

Also note that we do not need to specify collection letter sequence for each of the Account code in the customer posting profile. For example, we do not need to generate collection letter for some groups.

<hrSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; height: 1px; margin: 0px 0px 32px; padding: 0px; width: 584px;” /><h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Configure Credit and Collections Parameters<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>These parameters define how collection letters are generated and processed.

<h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 32px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Key Settings:<divSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; margin: 0px -24px; padding: 0px; vertical-align: baseline;”>

<hrSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; height: 1px; margin: 0px 0px 32px; padding: 0px; width: 584px;” /><h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Process Collection Letters – Create, Review, Print, and Post<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>The collection letter process in Dynamics 365 F&O consists of two main steps:

Create collection letter

Review and process collection letter

<h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Step 1: Create Collection Letters<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;”>📍 Credit and collections > Collection letter > Create collection letters

Select the Transaction Types to be included.

Choose a posting profile (if different from the default).

Apply filters (e.g., specific customers or customer groups) if required.

Once created, the system sends a notification under the Action Center.

Click Message Details to review the list of generated collection letters.

<preSF Mono”, Consolas, “Roboto Mono”, “Noto Mono”, “Droid Mono”, “Fira Mono”, “Ubuntu Mono”, “Oxygen Mono”, “Lucida Console”, Menlo, Monaco, monospace; font-size: 16px; line-height: 1.5; margin: 0px -24px 32px; overflow-x: auto; padding: 32px; text-wrap-mode: wrap; vertical-align: baseline;”><codeSF Mono”, Consolas, “Roboto Mono”, “Noto Mono”, “Droid Mono”, “Fira Mono”, “Ubuntu Mono”, “Oxygen Mono”, “Lucida Console”, Menlo, Monaco, monospace; line-height: 1.5; margin: 0px; outline: rgb(255, 255, 255) none 0px; padding: 0px; vertical-align: baseline;“>Note: - In case if you have generated a collection letter number 1 on 14th Feb 2025, and you have provided grace days (let’s say 10) in the collection letter sequence page for collection letter number 2, then if you try to run the create collection letter process before 10 days pass from generation of collection letter 1. The system will not generate collection letter.<hrSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; height: 1px; margin: 0px 0px 32px; padding: 0px; width: 584px;” /><h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Step 2: Review, Print, and Post Collection Letters<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;”>📍 Credit and collections > Collection letter > Review and process collection letters

This screen displays all generated collection letters.

Filter by status = Created to view the most recent letters.

Click Print > Collection Letter Note to generate the letter layout.

The Printed Column will update to Yes once printed.

Posting is required, even if no collection fees are charged.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>We can also print the collection letter (once we click print button the status of collection letter will be changed to printed)

<hrSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; height: 1px; margin: 0px 0px 32px; padding: 0px; width: 584px;” /><h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Once more demonstration<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>I cancelled the collection letter 2 and its status was changed to cancelled, now I run the create collection letter process again and in this case collection letter 2 will be generated again and not the collection letter 3. Relax! this is system default behaviour.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;”>✔ If a user cancels a collection letter manually, the status will change to “Cancelled.”

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;”>✔ The collection letter number remains the same until it is posted / printed (depends on collection parameters). If recreated before posting, it simply replaces the previous version.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;”>✔ Fees configured in the Collection Letter Sequence are only posted when the letter is posted (not when it is created or printed).

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;”>✔ The Voucher button is only enabled when a posted collection letter has associated fees.

<hrSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; height: 1px; margin: 0px 0px 32px; padding: 0px; width: 584px;” /><h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Batch Process to Auto Post Collection Letter<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Once you click on the post button for a collection letter we see “Post collection letter note” pane enabled.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>We can check the use run date as posting date and clear the filter (or use appropriate filter on customer account and collection letter based on your requirement)

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Posting a collection letter is very crucial and can be very delicate in case fees are also involved. Since, in cases customer pay you the outstanding then you might want to remove the fees, and you need to pass manual entries to remove the posted fees)

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Hence in the above case I selected collection letter 1 as criteria (assume there is no fee for this letter)

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Setup the recurrence and enabled the batch process toggle to auto post the collection letter using batch process.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Content is for educational purpose please perform your own testing and due diligence before relying on any of the content.

<hrSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; height: 1px; margin: 0px 0px 32px; padding: 0px; width: 584px;” /><h2Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 24px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Deep Dive into Collection Letter Code Generation in D365<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>In my previous part of this blog, we explored how to set up collection letters in Dynamics 365 Finance and Operations (D365).

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Now, let’s take a deeper dive into how the system generates collection letter codes. Understanding this process is crucial to ensure that your collection process runs smoothly.

<h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Overview of Collection Letter Codes<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>In D365, you can generate up to five collection letter codes for a single transaction or customer. Each collection letter generated is assigned a code ranging from 1 to 5. While the current system limits you to five codes, future updates may expand this capability.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>For now, let’s focus on how these codes are generated and what factors influence their creation.

<h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Collection Letter Generation: Per Transaction vs. Per Customer<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>When setting up collection letters, you have the option to generate them either per transaction or per customer. The choice you make here will determine how the system assigns collection letter codes.

Per Transaction: Each transaction is treated independently, and collection letters are generated based on the individual past due transaction (Invoice).

Per Customer: Collection letters are generated at the customer level, taking into account all open and past due transactions (Invoices) for that customer.

This approach (Per Customer) raises an important question:

In the Below Setup we have setup system to create collection letter per customer (it means all open and past due invoices for a customer will be available in a single collection letter). We have also setup “Update collection letter code” to Posting, it means until and unless we post a collection letter code the new code will not be generated.

<hrSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; height: 1px; margin: 0px 0px 32px; padding: 0px; width: 584px;” /><h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>How the System Determines Collection Letter Codes<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>To understand how the system generates collection letter codes, let’s walk through an example.

<h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Example Scenario<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Consider the collection letter setup

<preSF Mono”, Consolas, “Roboto Mono”, “Noto Mono”, “Droid Mono”, “Fira Mono”, “Ubuntu Mono”, “Oxygen Mono”, “Lucida Console”, Menlo, Monaco, monospace; font-size: 16px; line-height: 1.5; margin: 0px -24px 32px; overflow-x: auto; padding: 32px; text-wrap-mode: wrap; vertical-align: baseline;”><codeSF Mono”, Consolas, “Roboto Mono”, “Noto Mono”, “Droid Mono”, “Fira Mono”, “Ubuntu Mono”, “Oxygen Mono”, “Lucida Console”, Menlo, Monaco, monospace; line-height: 1.5; margin: 0px; outline: rgb(255, 255, 255) none 0px; padding: 0px; vertical-align: baseline;“>Qns: How did I managed to create collection letter code #2 even if we can see that for the oldest invoice (#1) we have collection letter code #1 only.<preSF Mono”, Consolas, “Roboto Mono”, “Noto Mono”, “Droid Mono”, “Fira Mono”, “Ubuntu Mono”, “Oxygen Mono”, “Lucida Console”, Menlo, Monaco, monospace; font-size: 16px; line-height: 1.5; margin: 0px -24px 32px; overflow-x: auto; padding: 32px; text-wrap-mode: wrap; vertical-align: baseline;”><codeSF Mono”, Consolas, “Roboto Mono”, “Noto Mono”, “Droid Mono”, “Fira Mono”, “Ubuntu Mono”, “Oxygen Mono”, “Lucida Console”, Menlo, Monaco, monospace; line-height: 1.5; margin: 0px; outline: rgb(255, 255, 255) none 0px; padding: 0px; vertical-align: baseline;“>Ans: I generated collection letter #1 for both, then I changed the due date of oldest invoice to future date, so it was not past due then I run the create collection letter again. Hence in second run the collection letter generated has only the invoice #2 and collection letter code for invoice #2 was updated to 2. Then I changed the due date of Invoice #1 to 2-Feb-2025.<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Current system date is 22-Feb-2025

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>First invoice is oldest invoice with due date of 2nd Feb and the second invoice is due for 12th-Feb-2025.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>The Last Collection Letter Code Column determines the Collection letter code issued for a particular transaction.

For Invoice 1 last collection letter code is #1

For Invoice 2 last collection letter code is #2

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Question: - The next collection letter code the be generated when we run the “Create Collection Letter Code” process should be?

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Answer: - The next collection letter code will be based on the highest collection letter code generated among all the past due transaction. We will check this in the test scenario in this blog.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Read the below Note to Understand about the transaction level collection letter code.

In case of “Create Collection letter per customer” the highest collection letter code among all the transaction become the collection letter code for the transaction and the collection fees as determined based on that code only.

In case of “Create Collection letter per transaction” the transaction level code becomes the collection letter code hence there is no question about how system choose the collection letter.<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Now let’s proceed with the scenario

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>In this scenario, we have two invoices with different due dates and days past due.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>The system needs to determine the next collection letter code based on these transactions.

<hrSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; height: 1px; margin: 0px 0px 32px; padding: 0px; width: 584px;” /><h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Step 1 - Posting Collection Letter #1<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>When generating the first collection letter, the system will consider the following:

Invoice 1: Due on 2-Feb-25, 20 days past due, with a last collection letter code of 1.

Invoice 2: Due on 12-Feb-25, 10 days past due, with a last collection letter code of 1.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>The system will generate Collection Letter #1 for both invoices.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>After generating Collection Letter #1, the system will post the associated fees. In this case, the fees are as follows:

Collection Letter #1: INR 20

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>The collection letter date is set to 22-Feb-25, but the due date for the fees is 23-Feb-25, based on the payment term defined in the collection letter sequence (Net 1 day) for the fees (Check previous blog to understand more).

<hrSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; height: 1px; margin: 0px 0px 32px; padding: 0px; width: 584px;” /><h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Step 2 - Posting Collection Letter #2<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Now, let’s assume we change the due date of Invoice #1 to a future date and re-run the collection letter creation process. The system will now generate Collection Letter #2 for Invoice #2.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Also notice the fees posted. Hence in case even if collection letter #1 has fees higher than collection letter 2 but still the fees for collection letter 2 will be posted. Since collection letter 2 is issued in the case below.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>We can see that collection letter is generated for Invoice #2 only.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>After posting Collection Letter #2, we have the following status:

Invoice 1: Collection Letter Code 1 generated.

Invoice 2: Collection Letter Codes 1 and 2 generated.

<hrSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; height: 1px; margin: 0px 0px 32px; padding: 0px; width: 584px;” /><h3Segoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 20px; line-height: 1.25; margin: 0px 0px 16px; outline: rgba(0, 0, 0, 0.9) none 0px; padding: 0px; vertical-align: baseline;“>Step 3 - Posting Collection Letter #3<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Now If we re-run the process again how will the system determine the collection letter code. There are two possible outcomes:

If the next code is 3: This means the system is considering the highest code from all open transactions.

If the next code is 2: This means the system is considering the highest code from the oldest invoice (based on due date).

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>As we can see that collection letter code generated is Collection letter 3 (In Identification section)

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>Hence the collection letter code for next letter will be the highest code among all the past due transactions included in that letter.

<pSegoe UI”, Roboto, “Helvetica Neue”, “Fira Sans”, Ubuntu, Oxygen, “Oxygen Sans”, Cantarell, “Droid Sans”, “Apple Color Emoji”, “Segoe UI Emoji”, “Segoe UI Emoji”, “Segoe UI Symbol”, “Lucida Grande”, Helvetica, Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 0px 0px 32px; padding: 0px; pointer-events: all; vertical-align: baseline;“>If you have any questions or need further clarification, feel free to reach out in the comments section below!

Collection Letters in Dynamics 365 Finance & Operations Complete Understanding

Related Articles

Master the Dunning Process: A Step-by-Step Guide to Collection Letters in Dynamics 365 Finance