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

Using account schedules


The account schedule functionality is part of the Analysis & Reporting section of the Financial Management area. It is meant to create customized financial reports based on general ledger information, budget information, or on the analysis views information. Account schedules can group data from various accounts and perform calculations that are not possible directly on the chart of accounts.

When defining account schedules, the information that will be displayed on both rows and columns can be defined.

Just to see how it works, we will create a simple account schedule that will compare budgeted amounts versus real amounts. To do so, we perform the following steps:

  1. Navigate to Departments | Financial Management | Reports and Analysis and choose Account Schedules.

  2. Click on New to create a new account schedule. For the new account schedule, select EXAMPLE as the Name, Comparing budget versus reality as the Description, and ACT/BUD as the Default Column Layout.

  3. Click...