BeyondERP.Newsletter
Menu

Setup page · Credit and collections

Set up collection letter sequence

A setup page for collection letter sequences, the series of collection letters sent to customers who have overdue amounts.

Used by
Auditor, Collections agent, Collections manager and 9 more roles
Business process
Manage credit and collections
Menu item
CollectionLetterCourse
Main table
CustCollectionLetterTable
Data entity
CollectionLetterCourseEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page for collection letter sequences, the series of collection letters sent to customers who have overdue amounts.
What you do hereUse this page to decide, for each letter in the sequence, whether a fee is charged, how many grace days are allowed and the minimum amount due.
ExampleFor example, the first letter in a sequence is often just a warning, and the later letters add a fee.
Set up collection letter sequence page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage credit and collections
Menu pathCredit and collections › Collection letter › Set up collection letter sequence
Used next byCustomer posting profiles Microsoft Learn Create collection letters Microsoft Learn Set up Collections process setup
Related pagesCollections process setup Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up collection letter sequence1 screen

Use this page to decide, for each letter in the sequence, whether a fee is charged, how many grace days are allowed and the minimum amount due.

  1. Screen 1

    Create a collection letter sequence

    Go to Credit and collections > Collection letter > Set up collection letter sequence

    1. Select New
    2. Enter the sequence code and description
    3. In the Overview grid, select the collection letter code
    4. Enter the minimum overdue amount and the grace days
    5. Select Save
    1Collection letter sequenceBEAT-CL
    2DescriptionCollection letters
    3Collection letter codeCollection letter 1
    Minimum overdue50.00
    Days14
    Create a collection letter sequence (zoomed on the outlined fields)
    Show the full screenCreate a collection letter sequence
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Credit and collections > Collection letter > Set up collection letter sequence.
  2. Select New, and enter the Collection letter sequence ID and a Description.
  3. In the Collection letter code field, select the first collection letter to send.
  4. Select Add for each next letter in the sequence (up to five).
  5. For letters with a fee, select the Main account, enter the fee and, if needed, the Item sales tax group.
  6. Enter the Minimum overdue balance and the grace Days for each letter.
  7. On the last letter, select Block to stop further deliveries and invoicing.
  8. On the Note FastTab, enter the text for each collection letter code.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Collection letter sequenceID of the sequence, used when you set up a posting profile.Microsoft Learn STANDARDCollectionLetterCourse
Collection letter codeThe collection letter sent at this step of the sequence.Microsoft Learn Collection letter 1CollectionLetterCode
Main accountRevenue account for the collection letter fee.Microsoft Learn LedgerDimension
Fee in currencyFee charged when this collection letter is posted.Microsoft Learn Fee
Item sales tax groupSales tax group for the fee, if sales tax applies.Microsoft Learn TaxItemGroup
Minimum overdue balanceSmallest overdue balance that triggers this letter.Microsoft Learn MinAmount
DaysGrace days after the due date (or after the previous letter) before this letter can be created.Microsoft Learn 14NumOfDays
BlockStops further deliveries and invoicing for the customer when this letter is used.Microsoft Learn Block
CurrencyCurrency of the fee; a sequence is needed for each currency you send letters in.Microsoft Learn CurrencyCode
NoteText printed on the collection letter for the selected code, with translations if needed.Microsoft Learn Notes
DescriptionA short text that describes the collection letter sequence.Microsoft Learn Collection letters
Minimum overdueThe smallest overdue balance that must be reached before this collection letter is sent.Microsoft Learn 50.00

Test checklist

  1. Attach the sequence to a customer posting profile in Customer posting profiles.
  2. Post an invoice for a test customer with that profile and make it overdue past letter 1's Days.
  3. Run Collection letter > Create collection letters and check letter 1 is created with status Created.
  4. Print and post letter 1, then check letter 2 is only created after its grace days have passed.
  5. If letter 2 has Block selected, check the customer's Invoicing and delivery on hold after posting.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up collection letter sequenceOne sequence per policy with a line for every currency you invoice in, letter 1 as a warning without fee, and the sequence attached to the customer posting profile.Letters are created only for currencies set up in a sequence, and a sequence works only once it is attached to a customer posting profile. Learn notes the first letter is often just a warning, with fees added on later letters.Should collection letters be created per transaction or per customer?Selecting Block on a letter without agreeing it with sales: posting that letter puts the customer on Invoicing and delivery on hold, which stops further deliveries and invoicing until someone sets it back to No.Test: First collection letter from posting profile
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: Sequence lines can be changed, but transactions keep the collection letter code already reached, and posted letters can't be changed. Microsoft Learn
If you change it laterLetters are sent in order: the second letter can only be printed for a customer after the first one has been printed. Microsoft Learn
Technical architect

6Technical

Menu itemCollectionLetterCourse Checked in Dynamics 365
FormCollectionLetterCourse Checked in Dynamics 365
TableCustCollectionLetterTableShown as “Collection letter setup” in Record infoKey field: CollectionLetterCourse, NameChecked in Dynamics 365
Data entitiesCollectionLetterCourseEntityCollection letter setup Microsoft data model CustCollectionLetterCourseCdsEntityCustomer collection letter setup for CDS integration. Microsoft data model
Who can open itPrivilegesMaintain collection letters setup CollectionLetterCourseMaintainView collection letters setup CollectionLetterCourseViewDutiesReview collections process performance CollectionLetterCollectionProcPerfRevieEnable collections process CollectionLetterCollectionsProcessEnableInquire into customer invoice status CustInvoiceCustomerInvoiceStatusInquireMaintain customer invoice transactions CustInvoiceCustomerInvoiceTransMaintainInquire into customer payments status PaymCustomerPaymentsStatusInquire
12 security rolesAuditor AuditPolicyManagerCollections agent CollectionLetterCollectionsAgentCollections manager CollectionLetterCollectionsManagerChief financial officer CompanyChiefFinancialOfficerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerk
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itCollections manager CollectionLetterCollectionsManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting supervisor LedgerAccountingSupervisorTo use itCollections agent CollectionLetterCollectionsAgentAccounting manager LedgerAccountingManagerAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkGive people one of these roles. On this system, 12 roles can open this page.Checked in Dynamics 365
Actions on the pageOptionsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CollectionLetterCourse
Integrate withCollectionLetterCourseEntity data entity Microsoft data model
Data migrationCollectionLetterCourseEntity (Collection letter setup): loaded for each company, in Microsoft's default template 140 - Accounts receivable.Load order: Microsoft's default template 140 - Accounts receivable loads Collection letter setup at execution unit 1, level 30, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to General ledger)Microsoft Learn
Table definitionCustCollectionLetterTable columns and relations Microsoft data model
Everyone

8Sources