Blog A Blog Poster

 
The following reports have migrated from Cognos QA to Cognos production:
  1. m-Fin ACCOUNT ACTUALS PERIOD BY FISCAL YEAR. New report.
  2. m-Fin POSITION BUDGET. Double-quote fix.
  3. m-Fin ABNORMAL BALANCE. Double-quote fix.
  4. m-Fin ACCOUNTING SUMMARY. Double-quote fix.
m-Fin provides five reports that have the classic revenue and expenditure summarization to individual account codes: (1) m-Fin OPERATING SUMMARY (2) m-Fin REVENUE AND EXPENDITURE SUMMARY (3) m-Fin REVENUE AND EXPENDITURE TOTAL (3) m-Fin TRIAL BALANCE SUMMARY...
Here is an m-Fin report that can summarize a single account code, or any from-to range of account codes, showing total actuals for each accounting period across all fiscal years since 2000. You could use it to look at the monthly 000100 -- CASH balance on a clinical trial, like this:
Cash balances Historical cash balances

abacusIf you run m-Fin ACCOUNTING SUMMARY for just a few speedtypes try m-Fin ACCOUNTING SUMMARY BY SPEEDTYPE, available now in Cognos QA. [18-Nov-2013 This report is in production now.] It follows the same fundamental accounting formula but:
  • is not as highly summarized
  • puts the speedtypes into columns
  • adds speedtype total budget information
bird_in_treeThe following reports migrate to production today from Cognos QA:
  • m-Fin FINANCIAL DETAIL.  Double-quote fix.
  • m-Fin ACCOUNT NUMBER.  Double-quote fix.
  • m-Fin ACCOUNT RANGE BY FUND.  Double-quote fix.
  • m-Fin SPEEDTYPE SUMMARY.   Double-quote fix.
This computation appears at the bottom of the report, providing an amount that the total payments received ordinarily should match. This computation appears at the bottom of the report, providing an amount that the total payments received ordinarily should match. This is a cash deficit example.

  1. In m-Fin BUDGET TO ACTUALS, the EXTRAS option for CONT and TEMP budget columns was not working. This is fixed and is now in production.
  2. In m-Fin TRIAL BALANCE SUMMARY, the single speedtype mode was not working with the Finish button (it worked only with the enter key). This is fixed and is now in production.
ACTUALS_BY_FISCAL_YEARIf you would like a report that sums into fiscal year columns, please test m-Fin ACTUALS BY FISCAL YEAR available in Cognos QA now. [10-Feb-2014: The report is in production now.] It runs for either a given speedtype, program, or project. It's just actuals, so there are no budgets or encumbrances. Please leave feedback below.
Do you review the finances for a high number of projects, more than you can keep track of in your head? Want a report that lists projects that look like they might go over budget?
m-Fin COMPENSATION SUMMARY and m-Fin PAYROLL TRANSACTIONS have been changed to compute benefits rate both with and without INC and LEG. INC and LEG are payroll earnings type codes. INC is INCENTIVE PAY. LEG is MED - LEGAL pay. These unusual earnings types occur mostly on Anschutz Medical Campus. When pay does not involve INC and LEG then these reports are the same as they were before, except for some improvements to the column header labels.

Pages