Where to find "Account Type" and "A/c Type Sub-Group" ?

Question

Good afternoon, 
 I'd really appreciate it if someone who knows the Sage300 database well could help me on this. If you look at the screenshot below, I'm trying to find the database table where my accounts could possibly map to the ORANGE "Account Type" (ie Asset, Equity, Liability) and YELLOW "A/c Type Sub-group" (eg "Current Assets", "None-Current Assets"). I thought of doing this manually... however as I see it on a sample balance sheet report, it simply must be in the database somewhere... 
 Could anyone possibly more seasoned than I shed some light on where to find these? 
 
 Many thanks in advance. Michelle

dingosoft · Accepted Answer

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.

Sage 300

Where to find "Account Type" and "A/c Type Sub-Group" ?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING