Dynamics Financial Reporting

All about financial reporting and consolidations for Microsoft Dynamics ERPs

Autotext in CALC columns (CU8 feature)

Autotext in CALC columns (CU8 feature)

  • Comments 2

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)

This was a highly requested feature on the Connect site with over 55 votes. Thank you for all of those who took the time to vote on this suggestion.

Watch the video below for more information on how to use this feature.

 

 

 

Leave a Comment
  • Please add 6 and 2 and type the answer here:
  • Post
  • Even in full screen, it's difficult to see the details in the video.  Please consider recording future videos with a higher resolution.

  • Dear Microsoft what happened to @txtdate autotext? I have a customer that misses the Month, day year layout for example As of April, 30 2014. Right now we are handling manually by entering on report generation which is a pain.

Page 1 of 1 (2 items)