O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Dynamics NAV Financial Management

Book Description

Delve deep into the world of financial management with Microsoft Dynamics NAV

  • Explore the features inside the sales and purchases areas as well as functionalities including payments, budgets, cash flow, fixed assets, and business intelligence
  • Discover how the different aspects of Dynamics NAV are related to financial management
  • Learn how to use reporting tools that will help you to make the right decisions at the right time
  • This book fully prepares you to successfully use Dynamics NAV as your key tool for financial management

In Detail

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.

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.

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.

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.

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.

Table of Contents

  1. Microsoft Dynamics NAV Financial Management
    1. Table of Contents
    2. Microsoft Dynamics NAV Financial Management
    3. Credits
    4. About the Authors
    5. Acknowledgments
    6. About the Reviewers
    7. www.PacktPub.com
      1. Support files, eBooks, discount offers and more
        1. Why Subscribe?
        2. Free Access for Packt account holders
        3. Instant Updates on New Packt Books
    8. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Errata
        2. Piracy
        3. Questions
    9. 1. The Sales and Purchase Process
      1. Introducing Microsoft Dynamics NAV
        1. Importance of Financial Management
        2. Posted data cannot be modified (or deleted)
        3. No save button
      2. Understanding master data
        1. Customers
        2. Items
        3. Vendors, resources, and locations
      3. Pricing
        1. Defining sales prices
        2. Defining sales discounts
        3. Purchase pricing
      4. Documents
      5. Document workflows
        1. Document approval
      6. Summary
    10. 2. Managing Payments and Banks
      1. Managing due dates
        1. Payment terms
        2. Prepayments
      2. Using credit cards and other payment methods
      3. Posting payments
        1. Suggesting vendor payments
        2. Creating and printing checks
      4. Checking customer and vendor balances
        1. Which invoice has been paid?
      5. Bank reconciliation
      6. Summary
    11. 3. Accounting Processes
      1. Posting accounting transactions
        1. Standard journals
        2. Recurring journals
          1. Allocations
      2. Reporting taxes – VAT
        1. VAT Settlement
        2. VAT Statements
      3. Managing fixed assets
        1. Creating a fixed asset and posting its acquisition cost
        2. Revaluating fixed assets
        3. Calculating depreciation
        4. Selling or disposing a fixed asset
        5. Canceling fixed asset entries
      4. Inventory valuation
        1. Choosing a costing method
        2. Calculating item entries costs
          1. Inbound entries
          2. Outbound entries
        3. Posting inventory valuation to the general ledger
        4. Inventory valuation report
      5. Closing the accounting year
        1. Closing accounting periods
        2. Running the Close Income Statement batch process
        3. Restricting the allowed posting dates
        4. Posting transactions on a closed year
      6. Consolidating financial statements
        1. Performing consolidation
          1. Consolidating on single database
          2. Consolidating with different databases
          3. Consolidating with other applications
        2. Reporting over a consolidated company
        3. Setting it up
          1. Defining business units
          2. Translating a chart of accounts
      7. Summary
    12. 4. Reporting and Business Intelligence
      1. Understanding dimensions
        1. Defining default dimensions on master data
        2. Using dimensions on documents and journals
      2. Using filters and flowfilters
        1. Applying filters on pages
        2. Applying flowfilters on pages
        3. Creating views
      3. Using reports
      4. Displaying charts
        1. Show as a chart option
        2. Adding charts to the role center page
      5. Using account schedules
      6. Analysis views
        1. Creating analysis views
        2. Using analysis views
          1. Analysis by dimensions
          2. Analysis views as a source for account schedules
      7. Business Intelligence with Excel and PowerPivot
      8. Summary
    13. 5. Foretelling – Budgeting and Cash Flow Management
      1. Budgets
        1. Creating budgets
        2. Using budgets
      2. Cash flow management
        1. Creating manual expenses and revenues
        2. Cash flow management setup
      3. Summary
    14. 6. Financial Management Setup
      1. Understanding posting groups
        1. Specific posting groups
        2. General posting groups
        3. VAT posting groups
      2. Setting up dimensions
      3. Number series
      4. General setup
      5. Summary
    15. 7. Other Financial Functionalities
      1. Currencies
      2. Intercompany postings
      3. Accounting implications of other areas
        1. Jobs
        2. Service
        3. Warehouse
        4. Manufacturing
      4. XBRL
      5. Summary
    16. Index