BeyondERP.Newsletter
Menu

Setup step on the Broker contracts page · Accounts payable

Set up Broker contracts

Records the negotiated terms under which a broker earns a fee for reaching sales targets, so that claims can be generated, approved and paid through Accounts payable.

Used by
Marketing manager, Sales manager
Business process
Establish broker commissions in Dynamics 365 Supply Chain Management
Menu item
MCRBrokerContractTable
Main table
MCRBrokerContractTable
Data entity
MCRBrokerContractHeaderEntity
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 broker contract records an agreement with a broker: the negotiated terms under which the brokerage company earns a monetary reward for reaching preset sales targets.
What you do hereUse this page to register broker contracts, including the qualifying conditions and items, the reward break, and the broker fee charge that determines who incurs the fee; the contract must be Approved to apply to sales orders.
ExampleWhen a sales order with qualifying lines is invoiced, a broker claim is generated for the invoice line and the accrued broker fee is posted.
Broker contracts 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 Broker contracts1 screen

Records the negotiated terms under which a broker earns a fee for reaching sales targets, so that claims can be generated, approved and paid through Accounts payable.

  1. Screen 1

    Create the broker contract

    Go to Accounts payable > Broker and royalties > Broker contracts

    1. Select New
    2. Fill in the broker contract row in the Broker contracts grid
    3. Leave the Contract details grid empty unless you need specific charge lines
    1Broker contractBEAT-BROKER
    DescriptionPlanning only
    Broker vendor accountBEAT-000001
    From date10/7/2026
    To date12/31/2026
    CategoryPcs.
    Charges value0.00
    Charges currencyUSD
    Create the broker contract (zoomed on the outlined fields)
    Show the full screenCreate the broker contract
    page title tab to open what to set or check

How to use it

  1. Go to Accounts payable > Broker and royalties > Broker contracts.
  2. Select New to add a broker contract, then fill in the Broker contract code, Description and Broker vendor account.
  3. Enter the From date and To date, and the Charges code, Category and Charges value.
  4. In Contract details, select Add line and fill in the Product code type, Item relation, Party code type and Break type.
  5. Select Remove to delete a selected contract line.
  6. Select Save.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
Contract detailsThe conditions and the item that qualifies for the broker fee.Microsoft Learn
BreakThe reward the broker gets for reaching the sales target.Microsoft Learn Amount
StatusMust be Approved before the contract applies to sales orders.Microsoft Learn Status
Broker contractThe code that identifies the broker contract.Microsoft Learn CUSTOMS
DescriptionA short description of the broker contract.Checked in Dynamics 365Planning onlyDescription
Broker vendor accountThe vendor account of the broker who earns the fee.Microsoft Learn BEAT-000001BrokerID
From date10/7/2026FromDate
To date12/31/2026ToDate
CategoryPcs.
Charges value0.00Value
Charges currencyUSD

Test checklist

  1. Create an Approved broker contract for a test item and break, linked to a broker fee charge.
  2. Create and invoice a sales order line that meets the contract conditions.
  3. Check the voucher for the accrued broker fee and check that a claim appears on Broker claims.
  4. Approve the claim and check that a vendor invoice for the broker is created.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Broker contractsSet up the broker fee charge first (Ledger account on both Debit and Credit when the company bears the fee; Customer/Vendor on Debit when the customer bears it), then set the contract Status to ApprovedWho incurs the fee is controlled by the linked charge, and only Approved contracts are applied to qualifying sales orders.Leaving the contract in a status other than Approved: sales orders that meet the conditions don't pick it up, so no claim is generated when the sales invoice posts.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: Each sales invoice that qualifies generates a broker claim and posts the accrued fee charge. Changing the contract later doesn't change claims or accruals already posted.
If you change it laterWho pays the broker fee is set on the linked charge: if the company pays it as a sales expense, both the debit and credit sides of the charge must post to ledger accounts. Microsoft Learn
Technical architect

6Technical

Menu itemMCRBrokerContractTable Checked in Dynamics 365
FormMCRBrokerContractManagement Checked in Dynamics 365
TableMCRBrokerContractTableShown as “Broker contract header” in Record infoKey field: ContractIDChecked in Dynamics 365
Data entitiesMCRBrokerContractHeaderEntityBroker contract headers Microsoft data model
Who can open itPrivilegesMaintain broker contracts MCRBrokerContractTableMaintainView broker contracts MCRBrokerContractTableViewDutiesMaintain 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
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=MCRBrokerContractTable
Integrate withMCRBrokerContractHeaderEntity data entity Microsoft data model
Data migrationMCRBrokerContractHeaderEntity (Broker contract headers): loaded for each company.Microsoft Learn
Table definitionMCRBrokerContractTable columns and relations Microsoft data model
Everyone

8Sources

To cite this step: AP-BROKER-010, Set up Broker contracts. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/AP-BROKER-010