Dynamics 365 Business Central: How to get fields in the keys of the table (Using KeyRef Data Type)

Today I would like to talk about an interesting method in Business Central customization, how to get fields in the keys of the table.

As you might know, 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…

How to foresee potential lockings on your tables | Business Central

What a beautiful code I just finish to create… Let’s skip the tests… Put it in a Prod environment and hope for the best. Booommmmmmmmm!

Well, not so frequently nowadays, but, in a rush, is still happening, right!? You don’t need to answer… Even though you tend to say that it’s a lie, it still happens. I know!

Source : ToolGBRMaker
Read more…