Skip to main content

Imporovements in Financial Reporting in Microsoft Dynamics Nav from 2017..


Microsoft Dynamics Nav , Financial Reporting Improvements 
 

Financial reports in Microsoft Dynamics NAV 2017

We hope you already signed up for the preview and are getting to know the capabilities of Microsoft Dynamics NAV 2017. For example, did you know the most commonly used financial statements are available upon your first login to Microsoft Dynamics NAV 2017?

It really is easy: sign in to your Microsoft Dynamics NAV 2017 account and then follow these few steps to run your financial statements in a matter of moments.

1.  From Home, select the actions tab in the upper left corner, and then choose Financial Statements.

2.  Choose the financial statement you wish to view.  You will have a choice of the 4 most commonly used statements; Balance Sheet, Income Statement, Statement of Cash Flows, and Statement of Retained Earnings.  We have chosen the balance sheet for our example.











3.  Specify date, or date range, you wish to report on and then select Preview.

 And just like that, you are now viewing financials statements in Microsoft Dynamics NAV 2017!


Microsoft Dynamics NAV 2017 also gives you full control over your chart of accounts and how you want your accounts to appear on the financial statements.  By using the G/L Account Categories feature, you are able create new categories and map accounts to those categories, providing personalization the structure of your financial statements.  Here is an example of how you can provide more details on your financial statements for your cash accounts.

4.  From Home, select the search icon in the upper right corner of the page.


5.  Once the search window appears, enter Account Categories. The search results listed will be reduced as you type. Select G/L Account Categories from the searc results.



6.  Select the row on the page that has a description of Cash, select the Edit list action from the ribbon, and select the New acton from the ribbon. A new record will appear in the list. 


7.  Enter in a description of Checking Account and tab to the G/L Accounts in Category column. In this field, select the ...icon. A listing of your chart of account will appear. Select the G/L Account number 10100 and select OK at the bottom right of the page. 


8.  Tab to the Additional Report Definition column and from the drop down list, select Cash Accounts. This lets our system know which financial statements this category should be used with. Once the new category is defined, select the Indent Action from the ribbon. 

9.  Let's create 2 additional categories for cash. Select New from the ribbon and add additional categories, one for Savings Account and the other for Petty Cash, map the categories to G/L Account 10200 and 10300 respectively, assign them to the Cash Accounts under Additional Report Definition and Indent the new categories. 


10.  Select the Generate Account Schedule action from the ribbon. This will regenerate the layout of the financial statements to include the newly added categories. 


11. Follow steps 1-3 to render the Balance Sheet. Notice the new breakdown of your cash accounts and the new subtotal that was automatically created. 


This is just one of many examples of how Microsoft Dynamics NAV 2017 makes you more productive. Maybe it's time to think about upgrading

Comments

Popular posts from this blog

Quick Fix Visual Studio displaying NAV Report Layout as XML

I got this issue with Visual Studio 2015 Enterprise Edition.  Every time I open a Dynamics NAV report layout in Visual Studio, RDLC is rendered as XML file instead of visual layout with all the fields and tool boxes.  How the report layout looks:  FIX : In order to fix the issue you need to install  "Microsoft SQL Server Data Tools" .  To install "Microsoft SQL Server Data Tools" you need to go to  Control Panel   ->  Programs and Features  - >  Microsoft Visual Studio <Edition>  -> Change Or you can re run the installation setup.  From the features list, enable "Microsoft SQL Server Data Tools" option and proceed.  Once the installation is completed you are good to go. This time report layout will open in correct design layout.  Hope this helps you to resolve the issue. happy designing.  Please provide your feedback with a comment.  Thank you and Regards, +256775120005 Kairo Okello Dan ERP Solutions Consultant

The Difference Between Microsoft Dynamics NAV and AX

The Difference Between Microsoft Dynamics NAV and AX Microsoft Dynamics offers a variety of ERP solutions. You might say there is a solution for every purpose and every industry. Two of the offerings,  Dynamics NAV  and  Dynamics AX (now part of  Dynamics 365 ) share some of the same features so you might wonder: ‘what are the differences and which is right for my organization?’ Both ERP solutions are highly customizable, available in and adaptable to many languages and currencies used around the world. The two solutions can also be employed in a central location or across diverse satellite locations and are designed to grow as a business grows. Their industry-specific functionality can assure compliance with local and regional requirements. In short, both solutions could rightly be described as comprehensive and well equipped to manage complex requirements of supply chain and inventory. So, what is the difference? Is one better than the other for your particular organiz

How to install a Microsoft Dynamics NAV cumulative update

How to install a Microsoft Dynamics NAV 2018 cumulative update Introduction This article describes how to install a cumulative update for Microsoft Dynamics NAV 2018. You have to recompile all objects after you install a cumulative update. A cumulative update is a cumulative set of files that includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2018. A cumulative update includes files that are separated into the following folders: APPLICATION DVD See  Upgrading the Data to Microsoft Dynamics NAV 2018  for details. How to install the cumulative update files APPLICATION The APPLICATION folder includes the following files: AccumulatedChangeLog.<Locale>.<Build No.>.txt Changelog.<Locale>.<Build No.>.txt CUObjects.<Locale>.<Build No.>.fob Objects.<Locale>.Objects.<Locale>.<Build No.>.txt To install the application files, follow these