When printing financial statements, I would like to export a financial for a nonconsecutive group of departments. I can accomplish this in print using the Print Departmental Statement. However, I cannot obtain a consolidated version through an export to excel. I have used the Statement Groups feature to create individual statements in Excel, but it does not export the consolidated.

Example:
I have departments 21, 31, and 41.
I would like to create a statement for each and a consolidated for all three.

Thanks for the help.

-Kurpal
Lodi Consulting

Hi Kurpal

Look at the GL sample data - specifically the department list in financial reporter. You'll see examples of departmental ranges and departmental masks. Departmental ranges are for contiguous departments, but departmental masks would work in your example.

If the departments you want to combine are truly random, then you will have to create a specification that hard codes these departments as columns, hiding those columns and printing only the total of those columns.

Steve

Thanks Steve.

Kurpal:

Steve's suggestion of using a Department mask is the best approach given your example where the 3 Departments all end with "1" (and assuming that there there is no Department 51, 61 etc).

If the Departments are more random, there is an alternative to the approach of hard-coding a statement and then hiding columns. You list the Departments you want in a single cell in the statement (i.e. "-21,-31,-41"). Then the RNGMERGE() function will refer to that cell, use those Departments and combine them with the GL accounts specified in column B. For an example, look at the statement "DeptRngMerge" in GL sample data.

It still involves hard-coding a statement, but once you figure out the approach, it's easier to maintain (ie. adding a new Department etc).