Management Reporter with Multicurrency in Microsoft Dynamics GP 2015

This 22-minute video covers Management Reporter with Multicurrency Configuration in GP 2015. Topics discussed include different exchange types, and creating a Management Reporter Report from scratch.

 

Dynamics GP: FRx Migration to Management Reporter

In Microsoft Dynamics GP,  FRx has a Management Reporter (MR) migration wizard that will bring over reports into the new Management Reporter system. With a FRx migration, formatting usually comes over clean, but there are other differences between how this data is shown within the Row and Tree formats that may need some manual intervention.

In FRx, only the account number were referenced in the Financial Dimension link column within the row format.

FRx example:

15000

FRx ranges were indicated as follows:

(11511 TO 11599)

In MR, they reference the account segment name as well. When indicating a range, TO is no longer used.

MR example:

+Main Account = [15000]

MR ranges are indicated as follows:

+Main Account = [11511:11599]

The best way to quickly update these, is to copy the entire Financial Dimension column into Excel. First, do a find and replace for parenthesis and replace with brackets. Find ‘(‘ and replace with ‘[‘. Find ‘)’ and replace with ‘]’. Next, add a column for the plus (+) or negative (–) sign, the account segment name and the equal sign (=). Add the closing bracket in a separate column and then concatenate all three columns together to form what is shown in the examples above.

HINT: When entering ‘+Main Account = ‘ in Excel – it will give you an error because it thinks it is a calculation. Enter an apostrophe (‘) prior to the plus sign and it will recognize it as text.

This will get you most of the way there! Unfortunately there can still be some issues with the codes used in the Format Code column. In addition to replacing the TO with a colon as shown above, we often times need to update the TOT code as well. TOT was used a lot in FRx, but if we are adding two totals together in MR, we need to use the CAL format code and update the row references to include an ampersand (@) prior to the number.

FRx example:

TOT                       520 TO 820

TOT                       1480 + 1690

MR example:

TOT                       520:820

TOT                       @1480+@1690

Hope this helps everyone update their MR reports! If you need help updating MR reports, Tridea Partners would be happy to help! Our team has decades of experience in Dynamics GP!

This article was written by Kaydee Baker, Dynamics GP Application Consultant for Tridea Partners. Tridea is a leading Microsoft Dynamics provider serving CA, AZ, UT, CO, New England and surrounding regions.

 

Balance Sheet Reporting Without Closing YTD in Dynamics GP

It’s almost that time again. Soon it will be time to complete another year-end close in GP. Since GP will only allow adjusting entries to the SINGLE LAST closed year in GP, it can sometimes be a scary process for users. Due to ongoing audits or other various factors, it may be inevitable that adjustments will be needed for more than just one historical year. Without closing a year, the amounts for balance sheet accounts will not roll over as beginning balances for the next year. For those instances, here is a little trick that will allow for accurate balance sheet reporting, without having to complete the official year-end process in GP.

Below is an example of a Management Reporter column definition. In this example, column B is mapped to pull YTD data from the last month of the last fiscal year. Column C is mapped to pull YTD information for the current fiscal year. Both columns B and C are configured as “non-printing” columns. Finally, column D is a calculation that adds columns B and C. Voila! Accurate balances without closing the year in GP.

 

balance sheet reporting

Management Reporter and Microsoft Forecaster

We often get asked the question from our customers and prospective customers, “What will the future hold for Management Reporter and how does Microsoft Forecaster fit into that future?”  There are big plans for this reporting tool from Microsoft.  As many of you know Management Reporter just released their latest version, Management Reporter 2012.  There were many needed enhancements to Management Reporter included in this new release, highlighted here  . However, there was no functionality added that involves forecasting or collaborative budgetting for Management Reporter for Dynamics GP or Dynamics AX (as well as other Microsoft ERP products).

What about financial forecasting and collaborative budgetting?  What are the plans for Management Reporter and these important areas?  I spoke to a reliable resource close to the Management Reporter and Microsoft Forecaster teams and I was told that there are no immediate plans to add this functionality into Management Reporter.  The team will continue to support this functionality in the existing Microsoft Forecaster 7.0 tool, and for the foreseeable future they will rely on this product and the other 3rd party applications out on the market to meet this need.

Look for more exciting enhancements to Management Reporter, but don’t look for a collaborative budgetting or forecasting tool any time in the near future.