Virtual Field: A virtual field in D365FO is a field that doesn't have a direct representation in the database. It's a field that you can define in a table as if it were a regular data field, but its value is computed on-the-fly based on certain calculations or business logic whenever it is queried. Virtual fields are often used to display derived or computed information without storing it in the database. Advantages of Virtual Fields: No need to store redundant data in the database. Useful for displaying calculated values without performing calculations every time. Computed Field ..read more

  Differences & Advantages Chain of Command (COC): Chain of Command is an extension framework in D365FO that allows developers to customize and extend standard application logic without modifying the original code. It enables you to add new business logic, validations, and modifications to existing methods in base classes. COC works by creating an extension class for the base class you want to modify and then overriding or adding methods within this extension class. COC supports before, after, and around method events. Advantages of COC: Non-intrusive: Original code remains untouc ..read more

  File attachment virus security Dynamics 365 Finance & Operations   This is a normal scenario in every implementation that Business users are allowed to attach any documents with any records using the existing attachment feature.   What about if a Business user uploads intentionally or unintentionally the virus-affected file or virus in the shape of any document. It could make a heavy impact, If the other use opens the affected attached file or virus, and if your network of the machine is not properly secure with antivirus.   How you can protect to reduce the chances t ..read more

  RecordInsertList Dynamics 365 Finance & Operations A shortcode example of how to can create records in a table very performant way using RecordInsertList. Who does not know RecordInsertList, can learn more about it here. static void HowToUseRecordInsertList(Args _args){ DMOPerfTest DMOPerfTest; RecordInsertList RecordInsertList; Counter c; FromTime fromTime = timeNow(); RecordInsertList = new RecordInsertList(tableNum(DMOPerfTest)); for (c=1;c<=10000;c++) { DMOPerfTest.clear(); DMOPerfTest.AccountNum = int2str(c); if(DMOPerfTe ..read more

  Data Management Project Using X++ Using the following code, you can import the file and execute the project using your x++ code. In the code, I am making the file on runtime and uploading the file into temp storage for the demo purpose but you can use the file uploader as per your requirement. Code class AD_Test {     /// <summary>     /// Runs the class with the specified arguments.     /// </summary>     /// <param name = "_args">The specified arguments.</param>     public static void main(Args _args) &nbs ..read more

  Change existing Index D365FO   As we all have a requirement in the past to perform the changes in the existing indexes, and as we know the customization is not allowed in the OOTB elements, so we couldn’t achieve this.   How we can achieve it?   In D365FO, we couldn’t delete or disable the existing index, but there is one way to achieve this. We can disable the index on SQL level by using the SQL script even on prod.   Yes, you are reading correct, we can disable the index and it will not enable again during package deployment, please only disable the index not remov ..read more

Mandatory Field with user Personalization This feature is available in Version 10.0.12, and you can enable this feature from feature management. Many times we receive requests from the customers that for their internal control purpose they want to make few fields mandatory in the particular form. Earlier we had to connect with the technical team and make it mandatory but now it's not required. End-user itself can make the field mandatory base on requirements. Here are the steps you can follow to achieve this requirement. Ste-1 Go to the feature management and enable the feature like below ..read more

  Difference between AX 2012 and D 365 Finance and Operations Apparently, in layman terms, we can say the Three main visible changes in D365 : New Client Cloud Readiness New Development Stack Key terms in D365: Packages: A package is a deployable unit, which may have multiple models. Model:  A model is a group of elements, a model is a collection of elements that represent a distributed software solution. Element:  Element is any object residing in AOT. eg: Base Enum, any EDT, Table, Form which you see in AOT tree is an element itself.   Project ..read more

 Grid Control New features Fast data entry:  This feature lets users enter data in a grid ahead of the server. Therefore, it minimizes the need for users to wait for the server to validate one row in the grid before they move to another row. Users can also paste copied tables from Excel directly into grids in the system. Mathematical formulas: Users can now enter mathematical formulas into numeric cells in a grid. For example, you can enter =15*4. To make the system recognize a value as an expression, start the value with an equal sign (=). General improvements: Various ..read more

  Recordset operations or set based operators We all noticed that AX 2012 and D365FO get slow from time to time when we performed insertion or update operations on huge numbers of records one by one, and to overcome this issue, Microsoft has a feature to update or insert in bulk in a single statement.   We have 3 types of Bulk Operations insert_recordset update_recordset delete_from insert_recordset : insert_recordset copies data from one or more tables directly into one resulting destination table on a single server trip. Using insert_recordset is faster than using an array i ..read more