Get More Information From FRx Using Transaction Detail Drilldown

Something fishy with an account balance?

It’s nice to be able to drilldown in FRx instead of going to the GL. Saves a few steps. I’m not going to show you what the finished product looks like because I’m in a demo database and the transactions look pretty tacky. But suffice to say that there’s probably a lot more to drilldown than you ever dreamed.

First, here are a few settings in the catalog, then I’ll show you the column layout. In the catalog, make sure the Detail Level is set to Financial & Transaction. It’s also a good idea to change the orientation to Landscape (on the Page Setup subtab) and make the margins as narrow as you can get them (.25).

As soon as you generate a report and drilldown on a few accounts to test, you can figure out which of these codes you like and which don’t do a bit of good. Then you can edit the column layout and delete the ones you don’t need. But be aware that the information they provide changes with the type of account you’re drilling into, so it’s good to test on several accounts before you start deleting.

Oh and by the way, these are called T-codes since they, ah, start with the letter T.

Here’s the column layout to use to start with:

Just so you know, the T-codes give different data depending on what general ledger you’re using. And on the finished report, they don’t show up until you drill on the account level data, so don’t freak out when you don’t see them on the report just after it finishes generating. You have to, you know, drill down to get to them.

I like to set up one report in FRx specifically for transaction level drilldown. Transaction level reports take longer to process and heaven help you if you send the whole thing to the printer. For most other reports I leave the Detail Level set to Financial & Account. Give this a shot—hope it saves some time.

Tagged as: Drilldown, Report Design, T-codes, Transaction Detail