web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Cost Center in the exi...
Microsoft Dynamics AX (Archived)
Answered

Cost Center in the existing legal entity

(0) ShareShare
ReportReport
Posted on by imran ul haq 4,017

Hi All

From 1 of January 2016, one of the legal entity is going to start another branch, for that I need to create the new Financial Dimension “Business Unit” and from 1 January 2016 all the transactions should be done as per the business unit dimension.

 To achieve the above practice for this legal entity only I did the following (in test server) and stuck at one point:

 

  1. Create the Financial Dimension
  2. Create the Financial Dimension Sets
  3. Create the new Business Unit in the Organization àBusiness Unit
  4. Create the new account structure (Duplicate the existing) and add this Business Unit as the segment.
  5. Remove the old account structure from the ledger form and add the newly created account structure where Business unit dimension is mandatory.

 

Till here it is fine for the new transactions that will start from 1 Jan 2016, but at the time of closing 2015 the opening balances should be transferred to the one business unit (old Business unit) with the business unit dimension so that when we generate the trail balance from 1 Jan 2016 onward based on the business unit I can see the all balances (opening) in the old unit.

 

So, I am stuck at last in closing, could you please suggest 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 49,438 User Group Leader on at

    Step#1: Clear old Trial Balance

    • Export your Trail Balance.

    • Make the sign of amounts as reverse

    • Let’s suppose you have an account 11011 which has balance 10,000 as Debit. Making it reverse mean do 10,000 as credit.

    • Now for all account export Trail Balance, make amount reverse. And post a GL Journal.

    • This step will make your Trail Balance zero.

       

      Step#2: Spilt your Old Trail Balance with Business Unit and Post it

    • Take Trail Balance which was old without Business Unit, spilt that trial balance into multiple lines.

    • Let’s suppose you was having account 11011 and its amount was 10,000. Now you might be looking to split it into 5 Business Units. SO create 5 lines for this.

    • Split Trail Balance as per Business Units.

    • Post a new General Journal

       

      Notes:

    • While doing step 1: keep same voucher number for all lines of journal. This is because of reason that Journal should be showing sum of amounts as zero. As you will not put any account on offset side, so making journal zero as sum of all journal with one voucher number is important.

    • While doing step#2, make sure that sum of journal lines should be same as of Old trail balance

    • Don’t forget to make Business Unit as non-mandatory while doing step#1. Before doing step#2, you can make Business unit mandatory again.

       

  • imran ul haq Profile Picture
    imran ul haq 4,017 on at

    Thanks Sohaib for your reply.

    Regarding the above solution i want to ask something:

    1. This should be performed after the closing and transferring the balances to the new year or this i have to perform after the regular monthly closing, and pass the journal on 31/12/2015 for making the trail balance zero and then activate the financial dimension and enter the trail balance and transfer the balance to the new fiscal year 2016.

    2. How about the modular reports as we are passing the GL entry only so it will not affect the modules.

    Please advise, thanks in advance

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,438 User Group Leader on at

    1) you can perform it anytime, up to you. before or after Year end close or month end close.

    But note down that after this process, from next moment BusinessUnit dimension will be mandatory for all data entry (which will be new)

    It will be much better if you do it at month end or year end and inform users that from next day dimension will be mandatory.

    2) this change will not reflect back to SubLedger level i.e. to modules. it will effect your GL balances only.

    for new entries which will be done after modifying COA structure (i.e adding BU dimension as mandatory) you will get dimensions everywhere

    if you want to see changes of historical data i.e. addition of BU with each entry, that means run SysDatabseTransDelete and delete everything and redo all entries.

  • imran ul haq Profile Picture
    imran ul haq 4,017 on at

    Thanks Sohaib for your support.

  • imran ul haq Profile Picture
    imran ul haq 4,017 on at

    Hi All

    Is there a way that i will update the financial dimension (old Business unit dimension) on all posted transaction by some job so that at modular level also we will be able to see the segregated reports. May be it will little easy as on all transaction i have to update just one dimension id.

    please suggest

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Liquid error: parsing "/globalsearch/?q=%2F.++6" - Nested quantifier +.