Book Image

Microsoft Dynamics NAV 2016 Financial Management - Second Edition

By : Anju Bala, Cristina Nicolas Lorente, Laura Nicolàs Lorente
Book Image

Microsoft Dynamics NAV 2016 Financial Management - Second Edition

By: Anju Bala, Cristina Nicolas Lorente, Laura Nicolàs Lorente

Overview of this book

Microsoft Dynamics NAV is a global Enterprise Resource Planning (ERP) solution that provides small and mid-size businesses with greater control over their finances and a way to simplify their supply chain, manufacturing, and operations. Microsoft Dynamics NAV Financial Management explains all you need to know in order to successfully handle your daily financial management tasks. This book walks you through all the improvements in the latest release and shows you how to apply them in your workplace. You will learn about functionalities including sales and purchase processes, payments, bank account management, reporting taxes, budgets, cash flow, fixed assets, cost accounting, inventory valuation, workflows, sending and receiving electronic documents, and business intelligence. This book comprehensively covers all the financial management features inside the latest version of Dynamics NAV and follows a logical schema. By the time you’re finished this book you will have learned about budgets, cash flow management, currencies, intercompany postings, and accounting implications in areas such as jobs, services, warehousing, and manufacturing.
Table of Contents (15 chapters)
Microsoft Dynamics NAV 2016 Financial Management - Second Edition
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface
5
Foretelling - Budgeting and Cash Flow Management

Business Intelligence with Excel and PowerPivot


With Dynamics NAV, we can easily create our own report in Microsoft Excel using Business Intelligence (BI) tools. Let's create a report to analyze the total sales and profits, grouped per customer or per item:

  1. Open Excel. On the PowerPivot tab, click on the PowerPivot Window option.

  2. A new page opens. Navigate to From database | SQL database. Type the server and database name of your Dynamics NAV. Click on Next.

  3. Choose the Select in the table and views list to choose data to import option.

  4. From the table and views list, select the following tables:

    Table Name

    Comments

    CRONUS International Ltd_$Value Entry

    Click on Preview & Filters. Filter the Item Ledg. Entry Type field to only show lines with the value 1.

    CRONUS International Ltd_$Item

    CRONUS International Ltd_$Customer

  5. Click on Finish. Then click on Close. Close the PowerPivot Window to go back to the Excel sheet.

  6. Now that we have selected the data source, let's create a Pivot...