Comparing Subaccounts Segments and Dimensions Transaction and Reporting Dynamics SL and Dynamics

Overview

The video, a 4-minute walkthrough published 2024-07-26, compares how Dynamics SL posts transactions using subaccount segments with how Business Central uses dimensions. In SL, the batch control report shows debit and credit accounts with their sub account segments.

It then shows the Business Central side: segments defined in SL migrate as dimensions, default dimensions are set on a vendor, and those values populate on purchase invoices. It finishes with previewing a posting before the journal is posted and analyzing results in the trial balance report by dimension.

Key points

• Segments defined in Dynamics SL migrate to Business Central as dimensions using the cloud migration tool.
• Default dimensions can be assigned on vendor records and populate automatically on transactions for that vendor.
• Setting the value posting to code mandatory enforces that a dimension value exists on transactions; this is optional based on business needs.
• On a purchase invoice, defaulted dimension values show in the fact box without manual entry.
• Posting preview in Business Central lets you check the accounts before posting a journal, similar to the distributions button in SL.
• The Trial Balance Dimension Report shows amounts posted to main accounts and can be filtered by dimensions such as reporting unit and company segment.

Features

AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

• report “Trial Balance Dimension Report” at 2:51

Not found in BC28-30: report “Trial Balance Dimension Report”.

Quotes

• 0:00 “We’re going to talk about segments when posting transactions in Dynamics SL and compare that to the experience in Dynamics 365 Business Central.”
• 1:09 “the segments we defined in SL will migrate to Business Central as dimensions, allowing us to continue to slice and categorize our transactions”
• 1:39 “If I wanted to lock the posting down further, I could set the value posting to code mandatory, which would indicate that a dimension”
• 2:16 “You can see in the fact box area the dimension value has automatically defaulted onto the transaction for me.”
• 2:28 “Before posting any journal in Business Central, I can preview the posting to ensure that the correct accounts are being posted to”
• 3:06 “The trial balance report in Business Central allows me to see amounts being posted to my main accounts, similar to Dynamics SL, as well”