1. The maximum size of the XML message that AX can receive is 64kb. In order to accept the XML of bigger size, we have to configure the Inbound port.   2. The web.config is created from the configuration of the inbound port. So, in order to preserve the changes even if the Inbound port gets reactivated, please make the changes as detailed below [Please refer to the below snapshots for your information] a. Go to the Inbound port. b. De-Activate the inbound port. c. Click on “Configure” button as shown below [A pop up window will come] d. Click “Yes” on the window popped up[Find below the snapshot of the popped up window] e. Now go to Bindings basicHttpBindingWithWindowsAuth as highlighted in the below snapshot. f. Now set the size of the property “MaxReceivedMessageSize” to a bigger value(like: 10485760). g. Save the changes and close the form. h. Click on Activate button to activate the Inbound port. i. Check the Web Config file from the above file location and verify the value that was set in the previous “step-f”. X++ code to fetch the data from Excel in AX 2012R2 I have come across the requirement to fetch the data from Excel in AX. Below is the X++ code to do the same: static void ImportDataFromExcel(Args _args) {     SysExcelApplication application;     SysExcelWorkbooks workbooks;     SysExcelWorkbook workbook;     SysExcelWorksheets worksheets;     SysExcelWorksheet worksheet;     SysExcelCells cells;     COMVariantType type;     int row;     ItemId itemid;     Name name;     FilenameOpen                    filename;     dialogField                     dialogFilename;     Dialog                          dialog;     ;     #AviFiles     #Excel     application = SysExcelApplication::construct();     workbooks = application.workbooks();       dialog = new Dialog(“ExcelUpload”);     dialogFilename      =   dialog.addField(extendedTypeStr(FilenameOpen));     dialog.filenameLookupFilter([“@SYS28576”,#XLS, “@SYS28576”,#XLSX]);     dialog.filenameLookupTitle(“Upload from Excel”);     dialog.caption(“Excel Upload”);     dialogFilename.value(filename);     if(!dialog.run())         return;     filename            =   dialogFilename.value();     application         =   SysExcelApplication::construct();     workbooks           =   application.workbooks();     try     {     workbooks.open(filename);     }     catch (Exception::Error)     {     throw error(“File cannot be opened.”);     }     workbook = workbooks.item(1);     worksheets = workbook.worksheets();     worksheet = worksheets.itemFromNum(1);     cells = worksheet.cells();    do { row++; itemId = cells.item(row, 1).value().bStr(); type = cells.item(row, 1).value().variantType(); info(strfmt(‘%1’, itemId)); } while (type != COMVariantType::VT_EMPTY); }

Creating Sales Order with address information in AX 2012R2CU7 via AIF through .Net Code Please see the below .net code static void Main(string[] args)         {             // Instantiate an instance of the service client class.             SalesOrderServiceClient proxy = new SalesOrderServiceClient();               // Create an instance of the document class.             AxdSalesOrder salesOrder = new AxdSalesOrder();               // Create instances of the entities that are used in the service and             // set the needed fields on those entities.             AxdEntity_SalesTable salesTable = new AxdEntity_SalesTable();             salesTable.CurrencyCode = “USD”;             salesTable.CustAccount = “C846456”;             salesTable.ReceiptDateRequested = Convert.ToDateTime(“4/21/2015”);             salesTable.Payment = “PP”;             AxdEntityKey_LogisticsPostalAddress LPA = new AxdEntityKey_LogisticsPostalAddress();             LPA.Location_LocationId = “5637282089”;               AxdExtType_EffectiveDateTime date = new AxdExtType_EffectiveDateTime();             date.timezone = AxdEnum_Timezone.GMT_COORDINATEDUNIVERSALTIME;             DateTime dateValue = new DateTime(2015, 4, 29, 14, 10, 53, 001, DateTimeKind.Utc);               date.timezoneSpecified = false;             date.localDateTimeSpecified = false;             date.Value = dateValue;              LPA.ValidFrom = date;              salesTable.DeliveryPostalAddress = LPA;               AxdEntity_SalesLine salesLine = new AxdEntity_SalesLine();             salesLine.ItemId = “10-009”;             salesLine.SalesQty = 9;             salesLine.SalesUnit = “ea”;               CallContext callContext = new CallContext();             callContext.Language = “en-us”;             callContext.Company = “KTEC”;             salesTable.SalesLine = new AxdEntity_SalesLine[1] { salesLine };             salesOrder.SalesTable = new AxdEntity_SalesTable[1] { salesTable };               try             {                 // Call the create method on the service passing in the document.                 EntityKey[] returnedSalesOrderEntityKey = proxy.create(callContext,salesOrder);                   // The create method returns an EntityKey which contains the ID of the sales order.                 EntityKey returnedSalesOrder = (EntityKey)returnedSalesOrderEntityKey.GetValue(0);                 Console.WriteLine(“The sales order created has a Sales ID of ” + returnedSalesOrder.KeyData[0].Value);                 Console.ReadLine();             }             catch (Exception e)             {                 Console.WriteLine(e.ToString());                 Console.ReadLine();             }         } Error Details in AX exceptionlog : “The value in field DeliveryPostalAddress is invalid.”

Key Technologies: Microsoft Business Intelligence, Power BI Note: This article assumes experience on Power BI for Office 365 using Excel 2013 and the Microsoft BI stack Power BI transforms data into rich visualizations independent of Office 365 and SharePoint Online. Newly available features: Powerful Dashboards using HTML5 without the need to install Silverlight New Visualizations =:Combo Charts =:Filled maps =:Radial gauges Support for popular SaaS Microsoft Dynamics CRM Online Salesforce Zendesk Marketo SendGrid GitHub Connectivity to on premise SQL Server Analysis services tabular models Available for iPhone, iPad & Windows tablet Q&A using Natural Language Processing Power BI Designer Tool Power BI Designer puts visual analytics at your fingertips with intuitive report authoring Drag-and-drop to place content exactly where you want it on the flexible and fluid Designer canvas Quickly discover patterns as you explore a single unified view of linked, interactive visualizations Includes data import using “Get Data”, Data modelling using “Manage” and creating reports using “Report” With “Get Data” option we can import data from different sources such as databases, web pages, data files like text, csv, xml, etc. Click on “Manage” to create relationships between different tables Create reports using different visualizations available Save the file and upload it to www.powerbi.com