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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Account Structure Main account Criteria Problem

(0) ShareShare
ReportReport
Posted on by

Hi Gurus,

I Create my chart of account and main account by following structure(Hierarchy Setup, China main account hierarchy).

Account Number Formats: XXXXXXXXX

Level 1, Length(4)

Level 2, Length(2)

Level 3, Length(3)

Balance Sheet Accounts Sample: Table 1

No. Account Number Account Type Name
1 1000 Total Bank Deposit
2 100001 Total Bank Of China
3 100001001 Asset Chinese Yuan Account in Bank of China
4 100001002 Asset US Dollar Account in Bank of China
N-2 4000 Total xxxx
N-1 400001 Total xxx
N 400001001 Liability xxx

Profit and Loss Accounts Samples: Table 2

No. Account Number Account Type Name
1 6000 Total xxx
2 600001 Total xxxx
3 600001001 P&L xxxxxx
4 600001002 P&L xxxxxxxxxxxxxxxxxx
N-2 7000 Total xxxx
N-1 700001 Total xxx
N 700001001 P&L xxx

Now i want to create two account structure for them.

1. Balance Sheet Account Structure for Table 1 (Main Account 1000 - 4000, 100000 - 400000, 100000000 - 400000000)

2. P&L Account Structure for table 2( Main Account 6000 - 7000, 600000 - 700000, 600000000 - 700000000)

if i create the range 1000 - 4000 and 100000 - 400000 , the filter 100000 - 400000 will be remove automatically, but if i create two main account filter node with one 1000 - 4000 and another with 100000 - 400000 , the system will note : " the node with criteria 100000 - 400000 overlaps the node 1000 - 4000.

i'm confused why the criteria 100000 - 400000 can overlap 1000 - 4000 ?

Thanks.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    300,915 Super User 2025 Season 2 on at

    Hi Jianrui,

    The sorting of the main accounts and thus the ranges is alphabetically. So when you enter 1000-4000, also 100000 is included.

    You can try to use the criteria 1000-400000.

  • lally Profile Picture
    8 on at

    Hi ,

    AX 2012 R3

    Assume that client has two different companies and one Company A has the COA starts 1000( ####) and another companyB  COA starts with 10000(#####) . Company A account structure already attched  to the Ledger form , Now when i try to create the account structure for Company B and try activate i am also getting the same error as overlap .

    I am also facing the issue , but did not understand the root cause.

    Any pioneer can share experience to resolve the issue ?

  • André Arnaud de Calavon Profile Picture
    300,915 Super User 2025 Season 2 on at

    Hi Lally,

    Please provide some more detailed information. Did you use the same account structures for company B? Did you create a new one and added it to the ledger form in company A?

  • lally Profile Picture
    8 on at

    [quote user="André Arnaud de Calavon"]Did you use the same account structures for company B?

    [/quote]

    No , Two different account strucutres.

    [quote user="André Arnaud de Calavon"] Did you create a new one and added it to the ledger form in company A?[/quote]

    No , Both companies has the different accounts format like Com A  ( Account mask :  ####) and Com B ( Account mask :  #####) .

    I did not understand why the such error throws even for the different account masks and different account structures .

    Any light from your end ?

  • André Arnaud de Calavon Profile Picture
    300,915 Super User 2025 Season 2 on at

    If you really have different account structures and you did not activate the structures for company A and B in the same Ledger, you should not get this error.

    How many account structures did you setup? Please provide the information per legal entity. If you have intended to have multiple account structures for company B, then please check if there might be an overlap in main accounts.

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…

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