A report that prints the cost of trade allowance agreements, which you can limit by trade allowance ID and customer account and show as planned, incurred and actual amounts, with or without detail lines.
Sales and marketingTrade allowancesTrade allowance analysis
output:TAMActualCost
Business process
Manage trade allowances
Menu item
output:TAMActualCost
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 is
A report that prints the cost of trade allowance agreements, which you can limit by trade allowance ID and customer account and show as planned, incurred and actual amounts, with or without detail lines.
What you do here
Use this report to compare the planned, incurred and actual cost of a trade allowance promotion.
Example
For example, at the end of April BEAT runs the report for TA-000045 with Show planned, Show incurred and Show actual set to Yes and compares a planned cost of 3,000.00 with 3,100.00 incurred.
The page in Dynamics 365. page title tab to open what to set or check
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.
When to run it
When to run it
During or after a promotion, when its cost is evaluated against the plan.
How often
On demand, for example monthly while the promotion or fund is running.
What the output shows
Trade allowance cost per agreement, with planned, incurred and actual amounts for the options set to Yes.
Limits the report to one trade allowance agreement.Checked in Dynamics 365
TA-000045
Customer account
Limits the report to one customer.Checked in Dynamics 365
BEAT-000310
Show planned
Set to Yes to print the planned amounts.Checked in Dynamics 365
Yes
Show incurred
Set to Yes to print the incurred amounts.Checked in Dynamics 365
Yes
Show actual
Set to Yes to print the actual amounts.Checked in Dynamics 365
Yes
Show details
Set to Yes to print the detail lines behind the totals, or No for totals only.Checked in Dynamics 365
No
Common errors and fixes
Message
What to do
The report prints no amounts for the agreement.
Set at least one of Show planned, Show incurred or Show actual to Yes and check the Trade allowance ID and Customer account filters. Checked in Dynamics 365
Test checklist
Run the report for the agreement with Show planned, Show incurred and Show actual set to Yes.
Run it again with Show details set to Yes.
Check that the planned, incurred and actual amounts are printed, and the second run lists the detail lines.
Select the Trade allowance ID and switch on Show planned, Show incurred and Show actual together, so the three figures are compared on one report.The report shows only the figures you switch on, and without a Trade allowance ID it covers every agreement.
Nothing changes: the report reads the trade allowance agreements and their documents. Microsoft Learn
Technical architect
6Technical
Menu item
output:TAMActualCostChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To use itSales manager TradeSalesManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkMarketing manager CRMMarketingManagerGive people one of these roles. On this system, 3 roles can run this page.Checked in Dynamics 365
Load order: Actual cost report has no data entity in Data management: it is a report and stores no data. The figures come from the trade allowance agreement records and their posted documents.Checked in Dynamics 365