Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

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

Posted on by 50

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

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to generate the income statement and balance sheet in NAV 2009

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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to generate the income statement and balance sheet in NAV 2009

    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

  • Jody Chan Profile Picture
    Jody Chan 50 on at
    RE: How to generate the income statement and balance sheet in NAV 2009

    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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to generate the income statement and balance sheet in NAV 2009

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans