Balancing Financial Dimension Field in AX 2012 R3

By Andrew Passanante | June 3, 2015

Balancing financial dimension field in ax 2012 r3

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

Recommended Reading:

5.27.22 Dynamics GP

How to Run Drop Ship Sales in Dynamics GP

Need to Invoice the Customer before you get the invoice from the vendor? This The freight forwarder has contacted you […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Protecting G/L Accounts From Being Deleted

There are a lot of exciting New Features in Dynamics 365 Business Central 2022 Wave 1 Release to get excited […]

Read the Article
5.25.22 Financials

Rounding Numbers in Power Automate

  If you’ve ever tried to round numbers in Power Automate, you have probably already run into the issue there […]

Read the Article

Manage U.S. Use Tax on Purchase Orders in Dynamics 365 Finance and Operations

  Managing sales tax requirements on your business purchase can be complicated, but Dynamics 365 Finance and Operations can help […]

Read the Article
5.19.22 Dynamics CRM

How to Write a Great Support Ticket in the Stoneridge Support Portal

Submitting a support ticket through the Stoneridge Support Portal is a quick and effective way to get assistance for any […]

Read the Article

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X