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 NAV (Archived) / Multi chart of accounts
Microsoft Dynamics NAV (Archived)

Multi chart of accounts

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I am wondering whether it is possible to create a second chart of accounts in NAV 2013 attached to the main chart of accounts.

In the second chart of accounts, we should also be able to post entries and we should also be able to print out a trial balance.

Exemple (accounts are irrelevant and are just for the example)

in the first chart of accounts :

account 1000 Equipment = 520

account 2000 Inventory = 150

account 6000 Sales = 3000

etc....

in the second chart of accounts

account 1000 becomes account A (with same balance = 520)

account 2000 becomes account B

account 6000 becomes account C

etc...

Would it be possible to create such a structure and how ?

Thanks a lot in advance for your help

Regards

Bruno

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: Multi chart of accounts

    Hi Bruno

    As Jens say you can do this with use of schemes (Account Schedule) with no development.

    BR Per

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: Multi chart of accounts

    Hi Raokman,

    I guess you know the answer: Only with customization, or AddOn. When you have quite a few companies, don't you need to use consolidation for the consolidated view anyway?

    My take on this would be to use reporting schemes (Account Schedule) for the individual COAs. But, for the added security, you would need customization.

    There are some AddOns out there that have a "centralized company" for the consolidated view. Maybe these woud be worth a look.

    with best regards

    Jens

  • Community Member Profile Picture
    Community Member on at
    RE: Multi chart of accounts

    so this subject just came up here.

    we have management reporting, where managers have access to NAV's chart of accounts.

    we'd like to have one structure that presents results in a manner that only the accounts the managers have control over flow down to a bottom line.

     

    we'd like another structure that is 'correct' GAAP, with all EBITA expenses listed above the Operating Income line that can also be accessed by (a different set of) users.

     

    We have a double digit number of companies, so use of consolidation accounts worries me.

     

    Can we have two COA's, accessible by two different sets of users, that present account activity in two different sub-totalling and orders?  Can a user's COA be limited somehow (security level, RTC...)?

    Simple example:  rent is standardized by facility, with differences from 'standard' shown below the Operating line.  Managers see their standard rent impacting their results, but upper management sees not only the rent the managers see, but also the 'rent variance' account.  Upper management's view would move rent variance above the Operating Income line in their view so that they get an accurate view of results.

  • Community Member Profile Picture
    Community Member on at
    RE: Multi chart of accounts

    Your answer goes far beyond my expectations.

    I know enough now to go on.

    I am grateful to you. Thanks a lot again Dirk.

    Kind regards

    Bruno

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Multi chart of accounts

    Yep so then let's see what option we have:

    Option 1:

    very simple mapping:

    - you can use the consolidation debit/credit fields in the COA

    Option 2:

    simple mapping:

    -you can also use the IC COA an map this to the G/L accounts

    both mappings have only a 1:1 relation and could be useless if there are differences in the GAAP's

    Option 3:

    1 COA / delta accounts:

    - add additional accounts to your current COA

    - post 100% to the leading COA's and post only GAAP differences to the additional accounts

    - result COA report /better account schedules only on "major" accounts = leading GAAP

    - result COA report /better account schedules only on "major+deltas" accounts = secondary GAAP

    Option 4:

    1 COA / 100% postings:

    - create 3 types of accounts (e.g. I=IFRS/L=localGAAP/S=shared)

    - you have either 2 accounts like 1000I & 1000L or just 1 1000S

    - all shared should normally cover all the standard topics (orders, invoices....)

    - all G/L postings will be double postings on both I & L

    - result COA report /better account schedules on "I & S" accounts = IFRS GAAP

    - result COA report /better account schedules on "L & S" accounts = local GAAP

    for all of these options your finance people should consider which is the leading GAAP (hint from my side it's not the local GAAP ;-)

    You may also build functions to separate entries to different GAAP's where the user needs to define which one he wants to post, but this option is quite complex and as already mentioned it's far away from standard and might go down to the deepest NAV routines

    where you don't want to end up.

    Hope that helps

    Regards Dirk

  • Community Member Profile Picture
    Community Member on at
    RE: Multi chart of accounts

    Thanks a lot Dirk for quick and valuable feedback.

    When you say there are lot's of ways, can you please let me know (very briefly) what they are ?

    Just redirect me to the right guidelines (in the manual or other sources).

    Thanks a lot again for your time and help

    Kind regards

    Bruno

  • Community Member Profile Picture
    Community Member on at
    RE: Multi chart of accounts

    Well yes that's very common and there a lot's of ways to do that without additional coding. Just ask if you need help.

    Regards

    Dirk

  • Community Member Profile Picture
    Community Member on at
    RE: Multi chart of accounts

    Hi Dirk,

    Yes precisely it is to report from a GAAP into another GAAP.

    The idea is simply mapping an account in belgian GAAP into another account in US GAAP.

    I am sure this does not need customisation as it is a quiet common need for many companies...

    Thank you

    Regards

  • Community Member Profile Picture
    Community Member on at
    RE: Multi chart of accounts

    Hi,

    before coding it's maybe more interesting to find out what is your demand behind. So is there any accounting demand behind (e.g. different GAAP's)?

  • Community Member Profile Picture
    Community Member on at
    RE: Multi chart of accounts

    Thank you for this quick and clear answer.

    Though, it sounds a bit odd to me as I did it almost 20 years ago in a very simple accounting system.

    Would it be possible to use the dimension functionality ?

    Thanks again

    Best regards

    Bruno

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,436 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans