Posts

Table Extensions in Business Central

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

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.

Compile Codeunit - 5301 "Outlook Synch. NAV Mgt"

Image
While compiling the object id 5301 "Outlook Synch. NAV Mgt", you may receive the below mentioned error - Error 1 -  --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- Could not load type 'Microsoft.Dynamics.NAV.OLSync.Common.XmlTextWriter.'Microsoft.Dynamics.Nav.OLSync.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35''. --------------------------- OK  --------------------------- Error 2 -  --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- You have specified an unknown variable. XmlTextWriter Define the variable under 'Global C/AL symbols'. --------------------------- OK    --------------------------- Resolution - Step 1) Step 2)  Try compiling the object on the system which you added Office outlook integration. Please feel free to get in touch in case you

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

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