Management Reporter 2012 CU8 Features

By Tracey BrinkmanManagement Reporter, With 0 comments

Summarizing features of the new Management Reporter 2012 CU8 update:

  • Dynamic calculated column headers…you no longer need to hard code the Months within the column definition.  This feature received 55 votes on Microsoft Connect. Please continue to submit product suggestions.
    • There may be situations where you have reports that require calculated periods or where you need to perform some calculations to get to your final report format. With CU8 of Management Reporter, you can now apply autotext codes such as @CalMonthLong and @FiscalPeriod to print the period name, period       description, and other date related autotext codes in calculated column headers, The following autotext codes are now available within a CALC column.
    • Month name (@CalMonthLong)
    • Abbreviated month name (@CalMonthShort)
    • Period number (@FiscalPeriod)
    • Period description (@FiscalPeriodName)
    • Fiscal year (@FiscalYear)
    • Calendar year (@CalYear)
    • Start date (@StartDate)
    • End date (@EndDate)

 

  • Currency translation for Dynamics GP 2013 using DDM Data Mart provider

With the data mart, Management Reporter integrates the following data from Dynamics GP 2013 to perform translation:

    • Currency Translation Type assigned to the account in Account Currencies
    • Average Calculation Methods from GP of Rate Average and Rate Days Average that       are assigned in Multicurrency Setup
    • Exchange Tables assigned to Current, Historical, Average and Budget default exchange table IDs from Multicurrency Setup
    • Exchange Rates from Multicurrency Exchange Rate Maintenance
      • Expiration date is honored if no other exchange rates are found after the last entered rate
    • NOTE: For similar exchange rate calculation as Exchange Table average method in GP, enter a single rate per month and choose Rate Average as your Average Calculation Method in Dynamics GP.
    • The first step in preparing to view financial reports in multiple currencies is to understand how exchange rates are calculated using the data mart. The four options in Dynamics GP 2013 for calculating exchange rates in Management Reporter are:
      • Rate Days Average
          • Weighted  average calculation method in Management Reporter
          • Calculated as (exchange rate * days in effect)/days in period
        • Rate Average
          • Average calculation method in Management Reporter.
          • Calculated as sum of exchange rates/# of exchange rates
        • Current
          • Month  end rate calculation method
          • Calculated as  rate on or before the date of  the report or column in Management Reporter
      • Historical
        • Uses a transaction date to get the correct exchange rate
        • If a  rate is not entered for the transaction date, the rate used is the previously entered rate closest to transaction date.
  • The second  step is seeing how simple it is to change to different reporting currencies using the web viewer.
  • Finally, take the time to understand the Report Designer options for currency translation that were also added in a previous release.

 

  • Ability to create a side by side balance sheet by using a section break option in row definition. This feature received 65 votes on Microsoft Connect.
    • Simply add a Format Code in your Row Definition to add a Column Break in the Row above the accounts you want to be side-by-side
    • They have added 2 new default reports: Balance Sheet and Income Statement Side-by-Side and Side by Side Balance Sheet with Assets in 1 column and IS accounts in the second column.
    • For existing customers use Tools > Import Default Reports to import the new reports.

 

  • Triangle symbol to indicate negative balances; needed for specific geographies but available for all
  • Option to include line numbers on generated reports
  • Translation support for XBRL configuration
  • Ability to  set all columns in definition to Autofit by default
  • Collection of Excel formatting improvements (50 votes on Microsoft Connect across)
  • Additional fixes for product defects
    • Exporting  a report to Excel will include a blank worksheet for tree units without data.
    • Summary Account Detail tab is missing in Excel when exporting from Management Reporter.
    • Errors opening Report Designer if the Default Font is set to something that does not exist on the client.
    • “The given key was not present in the dictionary” error when exporting to Excel with single worksheet option marked and information in the fourth line of the footer.
    • Cells containing shading in Report Viewer do not export to Excel if cell  contains no data.
    • Conditional Printing does not work correctly across years when period is hard-coded in column.
    • Changing the default name of an operating unit dimension will break any Organization Hierarchies that include this dimension.
    • Fiscal year information is calculated instead of read from Dynamics ERP and Management Reporter Data Mart.
    • Multiple attribute filters may return incorrect data.
    • Fiscal Year map can produce a SQL query with more than 2100 parameters and encounter a SQL limitation.
    • Using  /-12 account modifier and column ranges pulls in the last period in the range instead of the total of the range for the prior year.
    • Fact Task can grow the SQL tempdb excessively with Management Reporter CU7.
    • Underscore and Line rows are missing at the account detail level for a column that follows two NP columns.
    • Only the first WKS column returns data when there are multiple “link to external worksheets”
    • Scenario Task returns error when a budget was deleted in the Dynamics ERP that contained data.
    • Management Reporter and Data Mart Integration database created with PAGE_VERIFY  database option set to NONE.
    • Consolidated report containing companies with different functional currencies fails.
    • User with Viewer role who is granted access to one reporting unit through reporting tree security cannot view the report when the report is included in a Report Group.
    • User without access to folder in Report Library can open report link for Report Group but receives blank screen with no message.
    • Remove the reference to the account sets migrating in the Migration Guide.
    • Microsoft Dynamics GP guide missing required versions.
    • Management Reporter upgrades may fail on ReportRepositoryLink table.
    • Drill to Dynamics does not work for a Viewer user using the Report Viewer.
    • PERIODS calculation on CALC column only work for one company in a consolidated report.
    • GL Transaction to Fact integration error with CU7 and a case sensitive SQL Collation
    • “The operation could not be completed due to a problem in the data provider framework” error when a company does not contain an open period.
    • Report Groups do not prompt for which units of the tree to include when generating.
    • Error when drilling down on an account if “report duplicate accounts” is checked and a duplicate exists using a range of accounts.
    • Using multiple companies and Account Categories may cause report generation errors with Dynamics GP Data Mart.
    • Incorrect syntax near ‘)’ error occurs when generating a report for period 1 with an Account Modifier in the row of /Y and Start and End dates defined in the column.

Check back in future Blogs for additional description of these new Management Reporter 2012 CU8 features.