Dear Jhenry
There are a couple of ways you can approach this in Adagio Financial Reporter.
First off, if your Departments are consecutively numbered (i.e. with no other Departments in between), you can create Ranges to report on just these departments.
To create a Range, follow the steps below.
1. Open FR by clicking on Ledger's Maintenance - Maintain Financial Reports.
2. From FR's main Toolbar menu, select View - Departments to bring up the department window.
3. From the Dept View window, use the Multi-select tool to select the consecutive range of Departments that you want to create the range for (to multi-select, first click on the 1st Dept in the range, then while holding down your <Shift> key, select the next Depts in the range, in the order that they appear in the Dept window, until you have selected all the ones you want. Then, let go of the <Shift> key.).
4. Now, right-click on the selected (highlighted) range, and from the pop-up menu that appears, click on "Create Departmental Range".
5. In the dialogue box that comes up, type in a Name to describe this range, then click OK.
6. You should now see this new range appear at the bottom of the Department View window.
7. Continue the above steps to create other consecutive department ranges, then close the Dept View window when you are done.
Now, to use this range, just open the FS you want to report on and click on the 'Consolidated' button to disable it. Then, use the scroll button to find your new department range, then select it to see the selected combined group of departments.
On the main FR Toolbar menu, the Consolidated button is in between the 'Include Provisional' button "P", and the little dialogue box that you can see the first department in. In it's default state, it is 'depressed' or enabled. Click on it to undepress or disable the consolidation option, and then the department dialogue scroll box will become active.
If the Departments you wish to report on are NOT in a consecutive range, there is a new function in the current release of Ledger FR that you can use, otherwise, you must create a separate FS for each range of departments that you may want to report on.
If you do not have the current release, then there is a sample FS included in our sample data that you can use to help you create your own (or you can just modify the sample one after creating a copy of it in your own dataset.) To find the sample spec, go to the drive where Adagio is installed, and go to the Softrak\ALWIN\Samdata folder. The FS file is called "GL!deptDemo.sam". It shows a good sample of side-by-side departmental reporting.
If you do have the current release (V6.8A - dated 010911), then there is another function you can use, called Range Merge (RngMerge). This function is explained in the README file in the new release, as well as being outlined in the Release Notes.
From the README:
A new function called RngMerge has been added. It does a concatenate between commas. For example, RngMerge(A1,A2), where A1 = 1000:2000-, 3000:4000-, 5000-, and A2 = 1,5, would result in 1000:2000-1:1, 1000:2000-5:5, 3000:4000-1:1, 3000:4000-5:5, 5000-1,5000-5. RngMerge may be used in conjunction with the functions ADGET, ADDEBIT, ADCREDIT, ADCRONLY and ADDRONLY. For example, ADGET(?gldata.M?, RngMerge(A1,A2)), will give you the current month net posted amount for the range of accounts shown above.
What has to happen is that the Account range(s) are entered as text into one cell (say A1) and the departments are entered as text into another cell (say A2). The RngMerge function uses the cell references to determine the required ranges and amounts to add together. So to use the formula below, put the accounts into cell A1 (or where you wish) as '50000:59999- (note the apostrophe at the beginning to identify as text) and the departments into cell A2 as '210,206.
Then, the following formula syntax will accomodate this as:
=ADGET("GLDATA.M",RngMerge(A1,A2))
Hope this helps.
Regards
Softrak Technical Support
Previous Topic
Index