BeyondERP.Newsletter
Menu

Page · Sales and marketing

Trade allowance agreements

A list page where you record trade allowance agreements, which reward customers for reaching volume or behavior goals.

Used by
Marketing manager, Accounts receivable clerk, Sales manager
Business process
Manage trade allowances
Menu item
TAMListPage
Main table
TAMTradePromotion
Data entity
TAMTradeAllowanceAgreementHeaderEntity
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 list page where you record trade allowance agreements, which reward customers for reaching volume or behavior goals.
What you do hereUse this page to plan a promotion by allocating funds, choosing customers and items, and setting goals for each merchandising event.
ExampleFor example, BEAT sets up agreement TA-000045 for its spring promotion with three supermarket chains: 5,000 base units, a 20 percent lift, financed 100 percent from fund FND-2027-01, and a bill back of 0.50 per unit cumulated by month and paid as a customer deduction.
Trade allowance agreements 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.

Setup steps on this page

Set up and confirm trade allowance agreements

Use this page to plan a promotion by allocating funds, choosing customers and items, and setting goals for each merchandising event.

Steps from Microsoft

  1. Go to Sales and marketing > Trade allowances > Trade allowance agreements and create a new agreement.
  2. On the General FastTab, enter the Order from and Order to dates, and in the Analysis section the Base units and Lift percent.
  3. On the Customers FastTab, select the customer hierarchy and the accounts the allowance targets.
  4. On the Items FastTab, add the products of the promotion.
  5. On the Funds FastTab, add the approved fund and the event cost allocation percentage.
  6. Switch to Lines view, add the merchandising events, and on the Amounts tab set the rules and quantity or amount ranges.
  7. Set the agreement's status to Confirmed so that it applies to sales orders.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Order fromThe first date of the period when the agreement is valid.Microsoft Learn
Order toThe last date of the period when the agreement is valid.Microsoft Learn
Base unitsThe quantity that must be sold to the chosen customers before the promotion applies.Microsoft Learn BaseUnits
Lift percentThe planned target increase in sales for the promotion.Microsoft Learn LiftPercent
Trade allowance costThe cost of the agreement, calculated from the quantities of its events.Microsoft Learn MerchandiseCost
Event cost allocationThe share of the promotion's cost that each fund pays.Microsoft Learn
Merchandising eventsThe types of events the agreement covers.Microsoft Learn
Cumulate sales byThe period over which sales are added up for a bill back.Microsoft Learn
Payment typeHow the bill back is settled.Microsoft Learn

Common errors and fixes

MessageWhat to do
The agreement isn't applied to sales orders that meet its conditions.Set the agreement's status to Confirmed; with Internal approved the agreement isn't valid yet. Check the order date is between Order from and Order to. Microsoft Learn

Test checklist

  1. Create a fund with Status Approved, then a trade allowance agreement with customers, items, the fund and a Bill back merchandising event.
  2. Set the agreement to Confirmed.
  3. Create a sales order line that meets the conditions and check Price details > Rebates shows the bill back and rebate program ID (Enable price details must be on).
  4. Post the invoice and check a bill-back claim is created on the Bill back workbench.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up and confirm trade allowance agreementsAllocate only approved funds with event cost allocations that total 100 percent, settle the bill back rules on the Amounts tab, and set the status to Confirmed only when the promotion is agreed.An agreement applies to sales orders only once it is Confirmed, and from then on each posted invoice line under it generates a bill-back claim.Leaving the agreement in Internal approved and expecting bill backs on the promotion's orders; an agreement in that status isn't valid for sales order processing.Test: A confirmed agreement creates a bill-back claim at invoicing

Feature management and licence

Licence or add-inOn the live system, Sales manager, Marketing manager and Accounts receivable clerk 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 undoneHard to reverse: While the status is Internal approved the agreement isn't valid and can still be reworked. Once it's Confirmed it applies to qualifying sales orders, and each posted sales invoice line generates a bill-back claim. Approve the funds (Status Approved) and settle the rules on the Amounts tab before you confirm. Microsoft Learn
If you change it laterAn agreement applies to sales orders only once its status is Confirmed. Microsoft Learn
Technical architect

6Technical

Menu itemTAMListPage Checked in Dynamics 365
FormTAMListPage Checked in Dynamics 365
TableTAMTradePromotionShown as “Trade allowance” in Record infoChecked in Dynamics 365
Data entitiesTAMTradeAllowanceAgreementHeaderEntityTrade allowance agreement headers Microsoft data model
Who can open itPrivilegesMaintain trade allowance agreements TAMListPageMaintainDutiesMaintain trade allowances TAMMaintain
3 security rolesMarketing manager CRMMarketingManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkSales manager TradeSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itSales manager TradeSalesManagerMarketing manager CRMMarketingManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkGive people one of these roles. On this system, 3 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=TAMListPage
Integrate withTAMTradeAllowanceAgreementHeaderEntity data entity Microsoft data model
Data migrationTAMTradeAllowanceAgreementHeaderEntity (Trade allowance agreement headers): loaded for each company.Load order: No default configuration template places this entity. Load the agreement headers after the funds, customer category hierarchies and products they refer to, then confirm the agreements in the system.Load first: Funds, Customer category hierarchy, Released productsMicrosoft Learn
Table definitionTAMTradePromotion columns and relations Microsoft data model
Everyone

8Sources