BeyondERP.Newsletter
Menu

Setup page · Credit and collections

Customer write-off reason codes

A setup page for the reason codes used on customer write-off transactions.

Used by
Auditor, Collections manager, Accounts receivable clerk and 5 more roles
Business process
Write off bad debt
Menu item
CustWriteOffFinancialReasonsSetup
Main table
CustWriteOffFinancialReasonsSetup
Data entity
CustWriteOffFinancialReasonsSetupEntity
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 the reason codes used on customer write-off transactions.
What you do hereUse it to set up the write-off reason codes that are applied when customer balances are written off.
ExampleFor example, the settle remainder feature takes its default reason code from these write-off reason codes, and the account linked to the code becomes the default settle remainder account.
Customer write-off reason 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 accounts receivable › Write off bad debt
Menu pathCredit and collections › Setup › Customer write-off reason codes
Used next byAccounts receivable parameters Microsoft Learn
Related pagesVendor write-off reason codes Microsoft Learn Customer reason codes 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 Customer write-off reason codes1 screen

Set up the reason codes that are used when customer balances are written off.

  1. Screen 1

    Create the customer write-off reason code

    Go to Accounts receivable > Setup > Customer write-off reason codes

    1. Select New
    2. Enter the reason code, description and write-off account
    3. Leave Default cleared
    1Reason codeBEAT-CRED
    DescriptionCredit adjustment
    Write-off account610100
    Create the customer write-off reason code (zoomed on the outlined fields)
    Show the full screenCreate the customer write-off reason code
    page title tab to open what to set or check

How to use it

  1. Go to Credit and collections > Setup > Customer write-off reason codes.
  2. Type in the Filter box to find a reason code.
  3. Select New to add a reason code.
  4. Fill in the Company, Reason code, Description and Write-off account.
  5. Select Edit to change a code, or Delete to remove one.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
Reason codeThe code that identifies the write-off reason.Microsoft Learn SMALLBALReason
DescriptionA short text that describes the write-off reason.Microsoft Learn Credit adjustmentDescription
Write-off account610100WriteOffLedgerDimension

Test checklist

  1. Create a write-off reason code with a write-off account.
  2. In Accounts receivable parameters, Collections tab, set the Write-off journal and default reason code.
  3. From Aged balances, write off a test customer balance.
  4. In General journals, check the write-off journal has the customer line and the ledger line on the expected write-off account.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Customer write-off reason codesOne write-off reason code per type of write-off, each with its own Write-off account, plus one default code for the Write-off section in parameters and for Settle remainder.When a remainder is settled, the settlement account comes from the account on the reason code, and the default settle remainder account is taken from the default reason code. Separate codes give separate accounts without users typing accounts by hand.Users change the reason in the Settle remainder dialog without noticing that the settlement account changes with it, so the remainder posts to a different ledger account than expected.Test: Write-off from Collections uses the reason code
Solution architect

5Design impact

Can it be undoneReversible: The default write-off reason is set in Accounts receivable parameters (Collections tab, Write-off) and can be overridden when each write-off is made. Changing a code affects later write-offs only. Microsoft Learn
If you change it laterWhen the remainder of a settlement is written off, the settlement account follows the reason code, so changing the reason changes the account used. Microsoft Learn
Technical architect

6Technical

Menu itemCustWriteOffFinancialReasonsSetup Checked in Dynamics 365
FormCustWriteOffFinancialReasonsSetup Checked in Dynamics 365
TableCustWriteOffFinancialReasonsSetupShown as “Customer write-off reason codes” in Record infoChecked in Dynamics 365
Data entitiesCustWriteOffFinancialReasonsSetupEntityCustomer write-off reason codes Microsoft data model
Who can open itPrivilegesProcess settle remainder for customers CustSettlementWriteOffProcessMaintain customer write-off reason code setup CustWriteOffFinancialReasonsSetupMaintainView customer write-off reason code setup CustWriteOffFinancialReasonsSetupViewDutiesEnable collections process CollectionLetterCollectionsProcessEnableInquire into invoice and cash policies CustInvoiceInvoiceAndCashPoliciesInquirMaintain customer payments PaymCustomerPaymentsMaintain
8 security rolesAuditor AuditPolicyManagerCollections manager CollectionLetterCollectionsManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorAccounts 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 LedgerAccountingSupervisorAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkTo use itAccounting manager LedgerAccountingManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAuditor AuditPolicyManagerGive people one of these roles. On this system, 8 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CustWriteOffFinancialReasonsSetup
Integrate withCustWriteOffFinancialReasonsSetupEntity data entity Microsoft data model
Data migrationCustWriteOffFinancialReasonsSetupEntity (Customer write-off reason codes): shared by all companies, in Microsoft's default template 140 - Accounts receivable.Load order: Microsoft's default template 140 - Accounts receivable loads Customer write-off reason 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 definitionCustWriteOffFinancialReasonsSetup columns and relations Microsoft data model
Everyone

8Sources