In the view Departments (^D)
1. How do I delete Erronous departments?
2. How do I rename/re-label departments?

Hi Kay,

If these are real departments (as opposed to department ranges or masks), then you do the Department maintenance within the Adagio Ledger program, not the Financial Reporter. If you delete or rename a department code in Ledger, then the change propogates to the View Departments list within the Financial Reporter.

If you want to delete or rename a department range or mask, open the View Departments screen, click on the desired range/mask, right-click and choose the desired operation to edit or delete.

Should you modify or delete a real department and the changes do not propogate to the View Departments screen in the Financial Reporter, it is possible that the data file that stores the View Departments information (GLDTREE.dat) could be corrupted. This file only saves Range/Mask information (not real departments) but does also save information if you choose to re-sort departments on the View list.

Sorry, I have been totally mis-reading department information presented. Now I understand.

Follow up question. In DOS Accpac we could specify department ranges ((blank) through 399). In Adagio, we can specify a mask of (blank) or 1?? or 2?? or 3?? but how do I consolidate report 1??-3??.

The reason is I have multiple related set of departments within the ledger such as (blank) through 300's then 400 through 700's and the 800's.

There is a particular formula function called RNGMERGE in the financial reporter that is used for summing together non-consecutive accounts and/or departments into a single cell. In a nutshell, RNGMERGE looks at one cell to get a set of accounts, a different cell to get a set of departments, and determines all the combinations of accounts/departments to arrive at a sum.

The easiest way to see the correct syntax is to create a new financial statement by dragging an Account Group from the View Account Groups screen onto a blank sheet. On the screen that presents SmartSheet options, select the 'Departmental Comparative' option. From here, you can select one or more departments, masks and/or ranges, and also 'Sum Selected Departments'. When the sheet is created, each department/mask/range will be in a separate column. The formulas used for outputting the dollar amounts use the RNGMERGE function for calculating the account/department key.

If you already have department masks set up, you can select these and sum then together using the procedure above. I believe you have to select a 'blank department' separately as above, and cannot create a range say from blank to 399. It's a little trickier to deal with blank departments in formulas along with non-blank departments.

Highlight the range of Departments in the View | Departments then Right Button | Create Departmental Range

You will then have that range at the bottom of the Department List.

Right Button on the newly created range to change the range or description or to delete the range

Thank you - thank you.

This was exactly the solution I was looking for. I am getting to really appreciate Adagio and the support staff.