How to create new fields in Standard Tables with No Impact on System/Release/Patch Update

Hi there,
May I have the idea how to make the right customization on any Standard Tables specially to add new fields to avoid the incompatible issue when the system needed to be updated/upgraded with System Patch/New Release, please? Let’s supposed we need to have more info in AA table (RecID, AA1, AA2, AA3 and AA4 are standard fields) which is the standard table, is that the right idea to create new table, AA_CUZ, to store new fields if we need to have additional data in AA? Rather than appending new fields in AA like AA-AA5_Cuz and AA-AA6_Cuz, we create them in AA_CUZ like AA_CUZ-AA5_Cuz, AA_CUS-AA6_Cuz then using RecID as a key to join AA and AA_CUZ.

Tasama S.

Normally, you would just create a Table Extension linked to the standard table. For example, let’s say you wanted additional customer fields, you would just create a table extension for the customer table with the new fields. Also, create a page extention with the new fields to extend the customer page. Those new fields would then appear on the customer page or in configuration packages or the page inspect factbox as if they were part of the customer table. When the database is upgraded, these would not be impacted and would still be part of the extended table. With BC, you can no longer add fields directly to the table like you could do with NAV & C/AL. You must use extentions.

2 Likes

Tasama,

I add new fields and also updates using the Object Designer APP from eFocus. I am not a developer so this made my life so easy without being a programmer. Here is the APP link:

https://appsource.microsoft.com/en-us/product/dynamics-365-business-central/PUBID.hougaard-4699382|AID.designer|PAPPID.4c032704-5c36-4480-b710-29e8565568bc?tab=DetailsAndSupport

Hope this helps.
Thanks,
Steve