Table Extensions in Business Central

 

Ever wondered what really goes on behind the scenes when you're making a table extension in Business Central?


To find the answer, i created a new Extension for table "Sales Header" and added a new field "Rush Shipping".




View in SQL -

>    A new table is created by Business central automatically.

>    New table contains the primary keys from parent table and also the newly added fields.






Comments

Post a Comment

Popular posts from this blog

Unable to Remove Actions from Page/Double Actions on Page

Image
                     We may come across the scenario where we see multiple actions on the page, but some of them are not       working. As an example, we take the following object. Object Type - Page Object Id - 44 Object Name - Sales Credit Memo I Removed all the actions, but still below shown buttons are available and we cannot remove them. Also some of the buttons are giving the error. Solution : - Go to following path – Departments/Administration/IT Administration/Data Deletion/Configuration and Personalization       Go to both the pages. i)     Departments/Administration/IT Administration/Data Deletion/Configuration and Personalization/Delete Profile Configuration ii)     Filter Page Id  iii)   Delete all the entries. Do the same steps for “Delete User Personalization” Check the page 44 (Sales Credit Memo) again After Changes.
Read more
Image
  Auto Import of Objects from Dev to Test system I got a requirement to develop a solution so that technical changes can be moved automatically from Dev to Test system. Why we want to do this -  1) If developers have direct access on test system then there is a high risk that they will be developing directly on test system and this results in poor documentation, plus more issues when things move to prod. 2) Well there are custom solutions available, but the additional features that are being delivered are not needed. How i did this -  1) Created a powershell script. 2) Created a bat file. 3)  Created a directory to store the imported files. 4) Created a task in application server to run the bat file. Detailed Steps -  1) Powershell script -  2) create a notepad file and save it as .bat file with following code -  3) Look for task scheduler - 4) Create a task -  5) Specify path of your bat file, define the intervals when you want to run the task. Powershell Script -  Save this as AutoIm
Read more

STX File Issue - Errors in the text conversion Dynamics NAV 2017

STX File Issue Error -  There are errors in the text conversion because text no. 1880-4 does not exist in the .stx file. Internal error: 47-1 Places where you can get this error -  1) While opening the database in navision. 2) When you try to import the objects in navision. Resolution - The CU17 version of NAV 2017 contains new text constants in development environment. Therefore after installation we need to replace 2 files in NAV installation folder. - path: C:\Program Files (x86)\Microsoft Dynamics NAV\100\RoleTailored Client\ENU - files: fin.etx, fin.stx (in attachment). These files have to be replaced in every installation (on each machine that development environment is running). The files in attachment are only for English language version. If you are using different language, you need to find the specific files for this language (usually in installation folder). You can download the Stx files from here -  Stx Files Feel free to connect with m
Read more