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

SOLVED

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

Top Replies

  • 0

    Hi Michelle

    For the Yellow highlight should be refer to Account Group. You can create your own Account Grouping. Every singe Account code need to assign an Account Group (Yellow) and Account Type (Orange) during creation. When designing the financial report you can use either Account Group or Account Code.

  • 0 in reply to ShirlenaG

    Hi Shirlena, thank you for your reply. However - what I am looking for is the actual tables which exist in the back end database. Also, my GROUP value is actually the item level beneath the yellow. To reiterate: 

    Remaining Question: (Orange) Does anyone know where in the Sage300 database I can find a way to map my accounts to asset/liabilities/equity?

    As for the YELLOW... These are a ROLLUP of my groups... oh! I think I just answered my own question. These would be found in the Rollup Groups table. OF which I have nothing in... so its a setup thing. Perfect!

  • +1
    verified 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.

      

  • 0 in reply to dingosoft

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

  • 0 in reply to Empy

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