Microsoft Dynamics 365 Enterprise Edition - Financial Management - Third Edition

Book description

Boost your accounting and financial skills with Microsoft Dynamics 365

About This Book

  • Make real-time data-driven decisions for your enterprise with Microsoft Dynamics 365 Enterprise edition
  • Configure and set up the Microsoft Dynamics 365 financial module via highly useful tips and tricks
  • Administer customer relations and plan enterprise resources with this systematic guide

Who This Book Is For

This book is for application consultants, solution architects, controllers, CFOs, pre-sales and other professionals who are involved in a Microsoft Dynamics 365 for finance and operation implementation. Basic knowledge of financial terms, concepts, and terminologies is required.

What You Will Learn

  • Examine the business logic behind the financial functionalities of Microsoft Dynamics 365 FFO
  • Set up and configure the core modules of financial management
  • Grasp the key control points of financial management
  • Explore intercompany and consolidation in Microsoft Dynamics 365 FFO
  • Understand multi-currency sales, tax mechanisms, and budgeting capabilities in Microsoft Dynamics 365 FFO
  • Get to grips with month/year-end period close functionality
  • Understand the account payable and receivable module
  • Use Microsoft Dynamics 365 to create financial reports

In Detail

Microsoft Dynamics 365 for finance and operations is a rapidly growing application and is widely used in enterprise organizations. Because of its ability to maximize business productivity, it is a fast-growing business application package in the ERP market.

We will start by looking into ERP concepts, implementation needs, and interface design, giving you basic knowledge of financial management aspects and explaining key concepts along the way. To begin with, you'll be taken through the general ledger and financial dimension functions. You'll later learn about the sales tax mechanism and multi-currency in Microsoft Dynamics 365. We tackle each topic with focused examples and explanations on topics such as payable/receivable accounts, forecasting, cash and bank management, budgeting planning/control, and fixed assets. Finally, we walk you through intercompany, consolidation, costing basics, and financial reporting.

By the end of this book, your finance team will have a much richer understanding of Microsoft Dynamics 365 for finance and operations and its powerful capabilities.

Style and approach

This book is a step-by-step guide focusing on implementing Dynamics 365 financial management for your organization.

Publisher resources

View/Submit Errata

