Study guide

11.4 Collection Letter Sequences & Interest Notes

Microsoft Certified: Dynamics 365 Finance Functional Consultant Associate MB-310

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: MB-310 Exam Overview & Financial Architecture

1.1 MB-310 Exam Structure, Skills Measured & Consultant Role 1.2 Dynamics 365 Finance Architecture, Legal Entities & Global Address Book 1.3 Hands-on Lab Strategy & Preparation Framework

2 Chapter 2: Chart of Accounts & Main Accounts

2.1 Designing Chart of Accounts & Main Account Types 2.2 Main Account Categories & Ledger Account Aliases 2.3 Balance Control Accounts & Year-End Opening Account Setup 2.4 Legal Entity Overrides for Main Accounts & Dimensions

3 Chapter 3: Financial Dimensions & Account Structures

3.1 Custom & Entity-Backed Financial Dimensions 3.2 Financial Tags: Limits, Storage & Ledger Settlement Use 3.3 Account Structures, Segment Criteria & Activation 3.4 Advanced Rules & Advanced Rule Structures 3.5 Derived Dimensions & Dimension Default Templates

4 Chapter 4: Ledgers, Calendars & Currencies

4.1 Fiscal Calendars, Period Statuses & Module Access Control 4.2 Posting Layers, Multi-GAAP Reporting & the Ledger Form 4.3 Currency Exchange Types, Rate Providers & Triangulation 4.4 Accounting & Reporting Currencies (Dual-Currency Architecture) 4.5 Foreign Currency Revaluation & Revaluation Posting Profiles

5 Chapter 5: General Ledger Journals & Allocations

5.1 Journal Names & Voucher Number Sequences 5.2 Journal Control & Posting Restriction Rules 5.3 Journal Entry, the One-Voucher Rule, Validation & Posting 5.4 Reversals, Storno Corrections & Excel Integration 5.5 Ledger Allocation Rules & the Four Allocation Methods 5.6 Allocation Processing & Periodic (Recurring) Journals

6 Chapter 6: Intercompany Accounting & Settlements

6.1 Intercompany Accounting Setup & Due-To / Due-From Postings 6.2 Intercompany Journal Processing & Multi-Company Vouchers 6.3 Ledger Settlements Configuration & Processing

7 Chapter 7: Cash and Bank Management

7.1 Bank Groups, Bank Accounts & Ledger Integration 7.2 Payment Formats, Bank FX Revaluation & Shared Payment Setup 7.3 Manual vs. Advanced Bank Reconciliation & Statement Formats 7.4 Matching Rule Sets, Reconciliation Execution & Reversals 7.5 Cash Flow Forecasting Setup & Automation 7.6 Customer and Vendor Netting

8 Chapter 8: Periodic Closing & Financial Consolidations

8.1 Financial Period Close Workspace, Closing Roles & Schedules 8.2 Year-End Close Configuration & General Ledger Balance Carryforward 8.3 Consolidations Online: Legal Entity Setup, COA Mapping & Currency Translation 8.4 Import Consolidations & Intercompany Elimination Rules

9 Chapter 9: Sales Tax & Withholding Tax

9.1 Sales Tax Engine Hierarchy, Authorities & Settlement Periods 9.2 Ledger Posting Groups, Sales Tax Codes & Calculation Methods 9.3 Sales Tax Groups, Item Sales Tax Groups & Tax Exemptions 9.4 Sales Tax Adjustments and Settle and Post Sales Tax 9.5 Withholding Tax & US 1099 Vendor Reporting

10 Chapter 10: Accounts Receivable Setup & Invoicing

10.1 Customer Master, Customer Groups & Shared Customers 10.2 Customer Posting Profiles & Account Code Precedence 10.3 Free Text Invoices, Recurring Invoice Templates & AR Charges 10.4 Sales Order Invoicing, Billing Classifications & Prepayments 10.5 Customer Payment Methods, Payment Processing & Customer Bank Accounts

