web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Management Reporter-Pr...
Microsoft Dynamics AX (Archived)

Management Reporter-Print control P<=B not calculating correctly for Prior Year in Column Definition

(0) ShareShare
ReportReport
Posted on by SharB 5

When creating a rolling period report for Current and Prior year, I do not want activity pulled into the report for any period other than the Base Period or Less for both the current and prior years.

I am using P<=B Print Control for the FD Periodic Columns. It works for Current Year but not for Prior Year.

If I select 2 for Base Period it will only print Period 1 and 2 for Current, but it prints all of the Prior years periods.

Does anyone have a work around or solution for this?

Thanks...

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi SharB,

    Have you tried getting the columns excluded with a if-then-else formula?

    Maybe that might work in your case?!

    Best regards,

    Ludwig

  • SharB Profile Picture
    SharB 5 on at

    Thank you Ludwig for that suggestion.

    I need the formula to be based on the Base Period when running the report and I am not sure how to do that. Could you give an example of what you are thinking would work?

    Thanks, Shar

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi SharB,

    You are right with the if-then-else stuff it might be difficult.

    Yet, I am wondering how you setup your base periods in your column definition.

    Can you test whether entering Base-1 (for the previous year) in the fiscal year section of the column definition helps overcoming this issue?

    Also test at the report level what happens if you enter something like S-12 in the default period field.

    If none of that works out for you then I would say that the report design you want to achieve can't be achieved and would suggest that you post a note on MS connect so that MS can fix it for future releases.

    Many thanks and best regards,

    Ludwig

  • NelsonC Profile Picture
    NelsonC 282 on at

    I was just wondering if you found a solution to this.  I have run across the same problem, and can not seem to figure out how to get it to work.

  • SharB Profile Picture
    SharB 5 on at

    I created an incident with Microsoft on this and they are currently reviewing it as a potential bug. I have not heard back yet, but I will post the outcome.

  • Chris Rusing Profile Picture
    Chris Rusing on at

    Hi SharB,

    I understand that you ended up opening a ticket with Microsoft for this problem.  Were you provided with a viable solution to this problem or possibly a work around instead?

    Thanks,

    Chris

  • Community Member Profile Picture
    Community Member on at

    I did get a workaround from Microsoft.

    From MS…

    I wanted to let you know that is issue has been written up as bug: 3828242.

    I do apologize, but I am unable to provide an ETA as to when/if the bug will be resolved.

    1. There was a work-around that was found by using the following Column configuration.

    A.

    Columns B-D are regular FD columns

    E is the total of B, C and D

    F-H are FD columns set to be non-printing

    Column I calculates the "BASE" period based on the period selected in the report definition

    Columns J-L use an IF/THEN statement to calculate the period compared to the BASE period using only the period number, not the fiscal year+period number. If true, the column will display the value from the related FD column. (IF Periods <= Then F)

    When generating the report for period 2, you can see that on the output it only prints periods 1 and 2 for 2012 as well as periods 1 and 2 for 2011 as the IF/THEN calculation is truly only looking at the period number.

  • Chris Rusing Profile Picture
    Chris Rusing on at

    Hi Below-20,

    Could you please provide a screen shot of the column definition you used in MR in order to get this to work?  Thanks in advance!

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#1
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#1
Pratik Bhosle Profile Picture

Pratik Bhosle 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans