Management Reporter 2012 Versions and Build Numbers

 

Release Version Release Date Build Number Features GL Versions Download Links
CU16 + latest updates March  2018 2.12.16002.0 Support for SQL Server 2017 AX 2012, AX 2012 R2, AX 2012 R3, AX 2009 RU8, GP 2013, GP 2013 R2, GP 2015, GP 2015 R2, GP 2016, GP 2016 R2, GP 2018*, SL 2011, SL 2015
CU16 February 2017 2.12.16000.17 Https support
Hebrew (he-il) localisation
Additional fixes for products defects
Support for SQL Server 2016
AX 2012, AX 2012 R2, AX 2012 R3, AX 2009 RU8, GP 2013, GP 2013 R2, GP 2015, GP 2015 R2, GP 2016, GP 2016 R2, GP 2018*, SL 2011, SL 2015
CU15 April 2016 2.12.15000.56 Improved responsiveness in the Web Viewer
Search for Web Viewer
Printing in Web Viewer via XPS download
PowerShell module for reset of data mart
Additional fixes for product defects
Microsoft Dynamics GP 2016 partially supported. Data Validation will be added in a future hotfix.
AX 2012, AX 2012 R2, AX 2012 R3, AX 2009 RU8, GP 2013, GP 2013 R2, GP 2015, GP 2015 R2, GP 2016, GP 2016 R2, SL 2011, SL 2015
CU14 November 2015 2.12.14001.45 Report Options for Web Viewer (DDM only)
Change Period and re-generate report from Web Viewer
Keyboard accessibility for Drill to Dynamics
Microsoft Dynamics AX 2012 enhancements for budget submodels with multiple parents
Microsoft Dynamics AX 2012 Budget Control enhancements including new attributes
Microsoft Dynamics GP performance improvements (previously released as CU13 hotfix 3682838)
Many fixes for exporting to XPS
Additional fixes for product defects
AX 2012, AX 2012 R2, AX 2012 R3, AX 2009 RU8, GP 2013, GP 2013 R2, GP 2015, GP 2015 R2, GP 2016, GP 2016 R2, SL 2011, SL 2015
CU13 July 2015 2.12.13002.1 View a report in the web viewer in a grid view
Display zero rounded values and zero actual values based on a report definition option
Choose where the line number column displays on a report
Display date formats in the report header based on regional settings
Display calculated rows on the same line for different columns
Report on closing transactions for Microsoft Dynamics AX 2012
Additional fixes for product defects
AX 2012, AX 2012 R2, AX 2012 R3, AX 2009 RU8, GP 2013, GP 2013 R2, GP 2015, GP 2015 R2, SL 2011, SL 2015
CU12 April 2015 2.1.12000.26 Indication of currently active reporting tree node
Ability to use BASE+1:12 in the column definition
Ability to exclude NP rows from exporting to Excel by disabling the export of formulas
Ability to export NP rows at the Account and Transaction detail levels
Additional fixes for product defects
AX 2012, AX 2012 R2 CU1+, AX 2012 R3, AX 2009 RU8+, GP 2010, GP 2010 R2, GP 2013, GP 2013 R2, GP 2015, SL 2011, SL 2015
CU11 December 2014 2.1.11000.32 Ability to select the closing period(s) you wish to include in your report for Microsoft Dynamics AX
Currency Translation fixes for Microsoft Dynamics GP
Improved performance for integration and report generation
Ability to drill into a Total row from within the Web Viewer
Companies can be enabled or disabled for reporting within Microsoft Dynamics GP 2015
Companies can be enabled or disabled for reporting within Microsoft Dynamics SL 2011 and 2015
Additional fixes for product defects
AX 2012, AX 2012 R2 CU1+, AX 2012 R3, AX 2009 RU8+, GP 2010, GP 2010 R2, GP 2013, GP 2013 R2, GP 2015, GP 2015 R2, SL 2011, SL 2015
CU10 September 2014 2.1.10001.112 Export row-based TOT formulas to Excel
An additional parameter has been added to control header and footer options for
exporting to Excel in page view vs. normal view
Removed account category from showing in the viewer and exported reports
Improved generation and viewing performance if using SQL Server 2014 Enterprise Edition
Ability to include or exclude companies for reporting in the Dynamics GP data mart
Ability to exclude Analytical Accounting details in the Dynamics GP data mart
Improved integration performance for large ERP databases
Additional fixes for product defects
AX 2012, AX 2012 R2 CU1+, AX 2012 R3, AX 2009 RU8+, GP 2010, GP 2010 R2, GP 2013, GP 2013 R2, NAV 2009, SL 2011, SL 2015
CU9 May 2014 2.1.9001.11 View a list of previous month’s reports and open them in the web viewer
Refresh a report in the web viewer
Publish a report from the web viewer
Headers and footers are shown by default in the web viewer
Enhanced data detection in the Configuration Console
Support for dynamically displaying currency symbol, currency code and currency description (AX 2012 CU6 or AX 2012 hotfixes, SL 2011, GP 2013)
Support for SQL Server 2014
Additional fixes for product defects
AX 2012 CU4+, AX 2012 R2 CU1+, AX 2009 RU8+, GP 2010, GP 2010 R2, GP 2013, NAV 2009,  SL 2011
CU8 February 2014 2.1.8000.44
2.1.8001.0
Auto text in CALC columns
Currency translation for Microsoft Dynamics GP 2013 data mart
Side by side reports
Attributes for Chinese financial statements
Line numbers on reports
Auto fit default width in columns
Excel enhancements
Business Analyzer for Microsoft Dynamics AX
View web viewer reports for Azure service bus
AX 2012 CU4+, AX 2012 R2, AX 2009 RU8+, GP 2010, GP 2010 R2, GP 2013, NAV 2009,  SL 2011
CU7 October 2013 2.1.7044..43
2.1.7045.12
Drill back to Microsoft Dynamics with Management Reporter web viewer (AX 2012 R2 CU7, GP 2013, SL 2011)
Management Reporter in Dynamics AX 2012 install (AX 2012 R2 CU7)
Currency Translation for Dynamics AX 2012 (AX 2012 CU6 or AX 2012 hotfixes)
Dimension order for Dynamics AX 2012 (AX 2012 R2 CU7)
Fixed Asset Acquisition Date attribute for Dynamics AX 2012
XBRL support for Germany
AX 2012 CU4+, AX 2012 R2, AX 2009 RU8+, GP 2010, GP 2010 R2, GP 2013, NAV 2009,  SL 2011
CU6 July 2013 2.1.6041.36 Full language support
Single report link for report group
Report group enhancements 1
14 default reports
Vendor, customer and audit attributes
AX 2012, AX 2012 R2, AX 2009 RU8+, GP 2010, GP 2010 R2, GP 2013, NAV 2009,  SL 2011
RU5 April 2013 2.1.1037.12
2.1.1033.17
Collapse detailed report into summary view
Default report link location
Web viewer as default viewer
Management Reporter Report Designer in Dynamics AX 2012 menus (AX 2012 R2 CU5)
Rework transaction detail storage
Drill back to Dynamics GP from data mart in desktop viewer
Languages: Brazil,Japan
AX 2012, AX 2012 R2, AX 2009 RU8+, GP 2010, GP 2010 R2, GP 2013, NAV 2009,  SL 2011
RU4 January 2013 2.1.1033.3
2.1.1033.37
SL 2011 data mart
AX Budget Planning support
Quick links in web viewer
AX 2012, AX 2012 R2, AX 2009 RU8+, GP 2010, GP 2010 R2, GP 2013, NAV 2009,  SL 2011
RU3 November 2012 2.1.1031.4
2.1.1032.5
Web viewer
Data mart for GP 2010
AX 2012, AX 2009 RU8+, GP 2010, GP 2013, NAV 2009,  SL 2011
RU2 July 2012 2.1.1029.3
2.1.1030.2
SQL Server 2012 support
Currency Translation for Dynamics GP 2010 Legacy provider
AX 2012, AX 2009 RU8+, GP 2010, GP 2010 R2, NAV 2009,  SL 2011
RU1 April 2012 2.1.1028.0 Quality release AX 2012, AX 2009 RU8+, GP 2010, GP 2010 R2, NAV 2009,  SL 2011
RTM March 2012 AX 2012, AX 2009 RU8+, GP 2010, GP 2010 R2, NAV 2009,  SL 2011
Advertisements

