I am working on tool to extract account balances from Adagio and I have some questions.

I will be using the G/L Account Net Changes table and I assume that fields CurrentYearNetTrxPeriod1 to 14y are the activity in that month.

The data dictionary exporter for "Net Changes" shows the fields Acct, Dept and Division but the GridView for that table only shows Acct and Dept. I assume an Acct can belong to a dept in a division?
How does this show up in GridView?

The Data dictionary exporter shows the fields FiscalYear and FiscalYear2FY which one is displayed in GridView?

All the table appears to have an Active column, if an account is not active would it still be used in historical trial balances?

Thank you for your assistance.

Hi,
We also see the "Division" fields but we are not aware of being in use in Adagio. It was added several years ago but doesn't appear to be used currently.

For clarification, be aware that you could also have MC issues that use different Net Change tables, and that some accounts could have MC enabled and others not.

If an account is not active, it would still be used in historical trial balances.

Best,
Brian

Hi Brian,

Thanks for the response. To understand MC a little better, am I able to produce complete trial balances per MC or is MC a little more complex where it handles MC invoices and purchase orders but then translates to produce a trial balance?

The [Division] field is there in the design for future use and is hidden, as are some other "duplicated" data elements.

Use the /A parameter on the Gridview shortcut to show hidden fields.

Adding a /? to a Gridview shortcut will display a screen of the command line options.

[FiscalYear] and [FiscalYear2FY] are "duplicated" fields needed for historical design reasons and contain identical data.

The Adagio Financial Reporter does not make use of the MC ( Multi Currency) data elements, all Financial Statements are reported in Home Currency.

Does the company profile table allow for multiple companies? I am currently trying to determine how accounts are associated with a company if multiple companies are allowed.

There is no "multiple companies" in an Adagio GL database. Each company is in a completely separate database.

I suppose someone could setup a GL where the Departments were considered as a "company" but I don't think anyone would suggest that approach.

The [Company #] field in the G/L Company Profile was provided so a accountant could enter a 6 character identifier for there internal use that would tie this GL dataset to their internal record keeping.

Thank you Michael, this is getting to be more clear.

Would it be correct to assume that I can get a trial balance from the G/L Account Net Changes table?

And that this would be the home currency? As I do not see a currency type in the table.

Another Question,

Can new account groups be added or is the list fixed? I am wondering if I can use the gl groups to determine which accounts are assets, liabilities, equities, revenue and expenses. If that list does not change then I know that I can use it.

Hi Gary:

I'll answer the easier questions and leave the harder ones to Michael.

The GL Groups list is fixed, though there have been suggestions to make it possible to add new ones. I would be surprised if that was high on the R&D priority list.

But the other thing to know is that it's not mandatory to assign each GL account to a Group. Therefore probably the majority of charts of accounts currently aren't using Groups.

I would say that if you need to distinguish account types for Dynac's purposes, you could insist that accounts be linked to Groups. It's only a 15 minute exercise if the COA is well-structured.

From GLMAST'R ( ODBC - AL90DMST )

Field [AcctType] = "B" => Equity or Liability
Field [AcctType] = "R" => Retained Earnings
Field [AcctType] = "I" => Income or Expense

In a well formatted GL Account Structure the [Acct] field should be an indicator between the Equity/Liability and Income/Expense.

The [AcctSign] field should also offer a "hint".

However, Adagio does not force the user to structure their chart or set the [AcctGroups] and [AcctSign] fields.

Yes to using G/L Account Net Changes table for the Trial Balance.

Home Currency [HomeCurr] is a field in the Company Profile ( ODBC - AL90DGLO ). All values from the G/L Account Net Changes and G/L Account Master are in [HomeCurr]