Duration: 2 Days
In this course, you will be given the tools and knowledge to set up the financial management application area. The focus is on the advanced financial functions within the organization such as multicurrency, cost accounting, cash flow forecast, and the VAT rate change tool. Furthermore, this course focuses on internal reporting and analysis functionality, in addition to the means for sharing data outside of the Microsoft Dynamics NAV environment, either through XBRL-a language for tagging financial data-or by exporting data to Microsoft Office Excel 2010.
What You Will Learn
- Set up Intrastat for use in Microsoft Dynamics NAV 2013
- Run and submit Intrastat reports
- VAT rate change process
- Viewing amounts, daily processing, and periodic processes when using an additional reporting currency
- Budgets feature in Microsoft Dynamics NAV 2013
- Create budgets by using the Copy Budget function
- Create budgets by using the Export Budget and Import Budget functions
- Set up cost journals
- Set up Chart of Cash Flow Account, Cash Flow Setup, and Cash Flow Payment Terms
- Cost account schedules
- Cash flow account schedules
- Set up analysis views
- Exporting analysis views to Microsoft Office Excel 2007
Audience
Partners that sell and implement the finance module to customers. The typical partner has an ERP background and is strong in accounting principles.
Prerequistes
- Basic knowledge of accounting principles and procedures
Course Outline
1. Intrastat
- Set Up Intrastat
- Report Intrastat
2. VAT Rate Change Tool
- Prepare for VAT Rate Change Tool
- Set Up Using VAT Rate Change Tool
- Perform VAT Rate Conversions
3. Multicurrency
- Currency Card and Exchange Rates
- Set Up Multicurrency for Customers, Vendors, and Bank Accounts
- Process Documents and Journals
- Adjust Exchange Rates Batch Job for Customers, Vendors, and Bank Accounts
- Reporting Currency
- View the Exchange Rate Adjustment Register
- Summary of Currency Exchange Rates
4. Budgets
- Creating Budgets
- Copying Budgets
- Exporting and Importing Budgets
5. Cost Accounting
- Workflow in Cost Accounting
- Setting Up Cost Accounting
- Cost Entries
- Cost Budgets
- Cost Allocation
- Cost Accounting History
- Cost Accounting Reporting
- Tips and Tricks
6. Cash Flow Forecast
- Functions of the Cash Flow Forecast
- Setting Up Cash Flow Forecasts
- Creating Cash Flow Forecasts
- Cash Flow Forecast Reporting
7. Financial Reporting and Analysis
- Analyze the Chart of Accounts
- Account Schedules
- Analysis by Dimensions
- Export Analysis Views to Microsoft Excel
- Dimension-Based Reports
- Combine Analysis Views with Account Schedules
- Finance Performance Charts
8. XBRL
- XBRL Terminology
- XBRL Specifications and Taxonomies
- Work with Linkbases
- Enter XBRL Line Definitions
- Export the XBRL Lines
Course Labs
Lab 1: Create an Intrastat Report
Lab 2: Process a Sales Invoice
Lab 3: Post Expenses in Foreign Currency
Lab 4: Update the USD: GBP Exchange Rate
Lab 5: Create a Budget
Lab 6: Copy a Budget
Lab 7: Using Cost Journals
Lab 8: Set Up a Cost Budget
Lab 9: Set Up Cost Allocation
Lab 10: Creating a Cash Flow Forecast
Lab 11: Entering Manual Revenues and Expenses
Lab 12: Using the Cash Flow Worksheet
Lab 13: Printing the Cash Flow Date List
Lab 14: Create a Detailed Account Schedule
Lab 15: Create a Cost Account Schedule
Lab 16: Create a Cash Flow Account Schedule
Lab 17: Create an Analysis View
Lab 18: Create a Cash Flow Analysis View
Lab 19: Export an Analysis View to Microsoft Excel
Lab 20: Combine an Analysis View with an Account Schedule
