Here is small and quick tip. Couple of Days ago I helped a developer to get Dependent out of worker. Microsoft provide a View DirPartyRelationshipsUnionView. Here Worker Party Id is saved as "otherParty" and dependent Party id can be found as " SELFPARTY". Quick SQL query is below, select name from DIRPARTYTABLE where recid in ( select SELFPARTY from … [Read more...] about How to get Worker’s Dependent Dynamics Ax 2012 R3
I was struggling to update Date Effective Table in Dynamics Ax 2012 R3. At least one hour of struggle, finally I update the required record. Only good post which helps is by Agnela GoldBrg. http://ibisinc.com/blog/updating-date-effective-tables-in-ax-2012/ One line tip from this post is on Date Effective table, The active record reference … [Read more...] about Updating Date Effective Tables in AX 2012, Dynamics 365 for finance and operations
Hi all, I found two precisely written post by José A. Estevan https://blogs.msdn.microsoft.com/axinthefield/embrace-the-extensions-mindset-with-dynamics-365-for-finance-and-operations/ https://blogs.msdn.microsoft.com/axinthefield/embrace-the-extensions-mindset-with-dynamics-365-for-finance-and-operations-2-sysextension-framework/ Also … [Read more...] about Extension Perspective Microsoft Blog posts Dynamics 365 for Finance and operations
Recently I got chance to call restful Json based service in Dynamics Ax 2012. I used a C# class library and then add to AOT. AX 2012 Json based service successfully called both client side and server side. Only tricky part was to make Json string or payload. I used to make Json string something similar. Both works in C# as well as X++ payload += … [Read more...] about Json Service Call in Dynamics Ax 2012.
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.
Relationship between VendInvoiceInfoTable and VendInvoiceJour. Is Parm Id. This problem occurs when we need some customization on vendor Invoice form and values of these fields required in reporting. Due to minor nature no impact on calculation. For getting these fields to VendorInoviceJour required complex customization, God knows what will broke or long way of testing require … [Read more...] about Relation between VendInvoiceInfoTable and VendInvoiceJour Dynamics Ax 2012 R3