BeyondERP.Newsletter
Menu

Setup step on the Deduction types page · Sales and marketing

Set up Deduction types

Use this page to set the offset account that is used when a deduction of each type is posted, matched or written off.

Used by
Collections manager
Business process
Manage customer deductions on payments in Dynamics 365 Finance
Menu item
TAMDeductionType
Main table
TAMDeductionTypeTable
Data entity
TAMPaymentDeductionTypeEntity
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 deduction types that describe the different kinds of rebates customers might deduct from their payments.
What you do hereUse this page to set the offset account that is used when a deduction of each type is posted, matched or written off.
ExampleFor example, BEAT sets up deduction type PROMO with Deduction offset 131500, so the offsetting transactions of every promotion deduction land on 131500 until they are matched or written off.
Deduction types 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 types1 screen

Use this page to set the offset account that is used when a deduction of each type is posted, matched or written off.

  1. Screen 1

    Create a deduction type

    Go to Sales and marketing > Trade allowances > Deductions > Deduction types

    1. Select New
    2. Enter the deduction type and description
    3. Select the deduction offset account used when a deduction of this type is posted, matched or written off
    4. Select Save
    1TypeBEAT-DT
    DescriptionDeduction type
    Deduction offset610100
    Create a deduction type (zoomed on the outlined fields)
    Show the full screenCreate a deduction type
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Trade allowances > Deductions > Deduction types.
  2. Select New.
  3. Enter a name and description for the deduction type.
  4. In the Deduction offset field, select the offset account.
  5. Repeat for every deduction type you need.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Deduction offsetThe ledger offset account used when a deduction of this type is posted, matched or written off; it is copied to the deduction when it is created.Microsoft Learn 131500DeductOffLedgerDimension
TypeThe identifier of the deduction type, selected on deduction reasons and on deductions in the customer payment journal.Microsoft Learn PROMOTAMDeductionType
DescriptionA short description of the deduction type.Checked in Dynamics 365Deduction typeDescription

Common errors and fixes

MessageWhat to do
Offsetting deduction transactions post to the wrong ledger account.Correct the Deduction offset on the type before new deductions are created; existing deductions keep the account they got when created. Microsoft Learn

Test checklist

  1. Create a deduction type with a Deduction offset account and link it in Type on a deduction reason.
  2. On the Deduction workbench, create a new deduction with that reason and Create claim journal set to Yes.
  3. Open the claim journal voucher from the References tab and check that the offsetting transactions are posted to the type's Deduction offset account.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Deduction typesSet a Deduction offset ledger account on every deduction type before any deduction is created.The type's Deduction offset is copied to the deduction when it is created, and the two offsetting transactions of a new deduction are posted to that ledger account.Fixing the offset account on the type after deductions exist doesn't change those deductions, because the value is set when each deduction or claim is created; they still post to the old account.Test: A new deduction posts to the type's offset account

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: The Deduction offset is copied to each deduction at creation. A change affects new deductions only.
If you change it laterThe type's Deduction offset is copied to the deduction when it is created, and the two offsetting transactions of a new deduction are posted to that account. A change affects new deductions only. Microsoft Learn
Technical architect

6Technical

Menu itemTAMDeductionType Checked in Dynamics 365
FormTAMDeductionType Checked in Dynamics 365
TableTAMDeductionTypeTableShown as “Deduction types” in Record infoKey field: TAMDeductionTypeChecked in Dynamics 365
Data entitiesTAMPaymentDeductionTypeEntityPayment deduction types Microsoft data model
Who can open itPrivilegesMaintain deduction types TAMDeductionTypeMaintainDutiesMaintain 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=TAMDeductionType
Integrate withTAMPaymentDeductionTypeEntity data entity Microsoft data model
Data migrationTAMPaymentDeductionTypeEntity (Payment deduction types): loaded for each company.Load order: No default configuration template places this entity. Load the deduction types after the main accounts, and before the deduction reasons that refer to them.Load first: Main accountsMicrosoft Learn
Table definitionTAMDeductionTypeTable columns and relations Microsoft data model
Everyone

8Sources

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