BeyondERP.Newsletter
Menu

Page · Sales and marketing

Trade allowance activity

An inquiry page that shows the details, documents, payments and events of a trade allowance agreement.

Used by
Marketing manager, Accounts receivable clerk, Sales manager
Business process
Manage trade allowances
Menu item
TAMTradePromotionAnalysis
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 isAn inquiry page that shows the details, documents, payments and events of a trade allowance agreement.
What you do hereUse this page to see a promotion's key figures, such as quantities sold, amounts invoiced and bill-backs paid.
ExampleFor example, after BEAT's spring promotion TA-000045 ends, the marketing manager opens it here and sees 6,200 units sold, 74,400.00 invoiced and 3,100.00 of bill-backs paid against a planned lift of 20 percent.
Trade allowance activity 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 › Trade allowances › Trade allowance analysis › Trade allowance activity
Set up firstBill back workbench Microsoft Learn
Used next byActual cost report Microsoft Learn
Related pagesTrade allowance agreements 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.

Setup steps on this page

Review a promotion's results on Trade allowance activity

Use this page to see a promotion's key figures, such as quantities sold, amounts invoiced and bill-backs paid.

Steps from Microsoft

  1. Go to Sales and marketing > Trade allowances > Trade allowance analysis > Trade allowance activity.
  2. Under Search criteria, choose a Trade allowance ID and a Status, and under Search date the From date and To date.
  3. On the Overview tab, select the trade allowance to see its main details.
  4. Open the Summary tab for the quantity sold, the amount invoiced and the bill-backs and lump sums paid.
  5. Open the Bill back credits tab for the bill-backs credited to the customer, and the other tabs for shipments, invoices, lump sum credits and deductions.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
SummaryShows the quantity sold under the promotion, the amount invoiced and the bill-backs and lump sums paid.Microsoft Learn
Bill back creditsShows each bill-back credited to the customer.Microsoft Learn

Common errors and fixes

MessageWhat to do
The Summary tab shows no bill-backs paid for a promotion with invoices.Process the bill-back claims on the Bill back workbench and create the credit note from Settle transactions > Functions > Bill back program. Microsoft Learn

Test checklist

  1. Confirm a trade allowance agreement with a Bill back merchandising event, then post a sales invoice for a customer and item in the agreement.
  2. On the Bill back workbench, cumulate, approve and process the claim, then create the credit note from Settle transactions > Functions > Bill back program.
  3. Open Trade allowance activity for the agreement and check that the Summary tab shows the quantity sold, the invoiced amount and the bill-backs paid.
  4. Check that the Bill back credits tab lists the bill-back credited to the customer.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Review a promotion's results on Trade allowance activitySearch by Trade allowance ID and set the Search date range to the agreement's order period before reading the Summary tab.The Summary and Bill back credits tabs show what was sold, invoiced and paid under the agreement; a narrower date range leaves out part of the promotion.Reading bill-backs paid as the full promotion cost while claims are still waiting on the Bill back workbench.Test: Trade allowance activity shows a credited bill-back

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 undoneReversible: This is an inquiry. It shows the agreement's documents, payments and events but doesn't change them, so there is nothing to undo here. Microsoft Learn
If you change it laterNothing changes: the page reads the agreement's documents and payments. Its figures grow as invoices are posted and bill-back claims are processed and credited. Microsoft Learn
Technical architect

6Technical

Menu itemTAMTradePromotionAnalysis Checked in Dynamics 365
FormTAMTradePromotionAnalysis 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 itPrivilegesView trade allowance activity TAMTradePromotionsAnalysisViewDutiesMaintain 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 use itSales manager TradeSalesManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkMarketing manager CRMMarketingManagerGive 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=TAMTradePromotionAnalysis
Integrate withTAMTradeAllowanceAgreementHeaderEntity data entity Microsoft data model
Data migrationTAMTradeAllowanceAgreementHeaderEntity (Trade allowance agreement headers): the agreements this inquiry reads.Load order: Nothing is loaded through this inquiry; its figures come from posted documents of the agreements.Microsoft Learn
Table definitionTAMTradePromotion columns and relations Microsoft data model
Everyone

8Sources