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

june

02jun2:00 pm2:30 pmBusiness Intelligence for Batch Manufacturers

16jun10:00 am10:30 amHow AP automation can speed up month-end close in D365 Finance

17jun11:00 am12:00 pmConfab Live with Stoneridge – Real Time Marketing Strategies for Success

23jun10:00 am10:30 amThe Modern Manufacturer: Cost Accounting in D365

30jun10:00 am10:30 amAP Automation Checklist for a 2022 Rebound

30jun2:00 pm2:30 pmAchieving Success: How Technology Is Helping Nonprofits Thrive

july

01jul11:00 am12:00 pmConfab Live with Stoneridge – Dataverse Virtual Entities

14jul12:00 pm12:30 pmBeyond Reporting - What Business Intelligence Can Do For Your Agribusiness

15jul11:00 am12:00 pmConfab Live with Stoneridge – Integration Strategies for End User Success

21jul10:00 am10:30 amThe Modern Manufacturer: Manufacturing Software in the Real World

21jul12:00 pm1:00 pmIs it Worth it to Upgrade to Dynamics 365 Finance and Supply Chain Management? - Everything AX Users Need to Consider

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