Skip to main content
Microsoft Dynamics AX forum
Unanswered

All dimensions on all accounts in one Account structure

editSubscribe (0) ShareShare
ReportReport
Posted on by 3,415 Super User

Client wants to use all dimensions on all accounts, for uniformity in the trial balance and on reports.  What are the pitfalls of doing this?  Thanks

Attachments
  • Sten Baumgarten Profile Picture
    Sten Baumgarten 8 on at
    RE: All dimensions on all accounts in one Account structure

    Hi

    Pitfalls are that users have to decide if values must be selected and spend time moving through the accountstring.

    Now that Power BI can filter on financial dimension values and Financial report as always can I will use different account structures and advanced rules to make it easier for users to create journals.

    Br Sten

  • Khaled Alloud Profile Picture
    Khaled Alloud 3,656 on at
    RE: All dimensions on all accounts in one Account structure

    Hello,

    From my experience you can do but Users need to be quite smart on how to use them, therefore advanced rule will help you control data accuracy as Andre said.

    If the Question is answered can you please verify it to update its status in the community?

    Best,

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,415 Super User on at
    RE: All dimensions on all accounts in one Account structure

    Most of their transaction are integrated from other systems, so they can supply the zeroes in the source files.  For manual transactions, I'm envisioning allowing blanks, so the ledger overrides wouldn't be needed because as you note, that's hard to manage across that many LE's.  Thanks

  • Andre Arnaud de Calavon Profile Picture
    Andre Arnaud de Cal... 283,126 Super User on at
    RE: All dimensions on all accounts in one Account structure

    Hi Frank,

    Are they used to fill 0 values or would it also be an option to have blank values for balance accounts? If they would love to stick to zeros, the ledger overrides needs to be used to default/fix the zeros. So for automatic accounts and balance accounts a default or fixed value can be handled, but is cumbersome for 150 LE's. Also when adding a new ledger account it should be overridden for all LE's.

    I don't expect issues with IC transactions from journals. IC project invoices could have some quirks.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,415 Super User on at
    RE: All dimensions on all accounts in one Account structure

    Yes, you're right Ludwig.  It's a case of the client being used to a static vs. dynamic account string in their old system.  Trying to find additional reasons why they should not attempt to make their new system like the old one :)  Thanks for the response.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: All dimensions on all accounts in one Account structure

    Hi Frank Hamelly,

    Just an additional question/remark in regards to the use of the financial dimensions with the BS accounts. The example that you provided above does not seem add value. Just adding ...0-0-0-0 is something pretty useless unless you need it for creating separate Balance sheet reports . Let's say a Balance sheet by business unit, etc.

    Best regards,

    Ludwig

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,415 Super User on at
    RE: All dimensions on all accounts in one Account structure

    Thanks Andre for the response.  We're looking at main account + four dimensions.  Another couple issues I could think of:

    1. Accounts for automatic transactions - have to use Advanced rules or Legal entity overrides and this client has ~150 legal entities to maintain

    2. Is there any impact on creation of intercompany transactions?

    3. Definitely will use all 4 dimensions on P&L accounts but they would like to use all four for balance sheet as well, i.e., 12000-0-0-0-0 would be A/R account, 20000-0-0-0-0 A/P, 10001-0-0-0-0 cash, etc.

    Thanks, Frank

  • Andre Arnaud de Calavon Profile Picture
    Andre Arnaud de Cal... 283,126 Super User on at
    RE: All dimensions on all accounts in one Account structure

    Hi Frank,

    Some thoughts:

    - User can make wrong selections and get confused by thinking which dimensions and values needs to be selected per ledger account. How many dimensions are we talking about here?

    - For limiting valid dimension values, advanced rules needs to be created and maintained!

    - Within financial reports you can create separate columns for each dimension and have a best practice setup where multiple account structures are used.

    - What setting to use when creating opening balances? With or without dimensions for balance accounts?

    - When there are different dimension values used for an invoice and payment, the settlement will create additional ledger transactions to clear it.

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,126 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,646 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans