Chart of Accounts

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!

  • 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

  • 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

  • In reply to Dhan Raj Bansal:

    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.

      

     

     

  • In reply to Excerpt Navvy:

    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

  • In reply to Dhan Raj Bansal:

    Hi,

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

     

  • In reply to Excerpt Navvy:

    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

  • In reply to Dhan Raj Bansal:

     

    Hi

    Kindly see attached.

    Thank you

  • In reply to Excerpt Navvy:

    Please check attached file.


    Navision Developer NAV Certified.

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

  • In reply to IMRAN:

    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

  • In reply to Modris Ivans:

    Hi Modris,

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

    Thank you

  • In reply to Excerpt Navvy:

    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

  • In reply to Modris Ivans:

    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,

  • In reply to Excerpt Navvy:

    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

  • In reply to Rajib Lochan Huzuri:

    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.

  • In reply to Excerpt Navvy:

    Excerpt Navvy

    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,

     

    why not just read Modris's post above? what is the point of him explaining it to you again? His posts above are very clear.

     


    David Singleton - MVP Dynamics NAV Dynamics NAV Consultant since 1991 Available for Navision system performance design and tuning.

Related