Chart of Accounts

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Solution (Not Verified) This post has 0 verified solutions | 16 Replies | 4 Followers

65 Posts
721 Points
Joined: 2009-10-16
Last Online:
2014-4-15 8:38
Excerpt Navvy posted on 2010-1-5 8:17 | Locked

Hi

I am having problem on my chart of accounts, it does not show the total value  of my sub accounts. My structure is like this.

Raw Materials        End-Total                                 

     Raw Mats A        Posting                    5000

     Raw Mats B        Posting                    6000

     Raw Mats C        Posting                    5000

Raw Materials         Begin-Total

*Supposedly the end-total will appear as 16000, but on my chart of accounts there appears no value at all. Or is this kind of structure is possible for my chart of accounts. I understand based on the Cronus database the begin-total should be on top and end-total should be at the bottom. But this time I reversed their position.

Please help. Thank you!

All Replies

Male
1,294 Posts
28,076 Points
Joined: 2006-9-21
Last Online:
2014-7-7 19:24
Location: Delhi-India
Moderator
Dhan Raj Bansal replied on 2010-1-5 8:26 | Locked

Hi,

What is the value in "Totalling" field in the line having "Raw Materials        End-Total   " values?

You need to define the "Totalling" in a record having Account Type as "End-Total"

-Dhan Raj Bansal

Linkedin Profile: http://in.linkedin.com/in/dhanrajbansal

Male
554 Posts
17,070 Points
Joined: 2006-7-29
Last Online:
2014-7-24 12:48
Location: London, UK
IMRAN replied on 2010-1-5 8:27 | Locked

In the End - total row you must mention in the Totaling column the Gl Accounts you need to get added. Like Raw material 1..Raw material 3, but you would use the corresponding GL account , not the description.

Navision Developer NAV Certified.

Controlling complexity is the essence of computer programming.  ~Brian Kernighan

65 Posts
721 Points
Joined: 2009-10-16
Last Online:
2014-4-15 8:38
Excerpt Navvy replied on 2010-1-5 8:50 | Locked

Dhan Raj Bansal:

Hi,

What is the value in "Totalling" field in the line having "Raw Materials        End-Total   " values?

You need to define the "Totalling" in a record having Account Type as "End-Total"

Thanks for reply, yes given that I've already define the Totalling. It still doesnt show up. on the Totalling I take up Raw Materials Begin..Raw Materials End.

  

 

 

Male
1,294 Posts
28,076 Points
Joined: 2006-9-21
Last Online:
2014-7-7 19:24
Location: Delhi-India
Moderator
Dhan Raj Bansal replied on 2010-1-5 9:00 | Locked

Hi,

As suggested by IMRAN "Like Raw material 1..Raw material 3, but you would use the corresponding GL account , not the description. ", you should use the "No." field in Totalling, for example 100..200, which means it will take sum of all accounts in the range of 100 to 200.

What are  "No."  values in your case?

In case it doesn't help, then please post the scree shot of your Chart Of Accounts form.

-Dhan Raj Bansal

Linkedin Profile: http://in.linkedin.com/in/dhanrajbansal

65 Posts
721 Points
Joined: 2009-10-16
Last Online:
2014-4-15 8:38
Excerpt Navvy replied on 2010-1-5 9:11 | Locked

Hi,

I am unable to paste my screen shot. Where can i attached it?

 

Male
1,294 Posts
28,076 Points
Joined: 2006-9-21
Last Online:
2014-7-7 19:24
Location: Delhi-India
Moderator
Dhan Raj Bansal replied on 2010-1-5 9:24 | Locked

Hi,

On the top of text editor, Use the Green Color button (Insert Media, which is third on the left side of SCISSOR symbol) for attachments.

-Dhan Raj Bansal

Linkedin Profile: http://in.linkedin.com/in/dhanrajbansal

65 Posts
721 Points
Joined: 2009-10-16
Last Online:
2014-4-15 8:38
Excerpt Navvy replied on 2010-1-5 9:58 | Locked

1030.Doc1.doc

 

Hi

Kindly see attached.

Thank you

Male
554 Posts
17,070 Points
Joined: 2006-7-29
Last Online:
2014-7-24 12:48
Location: London, UK
Solution (Not Verified) IMRAN replied on 2010-1-5 12:52 | Locked
Suggested by Modris Ivans

6471.DUG.docx

Please check attached file.

Navision Developer NAV Certified.

Controlling complexity is the essence of computer programming.  ~Brian Kernighan

Male
2,061 Posts
44,306 Points
Joined: 2005-12-6
Last Online:
2014-7-26 13:47
Location: Rælingen (Akershus), Norway
Moderator
Solution (Not Verified) Modris Ivans replied on 2010-1-6 0:45 | Locked
Suggested by Modris Ivans

Imran already answered in his post, that is one solution with Begin Total - End Total.

If you want to put totaling line ABOVE the details, you may use Acc.Type=Total with appropriate account range in Totaling field.

12300 IT expenses Total 12310..12390

12310 Workstation PCs Posting
12320 Servers & net equipment Posting
12330 Software licenses Posting

12400 ... next Total 12410..12490

12410
12420

...
12490

...

Modris Ivans
MCP-Dynamics NAV Application

Please specify in your posts
1.product and DB version;
2.locale, or use International Forums

"Verify Solution" that helped you solve your problem

65 Posts
721 Points
Joined: 2009-10-16
Last Online:
2014-4-15 8:38
Excerpt Navvy replied on 2010-1-6 2:48 | Locked

Hi Modris,

Here's wat I did. Please see attached. Did I miss something else? Nothing reflects on the total.

Thank you3823.Doc2.doc

Male
2,061 Posts
44,306 Points
Joined: 2005-12-6
Last Online:
2014-7-26 13:47
Location: Rælingen (Akershus), Norway
Moderator
Modris Ivans replied on 2010-1-6 2:58 | Locked

In Totaling field you have set from-value "bigger" than to-value.

Look at what order accounts are sorted - in the same order, from smallest to largest you must set range in Totaling field.
You may check it, setting the same in F7-Filter for Account No field - if list is empty, you have done it wrong.

 

Modris Ivans
MCP-Dynamics NAV Application

Please specify in your posts
1.product and DB version;
2.locale, or use International Forums

"Verify Solution" that helped you solve your problem

65 Posts
721 Points
Joined: 2009-10-16
Last Online:
2014-4-15 8:38
Excerpt Navvy replied on 2010-1-6 3:19 | Locked

Hi Modris

You are correct. List is empty. What is your suggestion? This is how I want to set up my chart of accounts. Totals would be above the sub accounts. Would you be able to provide me a screenshot of your idea?

Thanks for usual assistance,

Male
95 Posts
1,999 Points
Joined: 2002-3-4
Last Online:
2013-5-22 15:37
Location: Singapore
Rajib Lochan Huzuri replied on 2010-1-6 12:05 | Locked

Put the Totals below the sub-account, and select Account Type End Total for the Totals Account, you will get the figures.

cheers

Rajib Lochan Huzuri

rlhuzuri@yahoo.com

65 Posts
721 Points
Joined: 2009-10-16
Last Online:
2014-4-15 8:38
Excerpt Navvy replied on 2010-1-7 3:19 | Locked

hello thanks Rajib

Yeah it was the first setup I made i get the figures. My question now, is it possible in NAV to put Totals or End-Totals at the top of the subaccounts? It is now what i am working out.

Page 1 of 2 (17 items) 1 2 Next > | Get this RSS feed | Bookmark and Share