BeyondERP.Newsletter
Menu

Setup step on the Fund details report page · Sales and marketing

Run the Fund details report with the right filters

Use this report to review how much of a promotional fund is planned, incurred and actually spent.

Business process
Manage trade allowances
Menu item
output:TAMFundDetail
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 details of a trade allowance fund, which you can limit by fund ID and show as planned, incurred and actual amounts, with or without detail lines.
What you do hereUse this report to review how much of a promotional fund is planned, incurred and actually spent.
ExampleFor example, before allocating more of fund FND-2027-01 (budget 25,000.00), BEAT runs the report and sees 12,000.00 planned on two agreements and 4,350.00 actual.
Fund details 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 itWhile a fund is valid, for example before allocating more of it to new agreements.
How oftenOn demand, for example monthly while the promotion or fund is running.
What the output showsPlanned, incurred and actual amounts for the fund, with detail lines if Show details is Yes.

Source: Microsoft Learn

Setup steps on this page

Run the Fund details report with the right filters

Use this report to review how much of a promotional fund is planned, incurred and actually spent.

Steps from Microsoft

  1. Go to Sales and marketing > Trade allowances > Funds > Fund details report.
  2. Choose a Fund ID to report on one promotional fund.
  3. Set Show planned, Show incurred and Show actual to Yes for the amounts to compare with the fund budget.
  4. Set Show details to Yes to see the detail lines behind the totals.
  5. Run the report; unlike the Actual cost report, it starts from the fund, not the agreement.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExample
Fund IDLimits the report to one promotional fund.Checked in Dynamics 365FND-2027-01
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
A fund shows no amounts.A fund is used only after its Status is Approved and it is allocated on the Funds FastTab of a trade allowance agreement. Microsoft Learn

Test checklist

  1. Run the report for the fund with Show planned, Show incurred and Show actual set to Yes.
  2. Check that the fund's planned, incurred and actual amounts are printed.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Run the Fund details report with the right filtersSelect the Fund ID and switch on Show planned, Show incurred and Show actual before allocating more of the fund to new agreements.The report shows the amounts per fund only for the options switched on; without a Fund ID it covers all funds.Comparing only the actual amount with the budget and missing amounts already planned on confirmed agreements.Test: The report prints the fund's 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 funds 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 funds and the agreements that draw on them. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:TAMFundDetail 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:TAMFundDetail
Data migrationLoad order: Fund details report has no data entity in Data management: it is a report and stores no data. The figures come from the fund records and their posted documents.Checked in Dynamics 365
Everyone

8Sources