Table of contents

  1. Title Page
  2. Copyright and Credits
    1. Microsoft Dynamics 365 Enterprise Edition – Financial Management Third Edition
  3. Dedication
  4. Packt Upsell
    1. Why subscribe?
  5. Contributors
    1. About the author
    2. About the reviewer
    3. Packt is searching for authors like you
  6. Preface
    1. Who this book is for
    2. What this book covers
    3. To get the most out of this book
      1. Download the example code files
      2. Download the color images
      3. Conventions used
    4. Get in touch
      1. Reviews
  7. Getting Started with Microsoft Dynamics 365 for Finance and Operations
    1. Understanding ERP characteristics
    2. Discovering the implementation team
      1. Responsibilities and motivation of an ERP consultant
    3. Exploring key intentions of ERP implementations
    4. Understanding the ERP module's integration
      1. Procure-to-pay
        1. Product receipts
        2. Invoice
        3. Payment
        4. Settlement
      2. Order-to-cash
        1. Packing slips
        2. Invoice
        3. Payment
        4. Settlement
    5. Understanding the cloud offering
    6. Exploring ERP on the cloud
    7. Exploring ERP and reporting
    8. Posting types in Microsoft Dynamics 365 for Finance and Operations
    9. Exploring common terms in ERP implementations
    10. Exploring the Microsoft Dynamics implementation methodology – Sure Step
    11. Exploring Microsoft Dynamics Lifecycle Services
    12. Looking at the Microsoft Dynamics 365 for Finance and Operations user interface
    13. Summary
  8. Understanding the General Ledger
    1. Understanding the COA
      1. Classifying main accounts
        1. Using transactional accounts
          1. Balance accounts
          2. Profit and loss accounts
        2. Using nontransactional accounts
          1. Totals
      2. Main account categories
    2. Controlling the general ledger
      1. Controlling the main accounts
        1. Debit/credit controls
          1. Debit/credit default
          2. Debit/credit requirements
          3. Balance control
        2. Using account administration
          1. Do not allow manual entry
          2. Activation date
          3. Suspending account
        3. Using posting validation
          1. Currency control
          2. User control
          3. Posting type
      2. General ledger parameters
        1. General controls
          1. Check for voucher used
          2. Check continuous number sequence
          3. Interrupt in case of error account
        2. Accounting rules
          1. Correction
          2. Accounting rules
    3. Understanding shared financial data
    4. Understanding financial management in action
      1. Opening balance
        1. Planning and design
        2. Execution
          1. Fixed assets opening balance
          2. Inventory opening balance
          3. Ledger and sub-ledger opening balances
      2. Performing daily transactions
        1. The ledger account alias
        2. Recurring entries
        3. Saving a voucher
        4. Global general journal
        5. Excel integration
      3. The closing procedure
        1. Closing schedules
        2. Templates
        3. Calendars
        4. Task areas
        5. Resources
        6. Closing roles
    5. Summary
  9. Exploring Financial Dimensions
    1. Understanding the concept of financial dimensions
    2. Understanding the ledger account segmentation
      1. Segmented ledger accounts
      2. Financial dimensions entry
        1. Creating financial dimensions
        2. Financial dimensions controls
          1. Financial dimension activation
          2. Require financial dimension to be balanced
          3. Do not allow manual entries
          4. Dates activation
          5. Suspending financial dimensions
          6. Assigning an owner to a financial dimension
        3. Configuring the account structure
    3. Advanced rules structure
    4. Fixed dimension
    5. Posting types in Microsoft Dynamics 365 for Finance and Operations
      1. The posting profile concept
      2. Journal posting
      3. Financial dimensions' posting mechanism in transaction documents
    6. Exploring dimension reporting
      1. Financial dimension sets
    7. Summary
  10. Understanding Sales Tax
    1. Exploring sales tax high-level cycles and entries
      1. Sales tax business process
    2. Understanding sales tax integration with other modules
      1. Sales tax integration points
    3. Sales tax setup and configuration
      1. Sales tax setup elements
      2. The sales tax mechanism in Microsoft Dynamics 365 for Finance and Operations
      3. Sales tax calculation and posting configurations
    4. Exploring conditional sales tax
      1. Conditional tax business process
      2. Conditional tax setup and configuration
    5. Understanding withholding tax
    6. Summary
  11. Working with Currencies
    1. Understanding multi-currency in Microsoft Dynamics 365 for Finance and Operations
    2. Exploring multi-currency in action 
    3. Summary
  12. Understanding Accounts Payable Basics and Controls
    1. Understanding accounts payable integration with other modules
    2. Exploring vendor master data characteristics
      1. The General fast tab
      2. The Purchasing demographics fast tab
      3. Invoice and delivery fast tab
        1. The INVOICE field group
        2. The SALES TAX field group
        3. The WITHHOLDING TAX field group
      4. The Purchase order defaults fast tab
        1. The DISCOUNT field group
        2. Vendor price/discount groups
      5. The Payment fast tab
      6. Terms of payment
      7. Method of payment
      8. The PAYMENT SCHEDULE field group
      9. Cash discount
    3. Exploring accounts payable controls
      1. Vendor hold activities
      2. Invoice matching controls
      3. Invoice matching
      4. Price tolerance
      5. The invoice number
      6. The Posting profile
    4. Summary
  13. Exploring Accounts Payable Transactions
    1. Exploring accounts payable transactions
      1. The purchase order invoice
      2. The prepayment invoice
      3. Vendor invoice register, invoice approval, and invoice pool
      4. Non-inventory vendor invoices 
      5. Global vendor invoice journal
      6. Vendor payment proposal
      7. Vendor advanced payment
      8. Vendor settlement
      9. The vendor settlement mechanism in Microsoft Dynamics 365 for Finance and Operations
    2. Summary
  14. Understanding Accounts Receivable
    1. Understanding the accounts receivable module's integration with other modules
    2. Exploring customer master data characteristics
      1. The Sales order defaults fast tab
        1. The DISCOUNT field group
      2. Customer price or discount groups
        1. The PAYMENT fast tab
        2. Terms of payment
      3. Method of payment
        1. Payment specification
        2. Payment schedule
      4. Cash discount
        1. The Invoice and delivery fast tab
          1. The INVOICE field group
          2. The SALES TAX  field group
    3. Exploring the accounts receivable module's controls
      1. Customer hold activities
      2. Customer credit limit management
    4. Exploring accounts receivable transactions
      1. Sales order invoice
      2. Free text invoice
      3. Free text correction
      4. Collection management
        1. Collection letter
        2. Interest note
      5. Customer settlement
      6. Customer settlement mechanism – Dynamics 365 for Finance and Operations
    5. Summary
  15. Understanding Cash and Bank Management
    1. Understanding cash and bank integration
    2. Controlling cash and bank management
      1. Credit limit
      2. Date activation
      3. Status activation
      4. General ledger reconciliation
      5. Transaction currency
    3. Exploring cash and bank management in action
      1. Bank account reconciliation
      2. Bank facility – the letter of guarantee
    4. Working with vendor checks
    5. Summary
  16. Functioning of Cash Flow Management
    1. Understanding cash flow integration with other modules
    2. Cash flow forecast configuration
      1. Accounts payable
      2. Accounts receivable
      3. Budget
      4. General ledger
    3. Cash flow transactions
      1. Purchase order cash flow forecast
    4. Summary
  17. Exploring Budgeting
    1. Understanding budgeting capabilities in Dynamics 365 for Finance and Operations
      1. Basic budgeting
        1. Budget models
        2. Budget codes
        3. Dimensions for budgeting
        4. Budget allocation terms
          1. Dimensions allocation terms
          2. Period allocation terms 
    2. Budget planning 
    3. Budget control
    4. Budget in action
    5. Summary
  18. Working with Intercompany Accounting
    1. Exploring intercompany accounting
    2. Understanding the setup and configuration of intercompany accounting
    3. Summary
  19. Working with Consolidation and Elimination
    1. Exploring consolidation and its approaches
    2. Exploring consolidation and elimination in action
    3. Summary
  20. Working with Cost Management
    1. Understanding the business costing model
    2. Configuring inventory costing
      1. Item model groups
      2. Product dimension groups
      3. Storage dimension groups
      4. Tracking dimension groups
      5. Item groups
    3. Exploring the inventory costing background
      1. Physical and financial updates
      2. Physical update
      3. Financial update
    4. Understanding inventory recalculation and closing
    5. Working with inventory marking
    6. Exploring inventory reconciliation
      1. Inventory value report setup
      2.  Generating Inventory value report
    7. Summary
  21. Exploring Fixed Assets
    1. Understanding fixed assets integration with other modules
    2. Exploring fixed assets master data characteristics
      1. Depreciation profiles
        1. Depreciation methods
          1. Constant fields
          2. Dynamic fields
      2. Books
      3. Fixed asset groups
      4. Fixed assets
    3. Exploring fixed assets transactions
      1. Fixed asset disposal sale
      2. Retrieving fixed asset transactions
      3. Changing fixed asset groups
      4. Fixed assets reclassification
      5. Fixed assets scrap value
      6. Fixed asset statement report
    4. Summary
  22. Exploring Financial Reporting and Analysis
    1. Planning reporting needs for ERP
    2. Understanding the information technology value chain
      1. Cloud infrastructure
      2. Database management
      3. Business processes
      4. Business intelligence
      5. Frontend
    3. Understanding Microsoft Dynamics 365 for Finance and Operations information source blocks
      1. Detailed transactions block
      2. Business intelligence block
      3. Executive decisions block
    4. Discovering Microsoft Dynamics 365 for Finance and Operations reporting
      1. Reporting options
        1. Inquiry forms
        2. SSRS reports
          1. The Transaction origin function
          2. The Original document function
          3. The Audit trail function
      2. Microsoft Dynamics financial reports 
    5. Summary
  23. Other Books You May Enjoy
    1. Leave a review - let other readers know what you think

Product information

  • Title: Microsoft Dynamics 365 Enterprise Edition - Financial Management - Third Edition
  • Author(s): Mohamed Aamer
  • Release date: March 2018
  • Publisher(s): Packt Publishing
  • ISBN: 9781788839297