Hi Michelle

The FRS financial reporter uses the Account Group Category to classify account groups. Unfortunately, the Account Group Category isn't in the GLAMF table. FRS subclasses G/L to add the field in. This allows the FRS standard reports to work with any Account Groups out-of-the-box. The Account Group Category is in the Account Group table GLACGRP. It's the GRPCOD field (badly named - it should be GRPCAT - not GRPCOD). If you wanted to use it in a standard Crystal report or something, you would have to link from GLAMF to GLACGRP by the Account Group field. The Account Group Categories are fixed - you can't add or delete them and they don't specify whether they are Assets/Liabilities or Equity. In the FRS report you are looking at, the Row Set is selecting specific Account group categories for each section of the report. Eg: For current assets, it's selecting categories 10 - Cash and Cash Equivalents to 40 - Other Current Assets.

So, if an account group is not showing up in the right section of the balance sheet, check the Group Category field in the account group in G/L Setup / Account Groups. In FRS / Setup, there is a handy Chart of Accounts screen that shows the Account Group and Group Category for each account.

Hi John, what a useful answer. Thank you ever so much for taking the time to write such a detailed (and helpful) reply.

Hi Empy, if this helped be sure to mark the suggested answer as verified Thanks!

Hi Empy, if this helped be sure to mark the suggested answer as verified Thanks!