11 Chapter 11: Credit Management & Collections

11.1 Credit Management Architecture & Customer Credit Groups 11.2 Risk Scoring, Credit Limits, Blocking Rules & Credit Holds 11.3 Aging Definitions, Collections Workspace & Customer Pools 11.4 Collection Letter Sequences & Interest Notes 11.5 Customer Write-Offs, Bad Debt & Write-Off Reversals

12 Chapter 12: Subscription Billing & Revenue Deferrals

12.1 Recurring Contract Billing, Billing Schedules & Milestones 12.2 Deferral Principles, Deferral Defaults & Schedule Calculation Methods 12.3 Recognition Processing, Expense Deferrals & Modifying Schedules 12.4 Multiple Element Revenue Allocation (MEA / ASC 606)

13 Chapter 13: Accounts Payable & Invoice Processing

13.1 Shared Vendors, Global Address Book & Vendor Groups 13.2 Vendor Posting Profiles, AP Parameters & Vendor Bank Accounts 13.3 Invoice Matching Setup (2-Way, 3-Way), Tolerances & Exceptions 13.4 Vendor Invoicing Methods, Journals & Invoice Automation

14 Chapter 14: Vendor Payments & Expense Management

14.1 Methods of Payment & the Vendor Payment Proposal Engine 14.2 Generating Payments, Centralized Payments & Check Lifecycle 14.3 Expense Management Configuration, Categories & Policies 14.4 Expense Reports Processing, Mobile Receipts & Intercompany Expenses

15 Chapter 15: Budgeting & Budget Control

15.1 Budget Models, Budget Codes & Allocation Terms 15.2 Budget Register Entries, Workflows & Budget vs. Actual 15.3 Budget Transfer Rules & Processing Budget Transfers 15.4 Budget Control Configuration, Cycles, Rules & Budget Groups 15.5 Budget Funds Available, Over-Budget Permissions & Document Budget Check 15.6 Budget Planning Framework, Organization Hierarchies & Planning Processes 15.7 Budget Plans, Scenarios, Allocations & Generating Register Entries

16 Chapter 16: Fixed Assets Configuration & Transactions

16.1 Fixed Asset Groups, Asset Records & Group/Book Mapping 16.2 Depreciation Profiles: Methods & Conventions 16.3 Fixed Asset Books, Derived Books & Posting Profiles 16.4 Fixed Asset Acquisition Pathways 16.5 Depreciation Proposals, Multi-Company Runs & Fixed Asset Budgets 16.6 Fixed Asset Disposals: Sale, Scrap & Disposal Accounting 16.7 Fixed Asset Splits, Transfers & Reclassification 16.8 Asset Leasing (IFRS 16 / ASC 842)

11.4 Collection Letter Sequences & Interest Notes

Key Takeaways Explain This Topic AI

A collection letter sequence defines escalating letter codes with a minimum overdue days and optional fee for each step.

Collection letters are created in a batch proposal, reviewed, then printed and posted; individual customers can be excluded before posting.

The letter level advances only when a letter is actually posted, so deleting a proposed letter leaves the customer at the previous level.

Interest codes define the rate and calculation basis for interest notes, which are proposed, reviewed, and posted as separate customer transactions.

Last updated: August 2026

11.4 Collection Letter Sequences & Interest Notes

Quick Summary: When standard collection activities fail to secure customer payments, Microsoft Dynamics 365 Finance provides formal, automated statutory escalation mechanisms: Collection Letter Sequences (graduated dunning notices with progressive administrative fees), Interest Notes (automated late payment finance charges based on percentage or index rates), and Customer Write-Offs (bad debt recognition and subledger balance relief). This section details the complete configuration matrix, posting profile ledger accounts, automated voucher generation, and write-off cancellation workflows tested on the MB-310 exam.

1. Collection Letter Sequences & Escalation Hierarchy

