Share via

Bonus feature! Using the new GP 2010 General Ledger Reporting Ledgers in Management Reporter

  • Article

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 FRx

  • Anonymous
    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?