Chart of Accounts

sandhya

Im facing the following problem while indenting the chart of accounts.

There are account nos. from 1 to 8. These are account numbers defined by the user. I want to group account no 3, 5, 7 in one group and 4, 6, 8 in one group. I dont want to change the account numbers for this purpose because the account numbers are predefined.

I still want to group these accounts and indent these accounts in the "chart of accounts".

Is there a way out to group and intend the chart of accounts with out changing the account numbers.

Sandhya

Note:
I thought that I can use pipes and commas in the totalling column and group these accounts. But if we do that, then we would not have account no. 3, 5, 7 coming one after another in one group.

eromein

Again... Could be I'm mistunderstanding the question, but here goes.


You could create a new kind of group on the Account card. Maybe you could even call it Sortinggroup. You'll then need a key Sortinggroup,No. and you're half way there.

But why just not make a 2 totals, one for group 3, 5 & 7 and one for 4, 6 & 8. Really... Who cares? As long as you have a total field which can be found near the accounts.

sandhya

Thanx for the suggestion.

Actually ive been trying to group the accounts for a long time the same way.

The following is the procedure ive followed:

i ve defined the accounts in the chart of accounts, fully.Then as a tail piece ive started consolidating them as per the groupings, with the total definitions. definitions. But this lists the accounts as a batch first, and then the the groupings follow.

I just wanted to know if there cud be a procedure which wud enable me define the groupings also while defining the chart of accounts without changing the account numbers.

The reason is, the accounts are sorted as per the account number automatically.

hansfousert

Hi Sandhya,

You could us Account schedules to present your Chart of Account in a different way. Thus you will be able to get the grouping you want without changing your CoA, and without any modifications of Navision.

The Account schedules allow you to present your G/L accounts in any order you want (the Insert accounts-function is very helpful). After that you may add lines for your own formulas.

Kind regards,

Hans Fousert
Trainer at Watermark Netherlands

Scott_Frappier

hansfousert said:
You could us Account schedules to present your Chart of Account in a different way.

We used this same approach with our COA. Adding unneccessary fields to group it at the form level is nice, but when the feature exists within Navision, why not utilize it instead?

Good luck!