BeyondERP.Newsletter
Menu

Setup step on the Actual cost report page · Sales and marketing

Run the Actual cost report with the right filters

Use this report to compare the planned, incurred and actual cost of a trade allowance promotion.

Business process
Manage trade allowances
Menu item
output:TAMActualCost
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 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 hereUse this report to compare the planned, incurred and actual cost of a trade allowance promotion.
ExampleFor 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.
Actual cost report 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.

When to run it

When to run itDuring or after a promotion, when its cost is evaluated against the plan.
How oftenOn demand, for example monthly while the promotion or fund is running.
What the output showsTrade allowance cost per agreement, with planned, incurred and actual amounts for the options set to Yes.

Source: Microsoft Learn

Setup steps on this page

Run the Actual cost report with the right filters

Use this report to compare the planned, incurred and actual cost of a trade allowance promotion.

Steps from Microsoft

  1. Go to Sales and marketing > Trade allowances > Trade allowance analysis > Actual cost report.
  2. Choose a Trade allowance ID to report on one promotion, and a Customer account for one customer.
  3. Set Show planned, Show incurred and Show actual to Yes for the cost figures to compare.
  4. Set Show details to Yes to list the detail lines, or No for totals only.
  5. Run the report and compare the planned cost with the incurred and actual cost per agreement.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Trade allowance IDLimits the report to one trade allowance agreement.Checked in Dynamics 365TA-000045
Customer accountLimits the report to one customer.Checked in Dynamics 365BEAT-000310
Show plannedSet to Yes to print the planned amounts.Checked in Dynamics 365Yes
Show incurredSet to Yes to print the incurred amounts.Checked in Dynamics 365Yes
Show actualSet to Yes to print the actual amounts.Checked in Dynamics 365Yes
Show detailsSet to Yes to print the detail lines behind the totals, or No for totals only.Checked in Dynamics 365No

Common errors and fixes

MessageWhat 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

  1. Run the report for the agreement with Show planned, Show incurred and Show actual set to Yes.
  2. Run it again with Show details set to Yes.
  3. Check that the planned, incurred and actual amounts are printed, and the second run lists the detail lines.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run the Actual cost report with the right filtersSelect 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.Reading a report with only Show actual set to Yes as the promotion's full cost.Test: The report prints the three cost figures

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: the report reads the trade allowance agreements of the legal entity it runs in. Microsoft data model
Can it be undoneReversible: Report only.
If you change it laterNothing changes: the report reads the trade allowance agreements and their documents. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:TAMActualCost Checked in Dynamics 365
FormSysOperationTemplateForm 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 run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:TAMActualCost
Data migrationLoad 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
Everyone

8Sources