Dynamics 365 Finance & Operations Talk
400 FOLLOWERS
Covers articles about Database optimization, ERP system, Microsoft dynamics, Microsoft dynamics ax and more.
Dynamics 365 Finance & Operations Talk
9M ago
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
Dynamics 365 Finance & Operations Talk
9M ago
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
Dynamics 365 Finance & Operations Talk
2y ago
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
Dynamics 365 Finance & Operations Talk
2y ago
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
Dynamics 365 Finance & Operations Talk
2y ago
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
Dynamics 365 Finance & Operations Talk
2y ago
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
Dynamics 365 Finance & Operations Talk
2y ago
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
Dynamics 365 Finance & Operations Talk
2y ago
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
Dynamics 365 Finance & Operations Talk
2y ago
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
Dynamics 365 Finance & Operations Talk
2y ago
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