In one of SSRS Report requirement, client wants to see Purchase order quantity, Invoice Quantity against items purchase requisition Quantity. Instead of writing a query on ItemId and InventdimId, I found out of the box function In PurchReqLine table. This method return the reference of Purchline. With reference of Purchline, I can get Purchase order Number and get … [Read more...] about Relation between PurchLine and PurchReqline Tables in Dynamics AX 2012 R3.
Dynamics Ax 2012 R3
Select on InventSum vs InventOnHand Class Dynamics Ax 2012 R3.
Today I face the very strange behavior of X++ code. We develop customization. We generate transfer and issuance through X++. Logic was very simple,If stock is available then transfer / Issuance or Adjustment journal create otherwise generate error message, We took this decision based of query on Inventsum. It works fine in most of cases but In one case when stock is … [Read more...] about Select on InventSum vs InventOnHand Class Dynamics Ax 2012 R3.
Serial Number in Report Group SSRS Dynamics Ax 2012 R3.
Today I have small tip. Let me share a scenario. Suppose you have to display Customer group as report level group and customer at detail level who did purchased products from your organization in given period of time. Serial number on detail level can be achieved by RowNumber("Scope Name") But serial number shown on Group level is tricky because RowNumber not works there. … [Read more...] about Serial Number in Report Group SSRS Dynamics Ax 2012 R3.
Enum value to Table Insertion Dynamics Ax 2012 R3, D365 for operations
Let me share you a small tip, During customization We extend out of box Enum for classification. Later client requirement is extensive usage of new Values for classification. For adding new values in enum results dependency on technical person . So we did customization and provide form and custom table so he can create number of values as he want. But now next challenge was, … [Read more...] about Enum value to Table Insertion Dynamics Ax 2012 R3, D365 for operations
What’s New In Dynamics Ax 2012 R3 Cu12
Microsoft release update Cu12 for dynamics Ax 2012 R3. Microsoft Also release the what's new document to describe what in this Update. You can found it in this location https://mbs.microsoft.com/Files/public/CS/AX2012R3/WhatsNewinAX2012R3CU12.pdf … [Read more...] about What’s New In Dynamics Ax 2012 R3 Cu12
Custom lookup in reference group Dynamics Ax 2012
Here is little tip regarding look up. A few days ago, I have to take join with employee with my custom table. if you check that The primary key of HCMWORKER IS RecId. So I have to create worker relation based on primary key i.e recid.\ But when I drop the foreign key on form Grid. It creates reference group. And surprising this create out of the box lookup with similar … [Read more...] about Custom lookup in reference group Dynamics Ax 2012
Fatal exception performing AXRDCE transformation step. Dynamics Ax 2012 R3
During development of SSRS report I got follow error, "Fatal exception performing AXRDCE transformation step. The report cannot be rendered. Please contact your system administrator." and report stop working, It working perfectly write a few hours ago. The old trick works for me. Comment all the code in processReport method of RDP class, by adding … [Read more...] about Fatal exception performing AXRDCE transformation step. Dynamics Ax 2012 R3
Import Export data: Excel Add-ins with AIF service Dynamics Ax 2012
If you set up Aif service data in Dynamics Ax 2012, You can easily import and export data into AX using Excel Add-in. You can export, import data with all out of the box AIF services. In the case of table import export in Excel add-ins then under the hood AIF metadata service used. For current post I am using my exists custom document Service in Excel … [Read more...] about Import Export data: Excel Add-ins with AIF service Dynamics Ax 2012
Dynamics ax 2012: excel add-in publish data button disabled
Currently working with Excel add-in importing data into Dynamics Ax, I found that publish data is disabled, Latter I found that push, status, add Row, delete row and other button remains disabled until you closed the field selection by re click on field’s button. … [Read more...] about Dynamics ax 2012: excel add-in publish data button disabled
Exploring proxy classes in Dynamics Ax 2012 R3
In C# or vb.net we can connect and perform on Dynamics Ax classes and Tables with business connector. This technique is widely used in Dynamics Ax 2009 and rarely I saw these used in ax 2012. Its depends on Requirement. Consider following scenario where I have to perform different operations on following custom table. Create a New console application … [Read more...] about Exploring proxy classes in Dynamics Ax 2012 R3
Unable to find appropriate service endpoint information in the configuration object Dynamics Ax 2012.
Recently installed the SSRS report extension on my VM Dynamics Ax 2012 R2 CU7. During installation, I continuously found following error message In log files. “Unable to find appropriate service endpoint information in the configuration object” Later I understand that SSRS reports communicate with AOS through WCF services and WCF service for Dynamics Ax was not … [Read more...] about Unable to find appropriate service endpoint information in the configuration object Dynamics Ax 2012.
Exploring The SalesSalesOrderservice AIF Document Service In Dynamics Ax 2012 R3
For my session for Integration with Dynamics Ax 2012. I have to consume SalesSalesOrderSerivce. In this article I am configure and consume Sales Order service and share c# code for calling a Sales service and consume. Enable the methods and configure the inbound port. For this you have to go at following link and open AIf Inbound Right … [Read more...] about Exploring The SalesSalesOrderservice AIF Document Service In Dynamics Ax 2012 R3
List as data contract in Custom AIF service Dynamics Ax 2012
During writing one of custom AIF services, I had requirement to get and set List of certain class type. For exampel Contact list if we have to import Customer or vendor, I found following syntax for attribute to make List as data contract. [DataMemberAttribute("MyContactList"), AifCollectionTypeAttribute("contactList",Types::Class, classStr(ContactDC)), … [Read more...] about List as data contract in Custom AIF service Dynamics Ax 2012
Master Data Management Framework for Dynamics Ax 2012 eLearning course link
Recently we used Master Data Management Framework in Dynamics Ax 2012 for Initial load.. I found that Microsoft release the course on its partner resource. This course contains following topics • Module 00: Course Introduction and Expert Introduction • Module 01: Overview of Data Management • Module 02: Introduction to Data Import Export Framework • Module 03: Migrating … [Read more...] about Master Data Management Framework for Dynamics Ax 2012 eLearning course link
“Wrong field ID in the key data container in entity key” Dynamics Ax 2012 AIF
I got following Error when I called the Read method of Dynamics Ax AIF service. “Wrong field ID in the key data container in entity key” My code snippet is as follow and I did not found anything wrong with it. StudentInfoRef.KeyField keyField = new StudentInfoRef.KeyField() { Field = "FirstName", Value = "Ali2" }; // Create an entity key instance … [Read more...] about “Wrong field ID in the key data container in entity key” Dynamics Ax 2012 AIF
