web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / FRx WebPort Drilldown ...
Microsoft Dynamics SL (Archived)

FRx WebPort Drilldown YTD Column Period 12 Last Record Incorrect

(0) ShareShare
ReportReport
Posted on by Community Member

Very odd issue here.

In every FRx WebPort Report in which I drilldown by account/subaccount, the YTD Period 12 final record has the wrong total.

It does not foot the months correctly.  It is always the last record in Period 12 whether there are 1, 2, 3 records, etc and it is the only YTD total that is incorrect.

I hope someone else has seen this before.

 

Thanks,

Chuck

*This post is locked for comments

I have the same question (0)
  • Leahs Profile Picture
    Leahs on at
    RE: FRx WebPort Drilldown YTD Column Period 12 Last Record Incorrect

    Hello Chuck,

    Is the Period 12 total for the YTD column different from the result of the generated FRX Catalogs total?

    Does the issue occur on all reports?

    Does the same issue occur for a simplified Catalog, with 1 or 2 accounts, 1 or 2 Columns and no tree?

  • Community Member Profile Picture
    Community Member on at
    RE: FRx WebPort Drilldown YTD Column Period 12 Last Record Incorrect

    Leahs

    Thanks for your help above.

    We are only seeing the issue in WebPort.

    There is no issue in Report Designer.

    Thanks,

    Chuck

  • Leahs Profile Picture
    Leahs on at
    RE: FRx WebPort Drilldown YTD Column Period 12 Last Record Incorrect

    I understand when drilling into the account level of the generated report you are not seeing the expected data.  The generated results do not summarize to the total results.  Periodic Columns will show the transaction details.  YTD columns are not intended to show transaction details, insure the data being reviewed when drilling in is the account level.

    To further narrow in on the issue create a simplified catalog.

    a) Create a new row with 1 or 2 accounts.

    b) Create a column with a Desc, GL/Periodic and GL/YTD

    c) Create a new catalog and generate.

    d)  Does the issue still occur?

    e)  Does the issue occur in WebPort and Report Designer

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans