BeyondERP.Newsletter
Menu

Setup step on the Set up interest codes page · Credit and collections

Set up interest codes

Use this page to set up the interest rates you earn and pay, as a percentage, an amount or by range, and apply one code to several customer posting profiles.

Business process
Manage credit and collections
Menu item
Interest
Main table
CustInterest
Data entity
CustInterestCodeEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page for interest codes, which hold the settings for when interest is charged on overdue accounts and how it is calculated.
What you do hereUse this page to set up the interest rates you earn and pay, as a percentage, an amount or by range, and apply one code to several customer posting profiles.
ExampleFor example, an interest code can charge 5 percent for every two months that an invoice payment is past its due date.
Set up interest codes 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 › Interest › Set up interest codes
Used next byCustomer posting profiles Microsoft Learn Create interest notes Microsoft Learn
In this processSet up collection letter sequence
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 interest codes1 screen

Use this page to set up the interest rates you earn and pay, as a percentage, an amount or by range, and apply one code to several customer posting profiles.

  1. Screen 1

    Create an interest code

    Go to Credit and collections > Interest > Set up interest codes

    1. Select New
    2. Enter the interest code and description
    3. Leave the interest type as Single rate and the effective date as today
    4. Under Earnings, enter the monthly interest percentage
    5. Select the ledger posting account for interest
    6. Select Save
    1Interest codeBEAT-INT
    2DescriptionInterest
    4Ledger posting account610100
    5Monthly interest %1.5
    Create an interest code (zoomed on the outlined fields)
    Show the full screenCreate an interest code
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Credit and collections > Interest > Set up interest codes.
  2. Select New, and enter the interest code and a description.
  3. Expand the Earnings and Earnings by currency sections.
  4. In the Ledger posting account field, select the account.
  5. In the Interest by range field, select Months, then select Add and enter a description for the currency and range.
  6. Save, and then select Ranges.
  7. Add a line for each range with its From value and interest percent per month, for example 0 and 1.5, 4 and 2.0, and 7 and 2.5.
  8. Close the page.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Calculate interest everyHow often interest is calculated, as a number and a unit such as Day, Month or Calendar day.Microsoft Learn
Calculate interest based onWhether the interest value is a percentage or an amount.Microsoft Learn
Interest by rangeWhether the rate changes by invoice amount, days late or months late, or stays the same.Microsoft Learn
Monthly interest %The percentage used in the interest calculation when no range is used.Microsoft Learn 1.5
EarningsTab for the rates of interest you earn by charging customers.Microsoft Learn
PaymentsTab for the rates of interest you pay.Microsoft Learn
RangesButton to add the range lines, each with a From value and an interest value.Microsoft Learn
Grace periodNumber of days before interest is calculated.Microsoft Learn GraceDays
Interest codeThe code that identifies the interest code.Microsoft Learn STANDARDInterestCode
DescriptionA short text that describes the interest code.Microsoft Learn Interest
Ledger posting account610100

Test checklist

  1. Create an interest code (for example 2/Month, Percentage) and add it to a customer posting profile.
  2. Post an invoice for a test customer that uses that profile and let it become overdue (or use a back-dated due date).
  3. Run Credit and collections > Interest > Create interest notes with a To date after the due date.
  4. Open Review and process interest notes and check a note with status Created and the expected amount.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up interest codesOne interest code per interest policy, attached to the customer posting profiles that should bear interest. Change a rate by creating a new version effective from a future date, not by editing the current one.One code can serve several posting profiles, billing codes or invoice lines, and changes apply automatically to new transactions. Interest codes are date effective, so a new version keeps the old rate for the period it applied to.How should interest be calculated on overdue invoices?Leaving the Interest code blank on a customer posting profile, or setting the table restriction to No: no interest is calculated for transactions that use that profile.Test: Interest note created from posting profile interest code

Feature management and licence

Feature to turn on(GBL) Allow to calculate interest per day as yearly percent divided by 365 (Optional)

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Rates can be changed at any time through a new dated version; changes apply to new transactions. Interest notes already created keep their amounts.
If you change it laterInterest codes are date effective: to change a rate, create a new version that takes effect from a future date. Changes apply to new transactions. Microsoft Learn
Technical architect

6Technical

Menu itemInterest Checked in Dynamics 365
FormInterest Checked in Dynamics 365
TableCustInterestShown as “Customer interest codes” in Record infoKey field: InterestCodeChecked in Dynamics 365
Data entitiesCustInterestCodeEntityInterest codes Microsoft data model CustInterestCodeWithFeeEntityInterest codes with fees Microsoft data model CustInterestCodeWithRangeEntityInterest codes with ranges Microsoft data model CustInterestCdsEntityCustomer interest codes for CDS integration Microsoft data model
Roles to set it up and use itTo set it up or change itCollections manager CollectionLetterCollectionsManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerRental manager RentalManagerAccounting supervisor LedgerAccountingSupervisorCollections agent CollectionLetterCollectionsAgentTo use itAccounting manager LedgerAccountingManagerAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAuditor AuditPolicyManagerGive people one of these roles. On this system, 14 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=Interest
Integrate withCustInterestCodeEntity data entity Microsoft data model
Data migrationCustInterestCodeEntity (Interest codes): loaded for each company, in Microsoft's default template 140 - Accounts receivable.CustInterestCodeWithFeeEntity (Interest codes with fees): loaded for each company, in Microsoft's default template 140 - Accounts receivable.CustInterestCodeWithRangeEntity (Interest codes with ranges): loaded for each company, in Microsoft's default template 140 - Accounts receivable.Load order: Microsoft's default template 140 - Accounts receivable loads Interest codes 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 definitionCustInterest columns and relations Microsoft data model
Everyone

8Sources