Chart of Accounts

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

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

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,299 Posts
22,157 Points
Joined: 2006-9-21
Last Online:
2016-1-29 17:55
Location: Delhi-India
ModeratorDynamicsNAV

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

  • | Post Points: 6
Male
562 Posts
10,838 Points
Joined: 2006-7-29
Last Online:
2015-5-15 13:03
Location: London, UK
IMRAN replied on 2010-1-5 8:27 | Locked rated by 0 users

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

  • | Post Points: 5
65 Posts
366 Points
Joined: 2009-10-16
Last Online:
2014-4-15 8:38

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.

  

 

 

  • | Post Points: 6
Male
1,299 Posts
22,157 Points
Joined: 2006-9-21
Last Online:
2016-1-29 17:55
Location: Delhi-India
ModeratorDynamicsNAV

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

  • | Post Points: 6
65 Posts
366 Points
Joined: 2009-10-16
Last Online:
2014-4-15 8:38

Hi,

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

 

  • | Post Points: 6
Male
1,299 Posts
22,157 Points
Joined: 2006-9-21
Last Online:
2016-1-29 17:55
Location: Delhi-India
ModeratorDynamicsNAV

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

  • | Post Points: 6
65 Posts
366 Points
Joined: 2009-10-16
Last Online:
2014-4-15 8:38

1030.Doc1.doc

 

Hi

Kindly see attached.

Thank you

  • | Post Points: 6
Male
562 Posts
10,838 Points
Joined: 2006-7-29
Last Online:
2015-5-15 13:03
Location: London, UK
Solution (Not Verified) IMRAN replied on 2010-1-5 12:52 | Locked rated by 0 users
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

  • | Post Points: 6
Male
2,254 Posts
37,906 Points
Joined: 2005-12-6
Last Online:
2016-2-4 23:34
Location: Rælingen (Akershus), Norway
ModeratorDynamicsNAV
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

  • | Post Points: 6
65 Posts
366 Points
Joined: 2009-10-16
Last Online:
2014-4-15 8:38

Hi Modris,

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

Thank you3823.Doc2.doc

  • | Post Points: 6
Male
2,254 Posts
37,906 Points
Joined: 2005-12-6
Last Online:
2016-2-4 23:34
Location: Rælingen (Akershus), Norway
ModeratorDynamicsNAV

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

  • | Post Points: 6
65 Posts
366 Points
Joined: 2009-10-16
Last Online:
2014-4-15 8:38

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,

  • | Post Points: 7
Male
96 Posts
1,494 Points
Joined: 2002-3-4
Last Online:
2015-6-8 9:55
Location: Singapore

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

  • | Post Points: 6
65 Posts
366 Points
Joined: 2009-10-16
Last Online:
2014-4-15 8:38

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.

  • | Post Points: 6
Page 1 of 2 (17 items) 1 2 Next > | Get this RSS feed