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.
Microsoft Dynamics 365 for 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.
Where to download D365 for finance and Operations VM
Hi all, connect link is now part of past. VHD link on collaboration site did not work. You can down it from lcs.
For this you have subscription on LCS.Dynamics.com for D365 for Finance and operations.
After successful, login you will find Shared Asset in boxes section.
At the time of writing this small tip, Dynamics 365 for Finance and operations 8.0 platform Update 15 is just released
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, copy enum values and labels in Custom table, So He can use these value instead create again. I used following code snippet to copy data from Enum and insert into Custom table. Hopes this helps.
EnumId enumId = enumNum(LedgerPostingType); DictEnum dictEnum = new DictEnum(enumId); int _NoOfValueInEnum = dictEnum.values(); int counter; CustomTable _header; delete_from _header; for(counter = 0; counter < _NoOfValueInEnum; counter ++) { _header.ReportHeaderCode = dictEnum.index2Label(counter); _header.Description = dictEnum.index2Label(counter); _header.SortOrder=0; _header.EnumValue = dictEnum.index2Value(counter); _header.insert(); }
Data manipulation tip 4 Dynamics ax 2012 and D365 of Operations Insert_recordset
During report development we populate temp table and bind it to SSRS report. And most of the time we were doing one to one mapping inside while loop or query run loop., Kindly consider following code snippet.
While select sum(Qty) from Inventtrans group by ItemId, InventDimId , DatePhysical Where datePahyical > _fromdaet && datePhayical <_todate { Tmp.ItemId= inventrans.ItemId; Tmp.IventDim = inventtrans.InventId; Tmp.Qty = inventtrans.QTY; Tmp.Insert(); }
But if we replace loop with Insert_RecordSet , report execution time reduce much. Consider following code snippet used to replace loop with Insert_Recordset
Insert_recordset Tmp (ItemId,InventdimId,QTY) Select forceplaceholders ItemId, InventDimId, sum(QTY) From inventtrans Group by ItemId,InventDimId Where datePahyical > _fromdaet && datePhayical <_todate;
Introduction to Microsoft Flow a Video Dynamics 365 for Operations
Microsoft official channel release a video.
https://www.youtube.com/watch?v=vWU6xmq3T8M
Introduction to New Dynamics 365 for operations in 90 seconds.
Microsoft release a 90 seconds video as introduction to new Dynamics 365. More and less a advertisement video. Video release with title
Increase the Speed of Doing Business with Microsoft Dynamics 365 for Operations
https://www.youtube.com/watch?v=MlxJRUN1EiI