March 21, 2014

Account Summary And Subtotaling

m-Fin provides five reports that have the classic revenue and expenditure summarization to individual account codes:

m-Fin OPERATING SUMMARY
m-Fin REVENUE AND EXPENDITURE SUMMARY
m-Fin REVENUE AND EXPENDITURE TOTAL
m-Fin TRIAL BALANCE SUMMARY
m-Fin TRIAL BALANCE TOTAL

We are making an enhancement to these reports to help when:

Your budgets are at a more detailed level than is subtotaled in these reports.
You are getting more account codes than you really care to see listed individually. This can happen when you have a speedtype that is a really big operation or you are running one of the TOTAL reports for a large ORG | ORGNODE.

The enhancement is a new prompt, ACCOUNT SUMMARY AND SUBTOTALING. We have it ready for you to try in Cognos QA in the m-Fin REVENUE AND EXPENDITURE SUMMARY report. [10-Jan-2014 These five reports migrated to production.] It is on the second page of prompting, available via the Next button. It offers three variations of the report. The first is the classic and the other two are new.

Account code summary with level 5 in-line subtotals

This is the classic report, the way m-Fin has been doing it all along. Each account code gets its own line. Subtotals at level 5 of CU’s account rollup tree will appear but only if they are significant. If all the account codes are in the same level 5 category then no level 5 subtotal is shown. That’s what’s happening here in this example image. There are many account codes but they are all in the same level 5 category. The account codes I have highlighted in blue are a level 6 group. We are not doing anything with level 6 in this run.

[ACCT_LV5_OFFICE]

Account code summary with level 6 in-line subtotals

This is the first new variation. Each account code still gets its own line but subtotals are at level 6 of CU’s account rollup tree instead of level 5. Since in this example the account codes are in different level 6 categories, the subtotals appear.

[ACCT_LV6_OFFICE]

Level 6 summary with level 5 in-line subtotals

This is the second new variation. Individual account codes are not shown. Instead, the report bottoms out at level 6. Subtotals at level 5 will appear but only if they are significant, so in this example none are shown.

[LV6_LV5_OFFICE]

Boulder Facilities Management

My thanks to Ron Ried and others in Boulder Facilities Management for guidance and initial testing of this enhancement.