I know last week I said the next post would be about viewing reports, BUT after reading this post, from the GP team, I wanted to piggy back on it and show how this cool new feature can be used in Management Reporter.
The new reporting ledgers are treated as attributes in Management Reporter. So, all you have to do is set up an attribute filter in your column (or row if you’d rather do it that way) and away you go! Check out the screen shots below to see how to do it.
In the column definition, open the attribute filter dialog. Then, select Reporting Ledger. Once Reporting Ledger is selected, the different ledgers are available for selection in the From field.
Here I’ve got each column filtering on a different reporting ledger.
The results in viewer shows different reporting ledger amounts by column.
You can also apply a row modifier using the attribute filter. In the row definition, open the Row Modifier dialog. Then, select Reporting Ledger from the attributes area. Once Reporting Ledger is selected, the different ledgers are available for selection in the From field.
Instead of filtering on the column, I'm filtering each row by a different reporting ledger.
The results in viewer shows different reporting ledger amounts by row.
And that is how easy it is to use the new GP 2010General Ledger Reporting Ledgers!
Be sure to check back later in the week, as I'll still be doing a post about viewing reports.
I have not played with this, however, for consideration, does posting to different ledgers lend itself to Accrual to Cash Basis adjustments? Separate columns by Reporting Ledger appears to open up the possiblitites similar to creating a separate Cash Company to post month end adjustments and using FRx to consolidate both for a Cash Basis FS.
Hi, may i know is these functionality available in FRx6.7 SP11?
pusisan..this is a discussion about Management Reporter..not FRx
I am using MR2012 but there is no Reporting Ledger under Column Attribute Filter or Row Modifier. I have posted an entry using reporting ledger. Any idea why?