C#: Deserializing Json Array using Newtonsoft.Json

Deserializing Json Array using Newtonsoft.Json

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Newtonsoft.Json;

namespace ABJNewtonsoftJson
{
public class Program
{
static void Main(string[] args)
{
string json = @”{‘lines’:[
{‘RecId’:35637332944,’LineNumber’:1,’ItemId’:’VH001′,’ReceivedQty’:2},
{‘RecId’:35637332945,’LineNumber’:2,’ItemId’:’VH002′,’ReceivedQty’:6},
{‘RecId’:35637332946,’LineNumber’:3,’ItemId’:’VH003′,’ReceivedQty’:8},
{‘RecId’:35637332947,’LineNumber’:4,’ItemId’:’VH004′,’ReceivedQty’:9},
{‘RecId’:35637332948,’LineNumber’:5,’ItemId’:’VH005′,’ReceivedQty’:1}]}”;
//PurchLineData purchLineData = JsonConvert.DeserializeObject<List<PurchLineData>>(json);

PurchLineDataList purchLineDataList = JsonConvert.DeserializeObject<PurchLineDataList>(json);

for (var i = 0; i < purchLineDataList.lines.Count; i++)
{
Console.WriteLine(“RecId : {0}”, purchLineDataList.lines[i].RecId);
Console.WriteLine(“LineNumber : {0}”, purchLineDataList.lines[i].LineNumber);
Console.WriteLine(“ItemId : {0}”, purchLineDataList.lines[i].ItemId);
Console.WriteLine(“ReceivedQty : {0}”, purchLineDataList.lines[i].ReceivedQty);
Console.WriteLine(‘\n’);
}
Console.ReadLine();
}
}

public class PurchLineDataList
{
public List<PurchLineData> lines;
}

public class PurchLineData
{
public Int64 RecId { get; set; }
public int LineNumber { get; set; }
public string ItemId { get; set; }
public int ReceivedQty { get; set; }
}
}

