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