SOME OF THE FEATURES THAT YOU WILL SEE CU8:
Dynamic calculated column headers. No more hard coding of Months within the column definition.
Currency translation using DDM Data Mart provider. This should start the phasing out of the legacy adapter.
Ability to create a side by side balance sheet by using a section break option in row definition.
Triangle symbol to indicate negative balances; needed for specific geographies but available for all countries.
Option to include line numbers on generated reports.
Translation support for XBRL configuration.
Ability to set all columns in definition to Autofit by default without having to set each column.
Collection of Excel formatting improvements.
Major performance enhancement in generating reports.
Additional fixes for identified product issues.
A much requested enhancement if for 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, 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)
A side by side balance sheet where assets are on one side and liabilities and owner’s equity are on the other is often required. With Management Reporter CU8, this can be done with a simple format code in the row definition.
Check out the video see how easy it is to create side by side reports.
Customers want to be able to compare their Profit and Loss accounts at the weighted average or average rate to the month end rate. (see video)
Each ERP allows one currency translation method to be applied to the account, so a report will help you accomplish this goal.
This video explains how to create a report that shows you the month end rate and apply it to the profit and loss accounts so you can compare and get a currency translation adjustment. The high level steps are:
1. Pick an account that uses the Current calculation method and add it to an Income Statement. In the example, Cash is used. It will never change, and it will always use the month end rate.
2. Hard code your functional currency in a column using Currency Display, so that when you change currency, it will remain in the base currency. In the example, USD is specified in column B.
3. Add a calculation column to divide the columns to get the spot rate. The entire column will be divided, but we only care about the first row.
4. Add formatting to hide columns and rows. Add a normal periodic column. This column will be translated at each accounts currency translation method.
5. Create another calculated column. The formula should be the USD amount column * the spot rate row. In my case, this was B*E.130.
6. Add a Currency Translation Adjustment column to subtract the two columns and show the difference.
If you are interested in attending our forthcoming training course later this month then please contact Bindu on 0097143365589 as soon as possible to reserve a place because our training courses are usually oversubscribed. This course will also benefit Dynamics GP users.
