Helped a junior, build a small SSRS expression, who build hyperlink to Course page on SSRS. You can modify it with respect your need. =Microsoft.Dynamics.Framework.Reports.BuiltInMethods.GenerateDrillThroughLink( Parameters!AX_ReportContext.Value, Parameters!AX_UserContext.Value, "HRMCourseTable", "Display", "HRMCourseTable", "hrmCourseId", … [Read more...] about Drill through SSRS – Dynamics 365 for Finance and Operations
Hi, All, After Incremental CIL, errors started to appear on controller classes. These are all those classes where report Name is mentioned in code. Error message in compilation as below. Parameter _reportName cannot be null or empty. When we compiled respected class, This error move to next controller class. After compiling number of classes. Finally We decided to compile … [Read more...] about Parameter _reportName cannot be null or empty. Dynamics Ax 2012 R3
In D365 for finance things are little bit change and much more organized. In Dynamics Ax 2012, which consider as classic AX. We get ledger dimension with DimensionStorage class ledgerDim = DimensionStorage::getDynamicAccount( 'US-001', LedgerJournalACType::Cust);//Account offsetLedgerDim = DimensionStorage::getDynamicAccount( 'USMF … [Read more...] about Customer / Vendor ledger Dimension D365 for finance and operations X++
Today I just noted down a very simple parent child form customization in D365 for Finance and operations. First step is to create a primary key or alternative key For this create a Index and set Alternative key true and Allow duplicate set to no. Next step expand the table Property and set following properties. With newly … [Read more...] about Parent child form Customization D365 for Finance and Operations
I was got following error on test server. “Update Has Been Cancelled” I just fixed the Error with following article. From <https://stoneridgesoftware.com/update-has-been-cancelled-error-when-generating-a-purchase-order-invoice-in-dynamics-ax/> Posted by Eric Meissner I used to write post, which 100 % … [Read more...] about Update Has been Cancelled, Sale Order Invoice Dynamics Ax 2012 R3
I just applied the patch. After resolving all errors, I got errors when I try to refresh DataSet in Report designer. I added the new custom fields in temp table. I got this error I follow http://axdax.blogspot.com/2015/11/Domain-role-with-multiplicity-0..1-or-1.html Which described as Follow Change … [Read more...] about Domain role with multiplicity 0..1 or 1 can hold at most 1 link Dynamics Ax 2012 R3
Couple of days ago, I was helping a young developer. Who was doing some customization. He added some customization in PurchParmtable and want information in VendPackingSlipJour Table. It was very strange that there is no direct relationship between vendPackingSlipJour and PurchParmTable. After Exploring I found that There is ParmId field in … [Read more...] about Relation between VendPackingSlipJour and PurchParmTable Dynamics Ax 2012 R3
Today I have very small tip to share. I noted down, some odbc connection posts in my blog. All these post shares the code snippets , that used to open odbc connection and did query on SQL server directly. Couple of days ago, I need similar code snippet to read data from SQL server and Insert into another connect. But that code did not had reference to handling null values. So I … [Read more...] about ODBC connection and Null value Handling Dynamics Ax 2012 R3.
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.
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.