Collection Letter Sequences govern the progressive escalation ladder applied to delinquent customer invoices. Each sequence contains a series of chronological steps that dictate when letters are produced, what fees are assessed, and whether further sales transactions should be blocked.

Navigation

Path: Credit and collections > Setup > Collection letter (Collection letter sequence setup) +---------------------------------------------------------------------------------------------------------+

  • | Collection Letter Sequence Setup Grid |
  • +---------------------------------------------------------------------------------------------------------+
  • | Sequence ID: [ STANDARD_ESC ] Description: Standard Corporate Escalation Ladder |
  • | Terms of Payment: [ Net 10 ] (Grace Period) Currency: [ USD ] |
  • +---------------------------------------------------------------------------------------------------------+
  • | ESCALATION STEPS MATRIX: |
  • | Step | Collection Letter Code | Days Overdue | Fee Amount | Currency | Block Sales Order | Account Status |
  • | :--: | ---------------------- | :----------: | :--------: | :------: | :---------------: | :------------- |
  • | 1 | `Collection letter 1` | 15 Days | $0.00 | USD | No | Open |
  • | 2 | `Collection letter 2` | 30 Days | $25.00 | USD | No | Open |
  • | 3 | `Collection letter 3` | 45 Days | $50.00 | USD | Yes | Open |
  • | 4 | `Collection letter 4` | 60 Days | $100.00 | USD | Yes | Stopped (Inv) |
  • | 5 | `Collection` | 90 Days | $250.00 | USD | Yes | Stopped (All) |
  • +---------------------------------------------------------------------------------------------------------+
  • Progression Rules & Parameters

Sequential Progression: By default, Dynamics 365 Finance requires an invoice to progress through each letter code in sequential order ( Letter 1 → \rightarrow → Letter 2 → \rightarrow → Letter 3 → \rightarrow → Letter 4 → \rightarrow → Collection ). An invoice cannot jump directly from None to Letter 3 unless the sequence is explicitly configured to allow non-sequential generation.

Days Overdue Threshold: Specifies the minimum number of days beyond the invoice due date required before the step becomes eligible.

Fee Amount: Flat administrative penalty assessed to the customer for generating the dunning notice.

Block Sales Order: When set to Yes , posting this collection letter automatically sets the customer's order hold status, preventing sales order entry and confirmation.

Terms of Payment: Defines the payment grace period printed on the letter (e.g., "Payment must be received within 10 days of this notice").

2. Periodic Creation, Processing & Posting of Collection Letters

Generating and issuing collection letters is a two-step periodic workflow: Creation (proposal) followed by Review and Posting . +---------------------------------------------------------------------------------------------+

  • | Collection Letter Two-Step Processing Pipeline |
  • +---------------------------------------------------------------------------------------------+
  • | |
  • | STEP 1: CREATION (PROPOSAL GENERATION) |
  • | Path: Credit and collections > Collection letter > Creation of collection letters |
  • | - Evaluates open invoices against Collection Letter Sequence rules. |
  • | - Filters by Customer Pool, Legal Entity, and Aging Date. |
  • | - Parameters: [X] Exclude transactions in dispute. |
  • | - Status generated: 'Created' (Proposal stage - no GL impact). |
  • | |
  • | | |
  • | v |
  • | |
  • | STEP 2: REVIEW & POSTING |
  • | Path: Credit and collections > Collection letter > Review and process collection letters |
  • | - Credit manager reviews proposed letters, edits fee amounts, or deletes lines. |
  • | - Executes 'Post' action: |
  • | 1. Updates invoice status to current Collection Letter Code (e.g., Letter 2). |
  • | 2. Generates printed/electronic PDF dunning document. |
  • | 3. Posts General Ledger financial voucher for administrative fees! |
  • +---------------------------------------------------------------------------------------------+
  • Collection Letter Fee Accounting Voucher

