Create Table Extension with Tenerife-Visual Studio Code

At the moment Microsoft development tool is still evolving and getting updated day by day.

In this blog post we will see how how to create Table extension object.

The table extension allows you to add more fields or change properties on a table. Along with defining other fields,the table extension is where you can write trigger code for additional fields.

In visual studio code by typing ttableext will create basic layout for table extension object when using AL extension in Visual Studio code.

Following properties can be changed for table

  1. Width
  2. OptioncaptionML
  3. Description
  4. ClosingDates

How to Write Code 

For example now if you would like to add one field in table and write some validation on that field then you can write as follows. In this I am adding field in Table 23 Vendor as Credit Days with datatype Integer.

tableextension 70000030 CreditDays extends Vendor
{
fields
{
field(70000900;CreditDays;Integer) 
{
trigger OnValidate();
begin
if (rec.CreditDays < 0) then
begin
message('Credit Days can not be blank');
end; 
end;
}
}
}

Stay tuned for more and Keep updating and learning .

Cheers

Author: Ammolh Saallvi

I'm a Dynamics NAV/Navision developer and helps partners and end-users with their NAV implementations. I do everything from third-party management advisory, training to new NAV teams, project management, training, setup and development. Do you want to hire me to help getting your project a success? Then contact me via dropping one email from linkedin Expertise in end-to-end development of software products from requirement analysis to System Study, Documentation and Testing. Demonstrated abilities in analyzing information system needs, evaluating end-user requirements, custom designing solutions, troubleshooting for complex information systems management. Deft at carrying out risk analysis, impact analysis, project reviews and documentation. Strong Problem solving & Technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction as well as low operational costs. Certifications:- Microsoft Certified Technology Specialist -Dynamics Microsoft Sure Step Certified Professional Moderator at DUG Forum Specialties: • ERP Implementation • Client/Server Programming • Coding, Testing, troubleshooting and documentation. • Database Tuning and SQL • Database Performance • Debugging large programs • Project Management and Resource Management.

3 thoughts on “Create Table Extension with Tenerife-Visual Studio Code”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.