AX 2012 R3: “No device” keep on showing when opening AX clients.

AX 2012 R3: No device showing when opening AX clients.

No device error message shown, when opening Microsoft Dynamics AX 2012 R3 Clients.

1

Check if telephony integration is activated in Licence configuration, if activated deactivate it if not needed.

System Administration > Setup > Licensing > License configuration.

5

Untick and click Apply to deactivate Telephony integration.

2

Click OK to continue.

3

Synchronise to make configuration changes take effect.

4

 

Ariston J.

AX 2012: Error when in SSRS print preview

Error in Microsoft Dynamics AX 2012 Reports Print Preview

The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://tempuri.org/:queryBuilderArgs. The InnerException message was ‘Element ‘http://tempuri.org/:queryBuilderArgs&#8217; contains data from a type that maps to the name ‘http://schemas.datacontract.org/2004/07/XppClasses:SrsReportProviderQueryBuilderArgs&#8217;. The deserializer has no knowledge of any type that maps to this name. Consider using a DataContractResolver or add the type corresponding to ‘SrsReportProviderQueryBuilderArgs’ to the list of known types – for example, by using the KnownTypeAttribute attribute or by adding it to the list of known types passed to DataContractSerializer.’.  Please see InnerException for more details.

The formatter threw an exception while trying to deserialize the message
Solutions:

Check Inbound Ports in Microsoft Dynamics AX Client.

The formatter threw an exception while trying to deserialize the message - sol

Activate Inbound Ports “BIServices” then try to print reports again.

It also important to activate inbound services as possible.

The formatter threw an exception while trying to deserialize the message - sol 2

 

AX 2012: Convert Base64String to Images File

Convert Base64String to Images files or PNG Files.

In my scenario, I need to read Base64String from other application through web services and save it as images file in my server computer.

 

static void convertBase64ToImages(Args _args)

{

str base64String = ‘XXXXXX-BASE64STIRNG-XXXXXX’;

// Save the image

AifUtil::saveBase64ToFile(@”C:\TEMP\TEST1.PNG”, base64String);

}

 

AX 2012 R3: Purpose in Edit Address Form – Roles and description not showing label text.

Problem: AX 2012 R3: Purpose in Edit Address Form – Roles and description not showing label text.

MS AX Versions: Microsoft Dynamics AX 2012 R3 CU12

The purpose field is showing label id instead of showing the correct label text, like image below:

purpose-roles-and-description-not-showing-label

Did anyone encountered above issues, we will be happy if you can share with us.

 

Wish you the best,

Ariston Javier

 

 

This page might not function correctly because either your browser does not support scripts or active scripting is disabled.

Got below warning messages when opening SQL Server Reporting Services:

“This page might not function correctly because either your browser does not support scripts or active scripting is disabled.”

1

Solution:

Adding your sites in Internet Option Trusted sites and then checked Enabled Protected Mode (requires restarting Internet Explorer) then click Apply and OK.

Procedures:

1. Go to Tools > Internet Options. See image below.

2.png

2. In Internet Options go to Security Tab select Trusted sites then click Sites button. See image below.

3

3. In Trusted sites window, Type the website address under Add this website to the zone then click Add and Close. See image below

4

4. After adding the sites, checked “Enable Protected Mode (requires restarting Internet Explorer)” then click Apply and OK button.

5

5. Try to refresh Internet Explorer.

7

Done 🙂

 

 

 

AX 2012: Post Sales Invoice using X++

AX 2012: Post Sales Invoice using X++

static void postSalesInvoice(Args _args)
{
SalesFormLetter salesFormLetter;
SalesTable salesTable;
SalesId salesId = ‘005063’;
System.Exception error;
str strError;
CustInvoiceJour custInvoiceJour;
;

ttsBegin;
try
{
salesTable = SalesTable::find(salesId);

if (salesTable && salesTable.SalesStatus == SalesStatus::Delivered)
{
salesFormLetter = SalesFormLetter::construct(DocumentStatus::Invoice);
salesFormLetter.update(salesTable, systemDateGet(), SalesUpdate::All, AccountOrder::None, NoYes::No, NoYes::No, NoYes::No, NoYes::Yes);

if (salesFormLetter.parmJournalRecord().TableId == tableNum(CustInvoiceJour))
{
custInvoiceJour = salesFormLetter.parmJournalRecord();
info(strFmt(‘Sales Order #:%1 has been successfully posted and Invoice #:%2 is created!’, custInvoiceJour.SalesId, custInvoiceJour.InvoiceId));
}

}
else
{
info(strFmt(‘%1 does not exsists or null in the system, please try again!’, salesId));
}

}
catch (Exception::CLRError)
{
error = CLRInterop::getLastException();
strError = error.ToString();

info(strfmt(‘%1’, strError));
info(strFmt(‘%1 failed to post, please try again!’, salesId));
}
ttscommit;
}