How to generate the income statement and balance sheet in NAV 2009

Question Status

Verified
Jody Chan asked a question on 11 Feb 2014 2:35 AM

Can I run the income statement and balance sheet at anytime or it only can run after to do the Fiscal Year Closing ?

Reply
Suggested Answer
Rob Fontaine responded on 11 Feb 2014 10:30 AM

Hi Jody,

In general you should be able to run the financial statements at any point in time and the output will just depend on what tool you use to generate them (e.g., Chart of Accounts list, Account Schedules, custom NAV reports, Jet Reports) and the filters that are applied.  For prior year income statement you normally need to exclude closing entries (i.e., C12/31/xxxx) in order to get the correct net changes and balances.

Regards,

Rob

Reply
Jody Chan responded on 12 Feb 2014 2:35 AM

Hi Rob,

Thanks for your suggestion. I tried to generate from Account Schedules but nothing to shows on the output, also I can't found "custom NAV reports" and "Jet Reports" from NAV...could you please guide me more details if I generate from the tool "Chart of Accounts".

One more question, whether I need to set up the financial statement format by myself in NAV because the e-leaning shows how to create B/S row and column.

thank you so much

Jody

Reply
Verified Answer
Rob Fontaine responded on 13 Feb 2014 9:55 AM

Hi Jody,

If you use Account Schedules then you would need to design them yourself based on your specific chart of accounts and desired layout.  There are many excellent resources available for learning how to do this, including blogs posted by other Community members such as:

dynamicsnavfinancials.com/.../dynamicsnavfinancials-blog-celebrates-one-year-with-top-20-postings

Just try using the handy Search feature on this site and you will be amazed at the information available to you.  If you are working with a Microsoft Dynamics Partner then they should also be able to guide you in finding the appropriate training.

You will not find 'custom NAV reports" in the menu, I was just alluding to the fact that you or your Partner may have already created custom reports for generating financial statements.  It's not common to do so, but I'm not familiar with your specific situation.

Jet Reports is a family of products for producing reports in Excel and can pull data from various sources including NAV.  There is a free version called Jet Express for licensed NAV users, and you can also easily find their website by searching on the web, for your convenience here is a link:

http://jetreport.com/

Regards,

Rob

Reply
jlwaters11 responded on 17 May 2018 11:31 AM

How do you go about in Excluding the Closing entries in Jet Reports? Is it in the Date filter.

Reply
Verified Answer
Rob Fontaine responded on 13 Feb 2014 9:55 AM

Hi Jody,

If you use Account Schedules then you would need to design them yourself based on your specific chart of accounts and desired layout.  There are many excellent resources available for learning how to do this, including blogs posted by other Community members such as:

dynamicsnavfinancials.com/.../dynamicsnavfinancials-blog-celebrates-one-year-with-top-20-postings

Just try using the handy Search feature on this site and you will be amazed at the information available to you.  If you are working with a Microsoft Dynamics Partner then they should also be able to guide you in finding the appropriate training.

You will not find 'custom NAV reports" in the menu, I was just alluding to the fact that you or your Partner may have already created custom reports for generating financial statements.  It's not common to do so, but I'm not familiar with your specific situation.

Jet Reports is a family of products for producing reports in Excel and can pull data from various sources including NAV.  There is a free version called Jet Express for licensed NAV users, and you can also easily find their website by searching on the web, for your convenience here is a link:

http://jetreport.com/

Regards,

Rob

Reply
Suggested Answer
Rob Fontaine responded on 11 Feb 2014 10:30 AM

Hi Jody,

In general you should be able to run the financial statements at any point in time and the output will just depend on what tool you use to generate them (e.g., Chart of Accounts list, Account Schedules, custom NAV reports, Jet Reports) and the filters that are applied.  For prior year income statement you normally need to exclude closing entries (i.e., C12/31/xxxx) in order to get the correct net changes and balances.

Regards,

Rob

Reply