Hello Richard,

OK - regarding the account numbers - Adagio FX right justifies and blank fills account numbers, so 2022.1 will sort after all the four digit account nubers. Unless your clients actually posts amounts into account 2022 - perhaps it would make the chart easier to read if you gave it the number "2022.0"?

I'm concerned that the retrieve doesn't seem to have picked up any amounts. On the main screen for Adagio FX (not the financial reporter spreadsheet), from the Reports Menu, choose "Trial Balance" and make sure that the Trial Balance "does". If it doesn't, (and the retrieve has not complained about any account collisions or missing account numbers), then I wonder if you' be willing to provide us with a copy of the data so that we can investigate the retrieve failure. You can upload it to http://www.softrak.com/dbr and drop me an e-mail. We'll look at it on Monday.

Next - about the adding additional columns:

I'm assuming that you are in the financial reporter, with a one or two column financial statement open and you'd like to add another column that contains numbers from the g/l. Here are the steps:

• Make sure the financial statement is "collapsed".
• Select a column containing some figures from the g/l (Selected Period or YTD say).
• Right mouse click and choose "Duplicate column" from the pop-up menu
• If the financial statement has a row with a ".ColSpec" command in column "A", then just change the specification code above the new column to the value you need (say "Q" for Quarter to Date). You can see all the available codes in the View | Account Data or by opening the "AF!SuperSpec.xxx" financial statement shipped with Adagio FX
• If the financial statement does NOT have a ".ColSpec" command, then click on a cell containing one of the general ledger figures to see the "=ADGET()" formula that is being used. It will have something like "gldata.Y" as the first text string (Y means YTD). Determine the code you want to use (say "BY" for Budget YTD) and use the Find & Replace command to change all occurances of ".Y" to ".BY" in the column you have created.
• The new numbers should appear.

Keep on going - you're getting the hang of it!