Book Image

Microsoft Dynamics NAV Financial Management

By : Cristina Nicolàs Lorente, Laura Nicolàs Lorente
Book Image

Microsoft Dynamics NAV Financial Management

By: Cristina Nicolàs Lorente, Laura Nicolàs Lorente

Overview of this book

<p>Microsoft Dynamics NAV is an Enterprise Resource Planning (ERP) application used in all kinds of organizations around the world. An ERP helps to integrate internal and external management information across an entire organization. It provides a great variety of functionalities in different areas such as accounting, sales and purchases processing, logistics, and manufacturing.</p> <p>Microsoft Dynamics NAV Financial Management explains all you need to know to successfully handle your daily financial management tasks. You will learn about functionalities such as the sales and purchase processes, payments, bank account management, reporting taxes, budgets, cash flow, fixed assets, inventory valuation, and business intelligence.</p> <p>This book comprehensively walks you through all the financial management features inside Dynamics NAV following a logical schema. This book is focused on what’s most important to you, the functionalities of Dynamics NAV, and it covers all setup explanations in a single chapter.</p> <p>You will gain in-depth knowledge about functionalities, including sales and purchase processes, pricing, document approval, payments, bank management, and accounting transactions. You will also learn about VAT reporting, fixed assets, inventory valuation, annual account closing, consolidation, reporting, and business intelligence.</p> <p>By the end of this book, you will have also learned about budgets, cash flow management, currencies, intercompany postings, and accounting implications on areas such as jobs, services, warehousing, and manufacturing.</p>
Table of Contents (15 chapters)
Microsoft Dynamics NAV Financial Management
Credits
About the Authors
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
5
Foretelling – Budgeting and Cash Flow Management
Index

Preface

Dynamics NAV is an Enterprise Resource Planning (ERP) system targeted at small and medium-sized companies. An ERP is a system, a software, which integrates the internal and external management information across an entire organization. If you search the net you will find plenty of documentation, webs, forums, and all kinds of information covering Dynamics NAV from many technical points of view. But you will find nothing or little covering Dynamics NAV from a functional point of view, meant for end users. Thousands of users from all around the world that use Dynamics NAV as their main tool for daily work complain that they cannot find information about what they need from the system. And they are right.

This book is written for them, after the experience of giving training to many end users in each implementation we have worked on. We have found out that most users do not care about system configuration; they just want to know how the system works. They contact Dynamics NAV consultants to set up when needed. But in the little end user documentation found, each topic starts with a full setup introduction that confuses readers and may even discourage them from reading further.

In this book we have changed the established structure of official manuals. Instead we have used a logical structure that makes it easy to read and very easy to understand. This is how we teach Dynamics NAV in our training sessions and this is how people tell us they have learned and understood the application.

Don't think this book is only meant for financers and accountants. This book is also meant for Dynamics NAV consultants and developers. You need full Dynamics NAV functional knowledge to become an expert, and this book can help you with it.

You will never stop learning about new features and functionalities. The idea behind the book is that you learn enough to be able to keep learning on your own. Every single field in every single table can hide a mini functionality that is there to help you with your work.

What this book covers

Chapter 1, The Sales and Purchase Process, explains how these two essential business areas in all companies can be handled in Dynamics NAV. It also shows how Dynamics NAV translates all the transactions to accountancy language on the fly. In this chapter, you will learn how to create new customers and vendors, to set up your pricing policies, and the documents used when selling and purchasing as well as their workflows.

Chapter 2, Managing Payments and Banks, discusses that after invoicing companies have to charge for the items delivered and have to pay for the services received. In this chapter you will learn how to manage different payment terms and methods, and to analyze customer and vendor extracts and their outstanding balances.

To check that the statements your bank provides you agree with the payments and charges you have posted into the system, you can use the Bank reconciliation feature that is explained in the chapter.

Chapter 3, Accounting Processes, explains how to handle accounting tasks such as reporting taxes, fixed asset management, inventory valuation, posting payroll accrual entries, provisions,and other accounting transactions, annual accounting close, and consolidation with other companies.

Chapter 4, Reporting and Business Intelligence, discusses the tools that can help you with analysis, both inside and outside the application. The previous chapters teach readers about the data entry and data process tasks. Once the data is introduced into the system, you should be able to analyze it.

In this chapter we explain how dimensions can be used to tag entries so that you can group entries with similar characteristics. This will allow you to report on the data in a way that is meaningful to the company.

Dynamics NAV has a bunch of reports that can be used out of the box. Account Schedules and Analysis Views are features that allow users to create their own reports. You can also use the Business Intelligence tools included in Excel by linking it with your Dynamics NAV database.

Chapter 5, Foretelling – Budgeting and Cash Flow Management, discusses that accounting rules are based on faits accompli, but companies need to anticipate and predict events. In Dynamics NAV budgets are used to plan costs, revenues, and resources and can be used to set up goals and measure performance. The cash flow management functionality is meant to help companies to predict future cash needs.

Chapter 6, Financial Management Setup, explains that in Dynamics NAV everything leads to accounting, but most of the operations inside Financial Management can be carried out with little accountancy knowledge. You need to set up the system so that it can translate transactions to accountancy language according to your company rules.

In this chapter we cover the general setup, the dimensions setup, the creation and configuration of posting groups, and the definition of number series.

Chapter 7, Other Financial Functionalities, explains briefly about currencies, intercompany postings, XBRL, and accounting implications on areas such as Jobs, Services, Warehouse, or Manufacturing. In the previous chapters we have covered the most important aspects of financial management with Dynamics NAV. But the application has a lot more possibilities.

What you need for this book

To successfully follow the examples in this book you will need an installation of Microsoft Dynamics NAV 2013.

Who this book is for

This book is meant for financers and accountants that are using or going to use Dynamics NAV as their ERP and financial management system.

It is also meant for Dynamics NAV consultants and project managers who will help organizations to use the system for their daily work.

The book will also be very helpful to Dynamics NAV developers who want to understand how the standard application is used in organizations, to help them develop better features, and more integration with the existing ones.

Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "click on the View icon found on the Home tab of the ribbon."

Note

Warnings or important notes appear in a box like this.

Tip

Tips and tricks appear like this.

Reader feedback

Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of.

To send us general feedback, simply send an e-mail to , and mention the book title via the subject of your message. If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide on www.packtpub.com/authors.

Customer support

Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.

Errata

Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books—maybe a mistake in the text or the code—we would be grateful if you would report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting http://www.packtpub.com/submit-errata, selecting your book, clicking on the errata submission form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded on our website, or added to any list of existing errata, under the Errata section of that title. Any existing errata can be viewed by selecting your title from http://www.packtpub.com/support.

Piracy

Piracy of copyright material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works, in any form, on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.

Please contact us at with a link to the suspected pirated material.

We appreciate your help in protecting our authors, and our ability to bring you valuable content.

Questions

You can contact us at if you are having a problem with any aspect of the book, and we will do our best to address it.