i have departments numbered from 1-20. How do i select a range ie: departments 7-13 as consolidated for a financial statement.

Dear Kevin

To do this, you can create a "department range" in the Financial Reporter.

Open FR, using the Maintainence | Maintain Financial Reports toolbar menu option in Adagio Ledger. Then you must:

1. Open the "View Departments" window
2. Multi-select the Departments you wish to consolidate by clicking on the first dept in the range (1), and, while holding down your <Shift> key, click on the rest of the departments in the range (2-20) to select them. When you are finished, take your finger off the <Shift> key. All the depts in that range should now be highlighted.
2. Now, right-click on this highlighted range. This will bring up a sub-menu.
3. Select "Create Departmental Range". A Create Departmental Range window will appear.
4. Give the new range a Description, then click OK. You should now see your new range in the View Departments window.

Now, if you wish to print a financial statement for this range, open the FS you want, then choose the new range from the Consolidation selection button option (the one directly to the right of the "P" (Include provisional) button. (If the consolidation option is greyed out, you must enable it by clicking (undepressing) the consolidation button!)

NOTE: In your FS, if you use cell references for your account data, the source cell must use the syntax to accomodate ALL departments (ie: ' 4000-`, rather than ' 4000-xx - where 4000 is your GL Account, and xx represents the department).

PS You will need Adagio Ledger V6.6A, release(001109) for this option.

Hope this helps.