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

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
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

Powershell in Navision

Image
'll Try to keep things as easy as possible Powershell is a scripting tool, we often see people using following window - Don't use this window, instead use Powershell ISE - Above shown window is more of an IDE for using Powershell, it helps you to use Powershell commands but in an easier way. How to start this? Search for Powershell ISE and choose Run as an administrator - Write the following commands -   Set-ExecutionPolicy Unrestricted  Import-Module "${env:ProgramFiles(x86)}\Microsoft Dynamics NAV\100\RoleTailored Client\Microsoft.Dynamics.Nav.Model.Tools.psd1" -WarningAction SilentlyContinue | out-null Import-Module "$env:ProgramFiles\Microsoft Dynamics NAV\100\Service\NavAdminTool.ps1" -WarningAction SilentlyContinue | Out-Null Import-Module "${env:ProgramFiles(x86)}\Microsoft Dynamics NAV\100\RoleTailored Client\Microsoft.Dynamics.Nav.Apps.Tools.psd1" -WarningAction SilentlyContinue | Out-N
Read more