Balancing Financial Dimension Field in AX 2012 R3

by | Updated August 15, 2016 | Dynamics AX, Financials

In the past, I worked on an implementation for a company that had a line of business slightly different than the rest of their organization. My initial instinct was to utilize the Business Unit financial dimension and split the company into two Business Units.  Through further discussions with the client I gathered the requirement that they needed to be able to produce a balance sheet for this line of business, so basically a balance sheet by financial dimension.  I wasn’t sure how to make this work until I discovered the Balancing financial dimension field in the Ledger form in AX.

General ledger>Setup>Ledger
Interunit Accounting

 

Here’s how it works:
1. Create interunit debit and interunit credit balance sheet main accounts:
General ledger>Common>Main accounts

Main Accounts

*When you enter the balancing financial dimension in the system and the entry does not balance at the level of the financial dimension values, additional entries are created automatically and are posted to the main accounts created above.

 

2. Setup accounts for automatic transactions for interunit accounting:
General ledger>Setup>Posting>Accounts for automatic transactions

Accounts for Automatic Transactions

*When you enter the balancing financial dimension in the system and the entry does not balance at the level of the financial dimension values, additional entries are created automatically and are posted to the main accounts created above.

3. Select the balancing financial dimension for interunit accounting:

General ledger>Setup>Ledger

Interunit Accounting
 
*You must select a financial dimension that is included in all account structures that are assigned to the ledger and the balancing financial dimension must not allow for blank spaces as dimension values.

Let’s see how this all works!

Scenario:
Company USMF has an Administrative department in which all salary expenses are allocated to two different Business Units.

Allocation %:
Business Unit 1 = 75%
Business Unit 2 = 25%

Account Structure 1 (Expenses):
Main Account + Business Unit + Department

Account Structure 2 (Balance Sheet):
Main Account + Business Unit

Salary Expenses of $100,000 are originally booked to the following main account and financial dimension combinations:
Debit – Salary Expense + Business Unit 1 + Admin Department               $100,000
Credit – Cash + Business Unit 1                                                                        $100,000

At the end of the month the Salary Expense needs to be allocated 75% to Business Unit 1 and 25% to Business Unit 2, which is illustrated in the following entry:
Debit – Salary Expense + Business Unit 2 + Admin Department               $25,000
Credit – Salary Expense + Business Unit 1 + Admin Department              $25,000

 

If we did not select the balancing financial dimension of Business Unit in the Ledger form (Step 3. Above) your balance sheet would not balance for the financial dimension of Business Unit in this scenario. Luckily we did, so AX generates the following entry when you post the allocation entry above to ensure that the balancing financial dimension of Business Unit is balanced.

Debit – Interunit Receivable + Business Unit 1 + Admin Department               $25,000
Credit – Interunit Payable + Business Unit 2 + Admin Department                                 $25,000
——————————————————————————————————————————-
Balance Sheet Business Unit 1:
Assets
Cash                                                                      ($100,000)
Interunit Receivable                                           $25,000
Total Assets                                                   ($75,000)
Liabilities
Owner’s Equity
Retained Earnings                                              ($75,000)
Total Liabilities + Owner’s Equity        ($75,000)
——————————————————————————————————————————-
Balance Sheet Business Unit 2:
Assets
Total Assets                                                   ($0)
Liabilities
Interunit – Payable                                            $25,000
Owner’s Equity
Retained Earnings                                             ($25,000)

————
Total Liabilities + Owner’s Equity         ($0)

 

Related Posts

  • In AX 2012 you can set the value for a specific dimension using code similar to what is below. DimensionAttributeValue         dimAttrValue; DimensionAttribute              dimAttr; DimensionAttributeValueSetStorage davss; RecId                defaultDimension; davss = DimensionAttributeValueSetStorage::find(this.DefaultDimension); dimAttr…

  • I have been asked a few times to retrieve the description along with the value of a particular dimension in Dynamics AX.  For example, in AX go to a sales…

  • Some clients working with Microsoft Dynamics AX might have an environment with multiple AOS's. For example AX-AOS1, AX-AOS2, AX-AOS3, AX-AOS4, AX-AOS5 are all in an AX system cluster called "Load…

5 Comments

  1. tim parashkevov

    Hi Andrew,

    Thank you for the detailed explanation. I do not have an accounting background. I was wondering how would the balance sheets look if we did not have a balancing financial dimension?

    Thank you!

    Best,
    Tim

  2. Brandon Carmichael

    Hello Tim,

    First of all, I would like to apologize that it took as long as it did to respond to your comment. I wanted to make sure I was correct. Like you, I do not have an accounting background (I’m a developer).

    Back to your comment, the balance sheets would look the same except there wouldn’t be an Interunit Receivable or Interunit Payable so:

    Balance Sheet Business Unit 1:
    Assets
    Cash ($100,000)
    Interunit Receivable $25,000
    Total Assets ($75,000)

    Total Assets Without Balancing Fin Dim ($100,000)
    Liabilities
    Owner’s Equity
    Retained Earnings ($75,000)
    Total Liabilities + Owner’s Equity ($75,000)

    ***Total Assets need to equal Total Liabilities + Owner’s Equity, which you can see they wouldn’t without the Interunit Receivable
    Balance Sheet Business Unit 2:
    Assets
    Total Assets ($0)
    Liabilities
    Interunit – Payable $25,000
    Owner’s Equity
    Retained Earnings ($25,000)

    Total Liabilities + Owner’s Equity ($0)
    Total Liabilites + Owner’s Equity without Balancing Fin Dim ($25,000)
    ***Total Assets need to equal Total Liabilities + Owner’s Equity, which you can see they wouldn’t without the Interunit Payable

    Hope this helps,
    Brandon

  3. Advent7

    Thanks for this article Andrew. I’ve been ignoring this aspect of AX for a while now (‘cos I didn’t really understand it !! ) … But this article has now crystalized the purpose of the balancing dimension.

  4. Firzen

    Thanks for this article. This is really a great post!!!!

  5. Mohamed

    Thank you for you clarification .

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

october

07oct12:00 pm1:00 pmThe Three Paths to Business Central from Dynamics GP

08oct11:00 am12:00 pmConfab with Stoneridge - Livestream - The Vision and Strategy of Microsoft Business Systems

14oct10:00 am10:30 amThe Modern Manufacturer - Managing Complex Cost Modeling

14oct12:00 pm12:30 pmGenerating Custom Inspection or Process Forms

19octAll Day22Stoneridge Connect Fall 2020

22oct11:00 am12:00 pmConfab with Stoneridge - Livestream - Stoneridge Connect Recap

28oct10:00 am10:30 amThe Modern Manufacturer - Engineering Change Management: Introduction of NEW Functionality for Manufacturers Using Dynamics 365

november

11nov10:00 am10:30 amThe Modern Manufacturer - Tears and Trauma of MRP

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X