Requiring Dimensions on Your Chart of Accounts in Business Central
In this video, UG Expert Dave Wiser explains how to set up three types of Dimensions for Chart of Accounts in Business Central.
Key Takeaways
- Overview: Once you set up your chart of accounts and dimensions, those dimensions need to be assigned to the relevant accounts, particularly those requiring dimension values. This allows for a detailed analysis of income statement accounts. In this video, Dave focuses on setting up three dimensions: Area, Customer Group, and Department.
- Dimensions: When setting up dimensions for a Sales Account like 40110, as shown in the video, you can choose between single or multiple account dimensions. For a single account, you can specify dimensions such as area code, customer group, and department, and use the value posting setting to determine if these dimensions are mandatory or optional.
- Customer Group: For the Sales Account 40110, the Code mandatory setting requires an Area dimension and a Customer Group dimension, regardless of their values, and a specific department dimension value, which must be Sales. This ensures that all sales and Cost of Goods Sold accounts are correctly assigned to the sales department.
- Area: The Allowed values filter in Business Central lets you specify which dimension values are permitted for an account. For example, you can allow only certain area codes while disallowing others. This can be applied to multiple accounts at once, making it easier to manage dimensions across various accounts.
- Department: For all accounts requiring a Department dimension, you can set up dimensions on the Customer or Item card to avoid manually entering them for each transaction. When a sales order or invoice is created, the assigned dimensions will automatically be included, ensuring accurate financial analysis through the Chart of Account entries.
