Bonus feature! Using the new GP 2010 General Ledger Reporting Ledgers in Management Reporter
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.
Column Filter
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.
Row Modifier
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.
Comments
Anonymous
September 09, 2010
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.Anonymous
October 14, 2010
Hi, may i know is these functionality available in FRx6.7 SP11?Anonymous
December 16, 2010
pusisan..this is a discussion about Management Reporter..not FRxAnonymous
June 28, 2015
Hi Jill, 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?