Table Methods in Microsoft Dynamics 365 F&O

Table methods are the base level of code that can be done for validation. The code in methods is also referred to as custom business logic. When records are inserted, deleted, updated, or validated from a table various standard methods are called.
We can alter the standard methods by overriding the standard methods. or creating COC for the table.
Below are a few examples of the most commonly used Table methods:

1. InitValue() method:

If we create a new record from form or table level, this method is called. It is used to set a default value for specific fields.

public void initValue()
{
super();
this.custName = "Dynamics Community 101";
}

Due to this method, the field custName will now have the default value “Atul”.

2. ModifiedField() method:

Whenever the value of a field is changed/modified this method is called upon. It is used to perform certain actions when we modify certain fields.

public void modifiedField(fieldId _fieldId)
{
switch(_fieldId)
{
case fieldnum(custTable, custName):
this.custId="15";
break;
default:
super(_fieldId);
}
}

Whenever the customer name of an existing record or new record is modified, then you will notice that custID is immediately set to “15”.

3. Orig() method:

When the value of a field is modified, it is possible to recall the previous value of that field by using below code.

this.orig().salesId;

4. ValidateField() method:

This method is used for validation and has a boolean return type. If it returns false, the application will prevent the user from making any changes in that field.

public boolean validateField(fieldId _fieldIdToCheck)
{
boolean ret;
ret = super(_fieldIdToCheck);
if (ret)
{
switch (_fieldIdToCheck)
{
case fieldnum(custTable, custName):
if (strlen(this.custName) <= 3)
ret = checkFailed("Customer name must be greater than 3 characters.");
}
}
return ret;
}

5. ValidateWrite() method:

This method is used to validate each mandatory field. It gives back data of boolean type. If it returns false then the insert operation will not happen.

public boolean validateWrite()
{
boolean ret;
if(this.custName != "")
ret = super();
else
warning(" Please fill the value");
return ret;
}

6. ValidateDelete() method:

When a user tries to delete a record then this method is first called. Only if this returns true then the record will be deleted,

public boolean validateDelete()
{
boolean ret;
ret = super();
info(this.custName);
return ret;
}

7. Insert() and Update() method:

These are standard methods that are called while inserting or updating a record.

public void Insert()
{
custTable custTable;
ttsbegin;
custTable.initValue();
custTable.custId = "101";
custTable.custName = "DynamcisCommunity101";
custTable.custBalance = "101";
if (custTable.validateWrite())
custTable.insert();
ttscommit;
}

Need help? Connect Atul

• Author
• Recent Posts

Atul Yadav

Lead Technical Consultant at Lifestyles

As a leading Dynamics 365 F&O Technical lead, Atul brings extensive experience in developing custom solutions that drive business efficiency. His skill set uniquely includes Azure DevOps for Dynamics 365 F&O, enabling efficient project management, automation, and deployment processes. Additionally, his expertise in Power Platform allows for the creation of powerful business solutions that leverage data analysis, app development, and automation.

His proficiency in Azure integration further distinguishes his capability, facilitating seamless connections with Dynamics 365 F&O and enhancing business operations. Committed to project success, he provides ongoing support and shares industry insights through his blog, contributing to the professional community's growth.

Latest posts by Atul Yadav (see all)

• Logic apps VS Power Automate flow - June 28, 2024
• Multithreading batch job in Microsoft Dynamics 365 Finance and Operations - June 21, 2024
• Generate a CAR(Customization Analysis Report) report in Microsoft Dynamics 365 F&O - June 17, 2024