Using GL9.0A (080402)
In the past, we've always recreated a new GL for the start of a new fiscal year. We had no need in comparing previous year data and our account codes often changed from year to year.

We would like to start using the "Create Next Fiscal Year" feature which would allow us to start 2009 without having completed all 2008 adjustments. I've imported our new 2009 accounts and budget in a "test" GL and realize I now have a bunch of account codes I no longer want to download when running my financials.

Is there a way to exclude these 2008 accounts not used in 2009? I could make them inactive and exclude them in my Crystal query as a last resort but would prefer to not have them exported at all...

Any comments/solutions appreciated!

Hi KNoel:

In GL 9.0, when you "Create the next Fiscal Year", the 2008 chart of accounts is "copied" and used for 2009. You can then say that some accounts are "Inactive". GL 9.0 does a much better job of respecting that flag than previous versions. For instance, you can use the Column Editor in order to not show the Inactive accounts.

Where do you plan to export/import?

We export to Excel and consolidate data from our subsidiary company. We then use Access/Crystal to run our monthly financials. It shouldn't be difficult to modify our queries to exclude inactives but thought it best to ask if others had a similar problem with old account codes they would rather not have appear in their reporting.

Hi KNoel

I'm dying to know why an Adagio GL user would forego the best feature of Adagio GL, namely the built-in financial reporter, and go to the trouble of exporting to Access/Crystal. What is it about Adagio's financial reporter, which would definitely be more efficient to use and more trouble-free, that is lacking?

Steve

Thanks for your reply Steve! Sorry, I was away for a bit...
First, we have many, many reports that have already been set up from our old Accpac Plus system. It works, but you are right, it is tedious to export all the time and be dependent on other software. I guess the main reason we're exporting is to consolidate another company's data (also Adagio) into our own, using Excel, for monthly reports. I'm not sure how we can do this within Adagio. Would we have to create a third company to combine the two companies?
I'm keen on starting to use the internal financial reporter but we also have an issue with our account codes. They are currently flipped (Acct=Dept, Dept=Acct) which, I think, causes the reporter to not be used efficiently. This would also mean re-creating all of these custom-made reports..Yuk!
I appreciate any guidance you can offer!
Karin

Hi Karin

Your problems are not as bad as you think. Adagio FX is specifically designed to combine multiple Adagio GL datasets, as long as the charts of accounts are in synch. That's definitely the direction you want to go, rather than creating a third company.

As for the need to restructure your account/department segments, if you design a decent chart of accounts (one that cross-references to lines on financial statements nicely), then the amount of time spent to do this will pay huge dividends. You can use Dakota Software's Toolkit for Adagio to make the restructuring less painful, since it can process any changes retroactively both to the detail transactions and through to the subledgers. Yes, it costs money, but without it you are looking at a daunting task.

Steve

Hi Karin,

We would be interested in seeing your chart of accounts to see if there was a way we could improve the reporting in this situation.

I'd also endorse Steve's suggestion of flipping the chart around using Dakota's tool kit.

Thanks for using Adagio!