BeyondERP.Newsletter
Menu

Setup step on the Deduction write-off reasons page · Sales and marketing

Set up Deduction write-off reasons

Use this page to give users a reason code to select when they write off a deduction, with a posting account and an optional maximum amount.

Used by
Collections manager
Business process
Manage customer deductions on payments in Dynamics 365 Finance
Menu item
TAMDeductionWriteOffReason
Main table
TAMDeductionWriteOffReasonTable
Data entity
TAMPaymentDeductionWriteOffReasonCodeEntity
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 where you create reason codes that explain why a deduction is written off on the deduction workbench.
What you do hereUse this page to give users a reason code to select when they write off a deduction, with a posting account and an optional maximum amount.
ExampleFor example, BEAT writes off small deduction balances up to 25.00 with reason SMALLBAL to account 681200, so a 12.40 rounding short-pay from BEAT-000123 is closed in one step.
Deduction write-off reasons 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

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 Deduction write-off reasons1 screen

Use this page to give users a reason code to select when they write off a deduction, with a posting account and an optional maximum amount.

  1. Screen 1

    Create a deduction write-off reason

    Go to Sales and marketing > Trade allowances > Deductions > Deduction write-off reasons

    1. Select New
    2. Enter the reason code and description
    3. Optionally enter the maximum amount that can be written off with this reason
    4. Select the main account the write-off posts to
    5. Select Save
    1Reason codeBEAT-DWO
    DescriptionWrite-off reason
    Maximum write-off100.00
    Main account610100
    Create a deduction write-off reason (zoomed on the outlined fields)
    Show the full screenCreate a deduction write-off reason
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Trade allowances > Deductions > Deduction write-off reasons.
  2. Select New.
  3. Enter a reason code and a description.
  4. Enter the maximum write-off amount allowed for the reason code (0 means no maximum).
  5. Enter the main account to post to in the ledger.
  6. Repeat for every reason code you need.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Maximum write-off amountThe largest amount that can be written off with this reason; 0 means there is no maximum.Microsoft Learn 25.00TAMDeductionWriteOffMaxAmountMST
Main accountThe ledger account that write-offs with this reason post to.Microsoft Learn 681200DeductWriteOffRsnLedgerDimension
Reason codeThe unique code for the reason a deduction is written off.Checked in Dynamics 365SMALLBALTAMDeductionWriteOffReason
DescriptionA short description of the reason.Checked in Dynamics 365Write-off reasonDescription
Maximum write-offThe largest amount that can be written off with this reason; 0 means there is no maximum.Microsoft Learn 25.00

Common errors and fixes

MessageWhat to do
A write-off was posted with the wrong reason.Select the deduction (Show Closed) and select Reverse write-off, then write it off again with the right reason. Microsoft Learn

Test checklist

  1. Create a write-off reason code with a Main account.
  2. On the Deduction workbench, mark a deduction created with Create claim journal Yes, select Maintain > Write-off and pick the reason.
  3. Set Show to Closed and check Remaining amount 0.00, Claim status Write-off, and an entry with Update type Write-off on the Deduction events tab.
  4. Check the posted claim journal voucher uses the reason's account, then select Reverse write-off and check the Reverse write-off event.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Deduction write-off reasonsGive each write-off reason the Main account that write-offs of that kind must post to.When a deduction with a claim journal is written off, a claim journal is posted to the deduction's write-off reason code, so the reason decides where the write-off lands in the ledger.Using one generic reason for every write-off puts all write-offs in one account and loses the reason for analysis on the Deduction events tab.Test: Write off and reverse a deduction

Feature management and licence

Licence or add-inOn the live system, Collections manager use this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: A write-off can be undone with Reverse write-off, which posts a reversing claim journal and reopens the deduction.
If you change it laterWhen a deduction with a claim journal is written off, a claim journal is posted to the deduction's write-off reason code and the deduction closes with Claim status Write-off; Reverse write-off posts a reversing claim journal. Microsoft Learn
Technical architect

6Technical

Menu itemTAMDeductionWriteOffReason Checked in Dynamics 365
FormTAMDeductionWriteOffReason Checked in Dynamics 365
TableTAMDeductionWriteOffReasonTableShown as “Deduction write-off reasons” in Record infoKey field: TAMDeductionWriteOffReasonChecked in Dynamics 365
Data entitiesTAMPaymentDeductionWriteOffReasonCodeEntityPayment deduction write off reason code Microsoft data model
Who can open itPrivilegesMaintain deduction write-off reasons TAMDeductionWriteOffReasonMaintainDutiesMaintain customer deductions information TAMCustDeductionMaintain
1 security roleCollections manager CollectionLetterCollectionsManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itCollections manager CollectionLetterCollectionsManagerGive people one of these roles. On this system, 1 role 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=TAMDeductionWriteOffReason
Integrate withTAMPaymentDeductionWriteOffReasonCodeEntity data entity Microsoft data model
Data migrationTAMPaymentDeductionWriteOffReasonCodeEntity (Payment deduction write off reason code): loaded for each company.Load order: No default configuration template places this entity. Load the write-off reasons after the main accounts they post to.Load first: Main accountsMicrosoft Learn
Table definitionTAMDeductionWriteOffReasonTable columns and relations Microsoft data model
Everyone

8Sources

To cite this step: SM-TAM-040, Set up Deduction write-off reasons. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SM-TAM-040