Dynamics 365 Business Central: How to check if a record/table is temporary via AL

Today I would like to share another mini tip about Business Central, how to check if a record/table is temporary in AL.

A temporary table is a temporary variable that holds a table. A temporary table is used as a buffer or intermediate storage for table data.

Source : Dynamics 365 Lab
Read more…

Dynamics 365 Business Central: How to export all keys in all tables

Today I would like to briefly talk about how to export all keys in all tables.

In AL, a key definition is a sequence of one or more field IDs from a table. You can define keys in table objects and table extension objects, depending on the type of key. There are two types of keys: primary and secondary.

Source : Dynamics 365 Lab
Read more…

Table Data Editor 2.0

Table Data Editor 2.0 is a completely free application for data editing in Dynamics 365 Business Central. In general, editing tables directly is very risky, but if you are confident in what you are doing, please go ahead. Below, you will find a description of the main functions and a link to the code and application

Source : Volodymyr Dvernytskyi
Read more…

Dynamics 365 Business Central: How to save large text/string in the table

Today I would like to talk about how to save large text/string in the Business Central table.
I was asked this question the other day, they want to save a large text in the table. e.g. length of the text is 10,000 characters. However, because of system limitations, it is not possible to create such a long text field.

Source : Dynamics 365 Lab
Read more…