When a collection letter with an assessed administrative fee is posted, Dynamics 365 Finance posts a financial voucher configured in the Customer Posting Profile ( Accounts receivable > Setup > Customer posting profiles > Setup FastTab > Collection letter fee ): +-----------------------------------------------------------------------------+

  • | Collection Letter Fee Accounting Entry |
  • +-----------------------------------------------------------------------------+
  • | Account Description | Main Account | Debit Amount | Credit Amount |
  • | ------------------------------------ | ------------ | ------------ | ------------- |
  • | Accounts Receivable (Customer) | `130100` | $50.00 | |
  • | Collection Letter Fee Revenue | `450200` | | $50.00 |
  • | **TOTAL BALANCED VOUCHER** | | **$50.00** | **$50.00** |
  • +-----------------------------------------------------------------------------+
  • 3. Interest Codes & Interest Note Calculation

Interest Codes define the terms and mathematical formulas used to calculate late payment interest (finance charges) on overdue balances.

Navigation

Path: Credit and collections > Setup > Interest (Interest codes setup) +---------------------------------------------------------------------------------------------+

  • | Interest Code Anatomy: [ LATE_FIN_01 ] |
  • +---------------------------------------------------------------------------------------------+
  • | General Tab: |
  • | - Calculate interest based on: ......... [ Days ] (Options: Days / Months) |
  • | - Grace period: ........................ [ 5 Days ] |
  • | - Minimum interest amount: ............. [ $15.00 ] |
  • | - Calculate interest on: ............... [ Percentage ] (Options: Percentage / Amount / Idx)|
  • +---------------------------------------------------------------------------------------------+
  • | Earnings FastTab (Posting Setup): |
  • | - Ledger posting group / Main account: . [ 450100 - Finance Charge & Interest Income ] |
  • | - Write-off account: ................... [ 605100 - Bad Debt Expense ] |
  • +---------------------------------------------------------------------------------------------+
  • | Rates Tab: |
  • | From Date | To Date | Interest % | Calculation Method | Interval Units |
  • | ----------- | ------------ | :---------: | ------------------ | --------------------------- |
  • | 01/01/2026 | 12/31/2026 | 18.0000 % | Annual Rate (APR) | Daily Accrual (APR / 365) |
  • +---------------------------------------------------------------------------------------------+
  • Core Calculation Parameters

Calculate Interest Based On:

Percentage: Applies a fixed annual percentage rate (APR) converted to a daily or monthly periodic rate.

Amount / Tiered Rates: Configures progressive interest rates based on the number of days overdue (e.g., 1–30 days = 10%, 31–60 days = 15%, > 60 days = 20%).

Interest Index Rate: Dynamically links interest to a floating financial market benchmark (e.g., Fed Funds Effective Rate + 5.0% margin ).

Grace Period: Number of days after the invoice due date during which no interest is assessed. If paid within the grace period, zero interest applies; once the grace period expires, interest calculates retroactively from day 1 past due or from the grace cutoff date based on parameter setup.

Minimum Interest Amount: If calculated interest is below this threshold (e.g., $15.00), no interest note is generated, preventing uneconomical micro-invoicing.

Creation & Posting of Interest Notes

Creation: Credit and collections > Interest > Creation of interest notes (Generates interest note proposals).

Posting: Credit and collections > Interest > Review and process interest notes (Posts voucher and generates customer statement). +-----------------------------------------------------------------------------+

  • | Interest Note Accounting Entry |
  • +-----------------------------------------------------------------------------+
  • | Account Description | Main Account | Debit Amount | Credit Amount |
  • | ------------------------------------ | ------------ | ------------ | ------------- |
  • | Accounts Receivable (Customer) | `130100` | $187.50 | |
  • | Interest & Finance Charge Income | `450100` | | $187.50 |
  • | **TOTAL BALANCED VOUCHER** | | **$187.50** | **$187.50** |
  • +-----------------------------------------------------------------------------+

Loading diagram... Delinquent Debt Escalation, Letter Progression, Interest, Write-Off, and Reversal Flow