Management Reporter Financial Dimensions Column

(0) Share

Report

Posted on by FK12563

I am trying to generate a P&L report that allows it to show an Inception to-date column. I work with contracts that where the Period of Performance crosses multiple fiscal years. How would I best format the Financial Dimensions Column Specifically as it pertains to the Fiscal Year,Period and periods covered cells. Can it be done in one column?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (3)

Answers (0)

Sort by

nihad 182 on at

Like
a
(0)

Report
Copy link

Link copied!

I would like to know this as well please if there is a solution

Was this reply helpful? Yes No
Greg Byer 2,588 on at

Like
a
(0)

Report
Copy link

Link copied!

The best way would be to have one column that covered the prior year and another column for this year. You could then make them non-printing and add them together.

You could try using BASE : BASE-#. You'd replace the # with the number of periods you wanted to go back. If I did BASE : BASE-13, I'd get everything from the last 13 periods. If the base period in the report is 9, this would include everything from period 9 and back 13 periods (period 9 this year to period 8 last year). I have seen some problems with this, especially if the prior year is closed or the periods are marked as closed.

Was this reply helpful? Yes No
BloodCod 5 on at

Like
a
(0)

Report
Copy link

Link copied!

[quote user="Greg Byer"]
The best way would be to have one column that covered the prior year and another column for this year. You could then make them non-printing and add them together.

You could try using BASE : BASE-#. You'd replace the # with the number of periods you wanted to go back. If I did BASE : BASE-13, I'd get everything from the last 13 periods. If the base period in the report is 9, this would include everything from period 9 and back 13 periods (period 9 this year to period 8 last year). I have seen some problems with this, especially if the prior year is closed or the periods are marked as closed.
[/quote]
Thanks for sharing useful information with us.. It really helpful to MyAARPMedicare me..I always prefer to read the quality content and this thing I found in you post. thanks for sharing with us..

Was this reply helpful? Yes No