Can I run the income statement and balance sheet at anytime or it only can run after to do the Fiscal Year Closing ?
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.
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
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:
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:
How do you go about in Excluding the Closing entries in Jet Reports? Is it in the Date filter.
Business Applications communities