Learn AX

Hi Technical, Today, in this article we are going to share a solution for below error while printing SSRS Report in AX 2012. Error: For more information about this error navigate to the report server on the local server machine, or enable remote errors. Solution: Step 1:  a) Navigate to System administration/Area page/Setup/Services and Application Integration Framework/Inbound ports. b) Click on BI Services and Deactivate this. c) Now, Activate the BI Services and for testing check any invoice report. It is works then okay otherwise check step 2 below. Note : No need to take a downtime for this step. Step 2: Restart SSRS Services and for testing check any invoice report. It is works then okay otherwise check step 3 below. Step 3:  a) Take a downtime for production if you are facing this issue in Live server. b) Delete all client session. c) Restart AOS. d) Restart SSRS Services. e) Now, check any SSRS Report, it should work. We hope this solutio

Hi Technical, Today, in this post we are going to share a piece of code by which you can fetch vendor address using X++ in AX 2012. Create a AOT job and copy paste the below code to export vendor address in excel. // Project Name: PKA_WO67963_FetchCustomerVendorAddress // Created by: Chirag Gupta (ibm.chirag) // Created date: 18-Dec-19 // Summary: Fetch Vendor ID, Name or description, Address, Purpose, Primary static void PKA_VendorAddress(Args _args) {     SysExcelApplication         xlsApplication;     SysExcelWorkBooks           xlsWorkBookCollection;     SysExcelWorkBook            xlsWorkBook;     SysExcelWorkSheets          xlsWorkSheetCollection;     SysExcelWorkSheet           xlsWorkSheet;     SysExcelRange               xlsRange;     int                         row;     VendTable                   vendTable;     DirPartyTable               dirPartyTable;     DirPartyLocation            dirPartyLocation;     DirPartyLocationRole        dirPartyLo

Hi Technical, Today, in this post we are going to share a piece of code by which you can fetch customer address using X++ in AX 2012. Create a AOT job and copy paste the below code to export customer address in excel. // Project Name: PKA_WO67963_FetchCustomerVendorAddress // Created by: Chirag Gupta (ibm.chirag) // Created date: 18-Dec-19 // Summary: Fetch Customer ID, Name or description, Address, Purpose, Primary static void PKA_CustomerAddress(Args _args) {     SysExcelApplication         xlsApplication;     SysExcelWorkBooks           xlsWorkBookCollection;     SysExcelWorkBook            xlsWorkBook;     SysExcelWorkSheets          xlsWorkSheetCollection;     SysExcelWorkSheet           xlsWorkSheet;     SysExcelRange               xlsRange;     int                         row;     CustTable                   custTable;     DirPartyTable               dirPartyTable;     DirPartyLocation            dirPartyLocation;     DirPartyLocationRole       

Hi Technical, Today, in this post we are going to share a piece of code to fetch product attributes value by item id using X++ in AX 2012 R2/R3. Create a AOT job and copy paste the below code: // Created By: Chirag Gupta // Created Date: 28-Jan-20 // Summary: Get product attributes values by item id. static void PKA_GetProductAttributes(Args _args) {     InventTable                     inventTable;     EcoResProductAttributeValue     ecoResProductAttributeValue;     EcoResAttribute                 ecoResAttribute;     EcoResValue                     ecoResValue;     while select inventTable where inventTable.ItemId == "FGBRDASS0001"         join RecId from ecoResProductAttributeValue             where ecoResProductAttributeValue.Product == inventTable.Product         join Name from ecoResAttribute             where ecoResProductAttributeValue.Attribute == ecoResAttribute.RecId         join ecoResValue             where ecoResValue.RecId == ecoRes

Hi Folks, Today, in this post we are going to share a solution for below error. We got this error while running a SSRS Report from AX client. Error: 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' contains data from a type that maps to the name 'http://schemas.datacontract.org/2004/07/XppClasses:SrsReportProviderQueryBuilderArgs'. The deserializer has no knowledge of any type that maps to this name. Consider using a DataContractResolver if you are using DataContractSerializer 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 the serializer.'. Please see InnerException for more details. Soluti

Hi Readers, Today, in this post we are going to share a solution for below error. Error : The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. Solution: 1) Login to AX and end user's sessions. 2) Logout from AX. 3) Restart AX AOS services. 4) Restart SSRS Services. 5) Login to AX again and navigate to System administration/Area page/Setup/Business intelligence/Reporting Services/Report servers and click on validate settings. Please see below screenshot for your reference. 6) You should get success message after validating the settings. 7) Now, try to run a report and wait for sometime as it will take sometime to run the SSRS reports first time. 8) Enjoy, error is resolved. Comment below if you found this article helpful... Author : Chirag Gupta Microsoft Dynamics 365 AX Technical Consultant at IBM Bangalore Date : 3-Jan-2020 Happy Learning !!