Hi every one, here is another video. Perfection is enemy of best and Best is enemy of good. I spend 3 less sleep nights but unable to attain perfection in terms of presentation, I decided to complete it in good condition. It is beginner level video for developers. Certainly It based my 6 years technical work in Dynamics Ax 2012 and Dynamics 365 for Finance and … [Read more...] about Build Dynamics Query in Dynamics 365 for Finance and Operations – Video Webcast MsDyn365FO
Tips and tricks
Cleanup routines in Dynamics 365 for Finance and Operations- From Microsoft Blog post shared
In Dynamics 365 for Finance and Operations cleanup routines are available across various modules within the product. It is important to note that these cleanup routines should be only executed after detailed analysis and confirmation from the business this data is no longer needed. Also always test each routine first in test environment prior executing it in production. … [Read more...] about Cleanup routines in Dynamics 365 for Finance and Operations- From Microsoft Blog post shared
How to open external URL in D365 For finance and operations MSDyn365FO
Small tip, follow these steps, Create a run able class in Visual studio. in its main method write following line of code Browser br = new Browser();br.navigate("https://www.tech.alirazazaidi.com, true); Create a action menu. Set its object type to class and set object with runnable class name. Add this menu item to required menu extension. Save … [Read more...] about How to open external URL in D365 For finance and operations MSDyn365FO
Method ‘send’ in COM object of class ‘CDO.Message’ returned error and lesson learned Dynamics Ax 2012 R3.
Very interesting scenario we faced in one customization. Requirement was very simple and developer used very code to send Email. Usually testing will be done on dev box which has both AOS and client installed on same machine. No error occurred and code shipped to production. But when we deploy the code on production server and test the email sent functionality we got … [Read more...] about Method ‘send’ in COM object of class ‘CDO.Message’ returned error and lesson learned Dynamics Ax 2012 R3.
Line level Charges Sales Order Processing Dynamics 365 for finance and operations
Hi all, here is another youtube video. I used to explore things and them document. Here I documented line level charges on sales order applied based on customer charges group and Item Charges group. English is not my native language so bear with me. https://www.youtube.com/watch?v=Ot1oSBtvqJU … [Read more...] about Line level Charges Sales Order Processing Dynamics 365 for finance and operations
Disable export to Excel Customization D365 for finance and operations
We can disable the export to Excel option in list pages, There is option on grid properties "Export to Excel". Its by default true. By changing it to false disable export to excel on specific form. … [Read more...] about Disable export to Excel Customization D365 for finance and operations
Fix Certificate Issues on Development Machines Dyn365FO Dynamics 365 for finance and operations.
Today I got issue on my Dev vm hosted in local environment. Some certificate was expired. open windows menu Certificates – Local Computer > Personal > Certificates. And find expired certificate Open these certificate and copy thumbprints in Notepad ++ Open PowerShell with run as administrator and generate new clone certificates Set-Location -Path … [Read more...] about Fix Certificate Issues on Development Machines Dyn365FO Dynamics 365 for finance and operations.
Sale Order Processing Part 3 Price Listing Sales Trade Agreement Video- D365 for Finance and Operations
This is third video in Sale order Processing series using D365 for finance and operations. We use trade agreements for Price listing for Customer or group of customers. https://www.youtube.com/watch?v=Ajg9n41zlxo … [Read more...] about Sale Order Processing Part 3 Price Listing Sales Trade Agreement Video- D365 for Finance and Operations
Trying:exec BudgetControlCheckBudgetProc :BudgetControlCheckBudgetProc: Dynamics Ax 2012 R3
Hi all I faced this error on Production server. Error occur when User Post Purchase Invoice. [Microsoft][SQL Server Native Client 11.0][SQL Server]BudgetControlProcessProc ( in SysRaiseErrorProc): Trying:exec BudgetControlCheckBudgetProc :BudgetControlCheckBudgetProc: Trying:Initial insert #BSTDStage - BudgetSourceTrackingDetail:String or binary data would … [Read more...] about Trying:exec BudgetControlCheckBudgetProc :BudgetControlCheckBudgetProc: Dynamics Ax 2012 R3
Required table did not appear in relation drop-down D365 for Finance and Operations.
Hi All, I was doing my Pilot project in D365 for Finance and operations. I want to add HCMWorker relation to my custom table. But did not found in drop down. It means model reference(Package) was not included in Current Model. For this For this first check Required model on table and add its reference On … [Read more...] about Required table did not appear in relation drop-down D365 for Finance and Operations.
Data Manipulation in Dynamics Ax 2012- Array as Extended Data Type
I found a array based field in TSTimesheetLineWeek table, Field TSWeeklyHours Now challenge is to enabled field based on Array. For example need to disabled on day 6. Following code snippet help me to enabled disabled fields generated on the base of array extended Type TSTimesheetLineWeek_ds.object(fieldId2Ext(fieldNum(TSTimesheetLineWeek, Hours), … [Read more...] about Data Manipulation in Dynamics Ax 2012- Array as Extended Data Type
How to get Worker’s Dependent Dynamics Ax 2012 R3
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
Updating Date Effective Tables in AX 2012, Dynamics 365 for finance and operations
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
System.Net.ProtocolViolationException: Cannot send a content-body with this verb-type. Dynamics Ax 2012 Json Service
The piece of code you wrote, take long way to reach production server. And usually different errors occurs when we take code one server to other. I test restful service code C# class and call it form X++ code multiple times and it works perfectly fine on QA. But when I took same code to Uat server it started throw following error System.Net.ProtocolViolationException: … [Read more...] about System.Net.ProtocolViolationException: Cannot send a content-body with this verb-type. Dynamics Ax 2012 Json Service
Json Service Call in Dynamics Ax 2012.
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.
