BeyondERP.Newsletter
Menu

Setup page · Sales and marketing

Trade allowance management parameters

The parameters page of trade allowance management. It holds the one-time promotion template, the default customer hierarchy, the planned status, the lump sum accounts and procurement category, the deduction journal, fund analysis options, the default rebate program and the number sequences for deductions, trade allowances, merchandising events, funds and lump sum invoices.

Used by
Marketing manager, Accounts receivable clerk, Sales manager
Business process
Manage trade allowances
Menu item
TAMPromotionParameters
Main table
TAMPromotionParameters
Data entity
TAMTradeAllowanceManagementParametersEntity
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 isThe parameters page of trade allowance management. It holds the one-time promotion template, the default customer hierarchy, the planned status, the lump sum accounts and procurement category, the deduction journal, fund analysis options, the default rebate program and the number sequences for deductions, trade allowances, merchandising events, funds and lump sum invoices.
What you do hereUse this page to turn trade allowance features and rules on or off and set default values, for example for bill-backs and deductions.
ExampleBEAT's customer CUS-000214 short-pays invoice INV-004512 by 750.00 and no approved rebate matches. The A/R clerk creates deduction DED-000031, which takes its ID from the Deduction ID sequence on this page, and settles it as a one-time promotion, which uses the template PROMO-ONETIME selected here to create a new trade allowance agreement and lump sum.
Trade allowance management parameters 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

Business processManage accounts receivable › Manage trade allowances
Menu pathSales and marketing › Setup › Trade allowance › Trade allowance management parameters
Set up firstCustomer category hierarchy Microsoft Learn Templates Microsoft Learn
Used next byFunds Microsoft Learn Trade allowance agreements Microsoft Learn
Related pagesAccounts receivable parameters Microsoft Learn
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 Trade allowance management parameters1 screen

Use this page to turn trade allowance features and rules on or off and set default values, for example for bill-backs and deductions.

  1. Screen 1

    Review the trade allowance parameters

    Go to Sales and marketing > Setup > Trade allowance > Trade allowance management parameters

    1. On the Overview tab, select the planned status for new trade allowance agreements
    2. Select the customer hierarchy, the lump sum expense account and procurement category, and the deduction journal name
    3. Select the default rebate program for bill backs
    4. Select Save
    5. On the Number sequences tab, check the number sequences for trade allowance documents
    1Planned statusIn process
    Include closedNo
    Review the trade allowance parameters (zoomed on the outlined fields)
    Show the full screenReview the trade allowance parameters
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Setup > Trade allowance > Trade allowance management parameters.
  2. On the Overview tab, in One-time promotion template, select the template to use when deductions are settled as one-time promotions.
  3. Set the default customer hierarchy, the lump sum accounts and procurement category, and the deduction journal name.
  4. On the Number sequences tab, give Deduction ID and the other references a number sequence.
  5. Create a deduction on the Deduction workbench and check that its ID comes from the Deduction ID sequence.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
End of period templateShown on the page as One-time promotion template: the trade allowance agreement template used when a deduction is settled as a one-time promotion from the Deduction workbench.Microsoft Learn PROMO-ONETIMEEndOfPeriodTemplate
Planned statusThe trade allowance agreement status stored as Planned status on the parameters.Microsoft data model In processPromotionStatus
Customer hierarchyThe default customer hierarchy for trade allowances; agreements select customers from predefined hierarchies.Microsoft data model BEAT-RETAILDefaultCustHierarchy
Expense accountThe ledger account shown as Expense account; its column (LSClaimOffsetLedgerDimension) belongs to the lump sum settings of the parameters.Microsoft data model 605100LSClaimOffsetLedgerDimension
Procurement categoryThe procurement category whose column (LSProcurementCategory) belongs to the lump sum settings of the parameters.Microsoft data model PromotionsLSProcurementCategory
Deduction journal nameThe journal name used for deductions.Microsoft data model DedJrnDeductionJournal
Include closedWhether closed trade allowance agreements are included in fund analytics.Microsoft data model NoIncludeClosedInFundAnalytics
Default rebate program IDThe default rebate program ID for trade allowances; the rebate program ID is shown on the Rebates FastTab of Price details for a bill back.Microsoft Learn TA-BILLBACKRebateType

Common errors and fixes

MessageWhat to do
Settle deduction as one-time promotion can't create the agreementCreate a trade allowance template and select it in One-time promotion template on the Overview tab of this page. Microsoft Learn
Sales clerks can't see the bill back on a promotion orderSelect Enable price details on the Prices tab of Accounts receivable parameters, then open Price details from the sales order line. Microsoft Learn

Test checklist

  1. Create a trade allowance agreement template and select it as One-time promotion template.
  2. Create a deduction on the Deduction workbench and check its ID uses the Deduction ID sequence.
  3. Settle the deduction as a one-time promotion and check a new trade allowance agreement and lump sum are created.
  4. Invoice a promotion order and check the bill-back claim appears on the Bill back workbench.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Trade allowance management parametersSet the Deduction ID number sequence and Deduction journal name, and select a One-time promotion template if unmatched deductions will be settled as one-time promotionsNew deductions take their ID from the number sequence on this page, and the Settle deduction as one-time promotion action uses the template selected here.How are customer short-pays without a matching rebate settled?Not setting Enable price details on Accounts receivable parameters, so sales clerks can't see the bill-back on Price details when entering promotion orders.Test: Deduction ID and one-time promotion template

Number sequences

ReferenceShared or per companyNote
Deduction IDPer companyBEAT uses number sequence Trad_3. Checked in Dynamics 365
Trade allowance IDPer companyBEAT uses number sequence Trad_7. Checked in Dynamics 365
Merchandising event IDPer companyBEAT uses number sequence Trad_11. Checked in Dynamics 365
Fund ID number sequencePer companyBEAT uses number sequence Trad_15. Checked in Dynamics 365
Lump sum vendor invoice numberPer companyBEAT uses number sequence Trad_19. Checked in Dynamics 365
Lump sum customer invoice numberPer companyBEAT uses number sequence Trad_23. Checked in Dynamics 365
Lump sum customer invoice voucherPer companyBEAT uses number sequence Trad_27. Checked in Dynamics 365

Feature management and licence

Licence or add-inOn the live system, Marketing manager, Accounts receivable clerk and Sales 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: Defaults can be changed at any time and act on later deductions and one-time promotions; posted journals aren't changed. Microsoft Learn
If you change it laterNew deductions take their ID from the Deduction ID sequence, and one-time promotions are created from the template selected here, from the moment the parameter changes; deductions and agreements already created keep their IDs and postings. Microsoft Learn
Technical architect

6Technical

Menu itemTAMPromotionParameters Checked in Dynamics 365
FormTAMPromotionParameters Checked in Dynamics 365
TableTAMPromotionParametersShown as “Trade allowance management parameters” in Record infoChecked in Dynamics 365
Data entitiesTAMTradeAllowanceManagementParametersEntityTrade allowance management parameters Microsoft data model
Who can open itPrivilegesMaintain trade allowance parameters TAMPromotionParametersMaintainDutiesMaintain 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, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=TAMPromotionParameters
Integrate withTAMTradeAllowanceManagementParametersEntity data entity Microsoft data model
Data migrationTAMTradeAllowanceManagementParametersEntity (Trade allowance management parameters): one record per company.Load order: Load the parameters after the journal names, number sequences, customer hierarchy and the one-time promotion template they refer to.Load first: Journal names, Number sequences, Customer category hierarchy, Trade allowance templatesMicrosoft data model
Table definitionTAMPromotionParameters columns and relations Microsoft data model
Everyone

8Sources