Skip to main content


Showing posts with the label Default Dimensions

Automatically adding dimensions from Shortcut Dimension from Excel Import in Microsoft Dynamics NAV / Business Central

Problem Statement : I have a requirement where the contents of the General Journals are to export to Excel and also can create new entries by importing the same Excel file as well. A major troublemaker is the dimensions as only Dimensions 1&2 ate stored in tables and can be validated easily but 3-8 are set at run-time through variables on the page. In this blog, I'll be attempting to resolve how to automatically apply dimensions from 3-8 using the code. Pre-requisites: VS Code AL Language Extension Functional knowledge of  Dimensions Microsoft Dynamics NAV /  Business Central Solution: 1. Understanding how dimensions work technically: Any dimensions that are inserted in an entry in the system are validated to be stored in the Dimension Set Entries table. Dimension Set Entries table of which Dimension Set ID is set on the Table. This Dimension Set Entry ID is stored on the entries to be used as a reference. For instance, if we want to Apply Dimensions

Adding Default / Mandatory Dimensions in Dynamics NAV / Business Central

Introduction: In this blog I aim to provide how to set Mandatory Dimensions on Items,Customers, Vendors and G/L Accounts and how to optimize this process using Configuration package. Pre-requisites : Microsoft Dynamics NAV. Microsoft Dynamics Business Central. Understanding of Dimensions in NAV / BC Theory: Automatic Dimensions can be added for the G/L Accounts, Customers, Vendor and Items. The Value Posting can be selected as per the below Table. Value Posting Explanation Blank No posting restriction. Transactions can be posted with any dimension value or without a dimension value. Code Mandatory Any dimension value for the given dimension can be added. If dimension value is blank then NAV / BC will throw an error Same Code Only a single dimension value defined in Default Dimension can be used while posting. No Code Dimensions must not be specified on the transactions. This also implies that you can add the Default Dimension, No Dimension, Mandatory Dimension a