Skip to main content

Notifications

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 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

  • Chris Rusing Profile Picture
    Chris Rusing on at
    RE: Management Reporter-Print control P<=B not calculating correctly for Prior Year in Column Definition

    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!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter-Print control P<=B not calculating correctly for Prior Year in Column Definition

    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
    RE: Management Reporter-Print control P<=B not calculating correctly for Prior Year in Column Definition

    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

  • SharB Profile Picture
    SharB 5 on at
    RE: Management Reporter-Print control P<=B not calculating correctly for Prior Year in Column Definition

    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.

  • NelsonC Profile Picture
    NelsonC 282 on at
    RE: Management Reporter-Print control P<=B not calculating correctly for Prior Year in Column Definition

    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.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management Reporter-Print control P<=B not calculating correctly for Prior Year in Column Definition

    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

  • SharB Profile Picture
    SharB 5 on at
    RE: Management Reporter-Print control P<=B not calculating correctly for Prior Year in Column Definition

    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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management Reporter-Print control P<=B not calculating correctly for Prior Year in Column Definition

    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

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,031 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,868 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans