BeyondERP.Newsletter
Menu

Setup page · Accounts payable

Differential reasons

A setup page of reason codes used when broker claims are closed with differences, each linked to a write-off main account.

Used by
Marketing manager, Sales manager
Business process
Calculate and pay broker commissions in Dynamics 365 Supply Chain Management
Menu item
MCRBrokerDifferentialReason
Main table
MCRBrokerWriteOffReason
Data entity
MCRBrokerDifferentialReasonCodeEntity
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 of reason codes used when broker claims are closed with differences, each linked to a write-off main account.
What you do hereUse this page to define the reason codes and the write-off expense account used when a broker claim's approved amount differs from the qualified amount.
ExampleWhen you close a partially approved broker claim, the system prompts for a reason code that explains the difference.
Differential 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 Differential reasons1 screen

Defines reason codes, each with a write-off main account, that explain and post the difference when a broker claim is closed for less than the qualified fee.

  1. Screen 1

    Create the differential reason

    Go to Accounts payable > Broker and royalties > Differential reasons

    1. Select New
    2. Enter the reason code, description and main account
    1ReasonBEAT-DIFF
    DescriptionBroker differential
    Main account610100
    Create the differential reason (zoomed on the outlined fields)
    Show the full screenCreate the differential reason
    page title tab to open what to set or check

How to use it

  1. Go to Accounts payable > Broker and royalties > Differential reasons.
  2. Select New to add a row.
  3. Enter the Reason code and a Description.
  4. Choose the Main account.
  5. Select Edit to change an existing reason, or Delete to remove the selected one.
  6. Select Save if the page is in edit mode.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
Main accountThe write-off expense account used for a reason code.Microsoft Learn 610100WriteOffLedgerDimension
ReasonThe code of the reason used when a broker claim is closed with a difference.Microsoft Learn PRICE
DescriptionA short description of the differential reason.Checked in Dynamics 365Broker differentialDescription

Test checklist

  1. Create a reason code with a write-off main account.
  2. Partially approve a broker claim after a sales return so that a Difference remains.
  3. Close the claim, select the reason code, and check the Differentials tab.
  4. In a customer-pays scenario, check that the differential journal posts to the reason's main account.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Differential reasonsOne reason code per cause of difference (for example returns), each with the broker fee write-off main accountClosing a claim with an outstanding difference prompts for a reason code, and the Main account on that code is the write-off account for the differential journal.Pointing every reason at a general expense account: when the customer pays the broker fee, the differential journal posts to this account, so the write-off ends up mixed with unrelated costs.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Reason codes and their accounts can be changed at any time; differential journals already posted keep the account they used. Microsoft Learn
Technical architect

6Technical

Menu itemMCRBrokerDifferentialReason Checked in Dynamics 365
FormMCRBrokerWriteOffReason Checked in Dynamics 365
TableMCRBrokerWriteOffReasonShown as “Broker differential reasons” in Record infoChecked in Dynamics 365
Data entitiesMCRBrokerDifferentialReasonCodeEntityBroker differential reason codes Microsoft data model
Who can open itPrivilegesMaintain differential reasons MCRBrokerDifferentialReasonMaintainDutiesMaintain broker information MCRBrokerMaintain
2 security rolesMarketing manager CRMMarketingManagerSales manager TradeSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerMarketing manager CRMMarketingManagerGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=MCRBrokerDifferentialReason
Integrate withMCRBrokerDifferentialReasonCodeEntity data entity Microsoft data model
Data migrationMCRBrokerDifferentialReasonCodeEntity (Broker differential reason codes): loaded for each company.Microsoft Learn
Table definitionMCRBrokerWriteOffReason columns and relations Microsoft data model
Everyone

8Sources