You’re offline. This is a read only version of the page.
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
Hi Bruno
As Jens say you can do this with use of schemes (Account Schedule) with no development.
BR Per
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
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.
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
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
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
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
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
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)?
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
#1
Sohail Ahmed
2
#1
mmv
2
#1
Amol Salvi
2
Share
Report
All responses (
Answers (
