0FIGL - GL and Cost Center Overlay

We are using 0FIGL cube and looking for a way to handle custom row structures to group GL Account by specific Cost Center for display in financial statement.

For example, one grouping would be by "Revenue" accounts, next row "Other Assets", then finally Liabilities, the problem is under a specific grouping (i.e. Revenue), we need to create a row for revenue by specific cost center, then another line for all other cost center Revenue. The are over 30 different combinations of these grouping the clien needs. Ideally, we do not want to handle this through VBA in workbooks. This cannot be something new and I am looking for any solution that could handle this need. Please share your ideas.

Example:

>Revenue

-Revenue (GL = 400 & Cost Center = 1000) $100

-Revenue (GL = 400 & Cost Center <> 1000) $1200

>Other Assets

-Other Assets (GL = 500 & Cost Center = *) $5000

>Liabilities

-Liabilities (GL = 200 & Cost Center = 5000) $200

-Liabilities (GL = 200 & Cost Center <> 5000) $25000

Message was edited by:

MIghty Mike