CoursesAI, Technology & DigitalAdvanced Excel and Microsoft Dynamics 365
AI, Technology & DigitalCertifiedTrending

Advanced Excel and Microsoft Dynamics 365

Microsoft Dynamics 365 is a complete enterprise system which can help businesses organise their sales and help with marketing operations. Our Dynamics 365 Training can help delegates learn, how to get the most out of this intelligent software suite.

Alkhobraa
Examined Program

Alkhobraa Certified Programme

Earn professional credits recognized by leading international accreditation bodies.

Duration:1 Day
Delivery:Classroom / Virtual
Language:English
Certificate:Yes
Registration Hub

Upcoming Scheduled Dates

Dubai

UAE

Public
5–9 July 2026
Alkhobraa Centre
Fee per Delegate
USD3,900

Riyadh

KSA

Public
11–15 October 2026
Alkhobraa Centre
Fee per Delegate
USD3,900
Target Audience

Who Should Attend
This Course?

This Course focuses on providing professionals with the knowledge and skills required to utilise the financial management capabilities of the Dynamics 365 Finance application. It can be beneficial for professionals, including: Financial Managers Accountants Financial Analysts Business Analysts ERP Project Managers IT Managers Consultants

Professional Roles
Financial ManagersAccountantsFinancial AnalystsBusiness AnalystsERP Project ManagersIT ManagersConsultants
Training Map

Course Agenda

An intensive, modular curriculum designed for deep professional proficiency and alignment with international industry standards recognized in Saudi Arabia.

Key Questions & Elements to be Covered
Introduction
Benefits of Dynamics 365 Finance
Overview
General Ledger
Cash and Bank Management
Tax
Accounts Payable
Accounts Receivable
Credit and Collections
Budgeting
Fixed Assets
Cost Accounting
Electronic Invoicing
Lab - Explore Dynamics 365 Finance
Introduction
Set Up Currencies and Conversions
Configure and Import Currency Exchange Rates
Lab - Import Exchange Rates
Introduction
Fiscal Calendars, Fiscal Years, and Periods
Create Fiscal Calendars, Years and Periods
Select a Fiscal Calendar
Define Budget Cycle Time Spans
Maintain Periods for your Organisation
Create Date Intervals
Lab - Work with the Fiscal Calendar, Year, And Periods
Introduction
Plan Your Chart of Accounts
Multiple Chart of Accounts
Set Up Chart of Accounts
Exercise - Create a New Main Account
Introduction
Main Account Categories
Main Account Information
Allocation Terms
Main Account Validation Options
Main Account Closing Options
Financial Tags
Accounts for Automatic Transactions
Lab - Create a Main Account Category in the Chart of Accounts
Define and Configure Financial Dimensions
Create a Custom Financial Dimension
Create an Entity-Backed Financial Dimension
Activate and Delete Financial Dimensions
Default Dimension Values
Derived Dimensions
Set up Financial Dimension Templates and Sets
Define and Configure Account Structures and Advanced Rules
Ledger Account Aliases
Exercise - Set up an account structure
Introduction
Understand the Different Types of Journals and their Setup
Describe Use Cases for Periodic Journals
Configure Ledger and Journal Setup
Discover Options for Implementing Voucher Numbers in Journals
Set Up Journal Approvals
Configure and Use Journals
Reverse Journal Posting
Set Up Batch Transfer Rules
Lab - Configure Ledger and Journal Setup
Introduction
Using Balance Control Accounts
Process a Journal Entry
Work with General Ledger Processes
Ledger Settlements
Create Templates to Edit Journals in Microsoft Excel
Create Voucher Templates
Set Up Journal Controls
Exercise - Create and Use a Voucher Template
Introduction
Set Up Intercompany Accounting
Post Intercompany Journals
Trace an Intercompany Entry
Lab - Set Up and Use Intercompany Accounting
Introduction
Configure and Apply Accrual Schemes
Configure Ledger Allocation Rules
Exercise - Configure and Use Accrual Schemes
Exercise - Configure and Test Ledger Allocation Rules
Set Up the Financial Period Workspace and Closing Schedule
Bank Reconciliations
Run Foreign Currency Revaluation Processes
Process End of Year Close
Perform Financial Consolidations
Lab - Perform year-end close and a consolidation
Introduction
Understand Different Types of Reports and Inquiries
Financial Reporting
Find Inquiries and Reports
Generate and Consume Inquiries and Reports
Configure Finance and Operations Apps for Microsoft Power Platform
Lab - Work with Reports
Introduction
Understand Bank Transaction Types and Groups
Set Up Cash and Bank Management Parameters
Set Up the Single Euro Payments Area (SEPA) Direct Debit Mandate
Set Up International Bank Account Number (IBAN) Structures
Configure Banks and Bank Check Layout
Set Up Bank Accounts for Customers
Set Up Bank Accounts for Vendors
Deposit and Refund Checks
Understand Cash Flow Forecast and Reports
Configure Cash Flow Forecasting
Set up cash flow automation
Summarize vendor and customer payments in bank transactions
Lab - Work with Cash and Bank Management
Introduction
Configure Ledger Posting Groups
Configure Sales Tax Authorities
Exercise - Set Up Sales Tax Authorities
Configure Sales Tax Settlement Periods
Exercise - Set Up Sales Tax Settlement Periods
Create Sales Tax Codes
Configure Sales Tax Groups and Item Sales Tax Groups
Exercise - Set Up Sales Tax Codes and Sales Tax Groups
Withholding Tax
Sales Tax Exemption
Conditional Sales Tax
Sales Tax on Transactions
Set Up Sales Tax Reporting Codes
Exercise - Set Up Sales Tax Reporting Codes and Withholding Tax
Prepare Periodic Filings
Introduction
Payment Schedule
Terms of Payment and Payment Days
Cash Discounts
Payment Fees
Set Up the Credit Card Payment Service
Methods of Payment and Payment Control
Set Up a Payment Calendar and Payment Calendar Rules
Create and Maintain Customers
Set Up Customer Posting Profiles
Configure Accounts Receivable Charges
Lab - Configure Customer Posting Profiles and Create a New Customer
Introduction
Create Free Text Invoices
Exercise - Create and Process A Free Text Invoice
Recurring Free Text Invoices
Create and Handle Payments of Customer Invoices for Sales Orders
Exercise - Work with Invoices from Sales Orders
Settle Transactions and Undo Settlements
Exercise - Process an Invoice and Settle it Against a Payment
Reimburse a Customer
Introduction
Configure Accounts Receivables for Credit and Collections
Configure Credit and Collections Components
Set Up Interest Rates for an Interest Code
Waive, Reinstate, or Reverse Interest Fees
Set Up and Manage Collection Letters
Exercise - Set Up Credit and Collections in Finance
Exercise - Create a Write-Off Journal for a Customer
Introduction
Customer Account Statement
Working with Collections
Collections Coordinator Workspace
Manage Customer Credit and Collections
Credit Management
Lab - Work with Credit and Collections
Introduction
Configure the Payment Schedule
Configure Terms of Payment and Payment Days
Configure Cash Discounts
Set Up Payment Fees
Create Vendor Groups
Set Up Accounts Payable Posting Profiles
Create Vendors
Set Up Methods of Payment for Vendors
Set Up Electronic Payment Formats
Configure Accounts Payable Charges
Configure and Use Positive Pay
Lab - Configure Accounts Payable Components
Introduction
Understand Invoice Types in Accounts Payable
Record Vendor Invoices
Process Accounts Payable Credit Memos
Process Purchase Orders and Purchase Order Invoices
Periodically Recurring Invoices
Exercise - Record an Invoice
Exercise - Record a Vendor Invoice That is Not Associated with a Purchase Order
Introduction
Settle Transactions and Undo Settlements
Distribute Funds by Using Accounting Distributions
Configure Invoice Validation Policies
Three-Way Matching Policies
Vendor Invoice Workflow
Lab - Work with Accounting Distributions, Invoice Validations, and Settlements
Introduction
Configuration Options
Enable Automatic Vendor Invoice Prepayments
Use Workflow and Product Match Receipts
View Vendor Invoice Automation Results
Introduction
Plan Expense Management
Intercompany Expenses
Financial Management
Per Diems
Journals and Accounts
Payment Methods
Taxes
Policies
Expense Categories and Shared Categories
Map Expense Categories to a Main Account
Introduction
Expense Management Workspace
Expense Management Parameters
Expense Management Workflows
Expense Report Policies and Per Diem Rules
Evaluate Policies by Using Audit Workbench Cases
Set Up Mileage Expense Options
Intercompany Expenses
Personal Expenses on an Expense Report
Set Up Credit Card Transaction Processing and Import Credit Transactions
Expense Receipt Processing
VAT Recovery
Introduction
Plan for Basic Budgeting and Budget Control
Budget Methodologies
Basic Budgeting Overview
Set Up Basic Budgeting
Create and Manage Budget Register Entries
Exercise - Create A Budget Register Entry
Implement A Budget Register Workflow
Use Workspace and Inquiry Pages to Track Budget Vs. Actuals
Use Inquiries and Reports for Budget Analysis
Exercise - Set Up Basic Budgeting Components
Budget Control Overview and Concept
Set up Budget Control Parameters
Budget Funds Available
Budget Source Documents
Budget Groups
Activate Budget Control
Exercise – Set up Budget Control Components
Introduction
Configure Budget Planning Components
Exercise - Configure Budget Planning, Create, And Use A Planning Process
Introduction
Fixed Assets and Current Assets
Accounting for Fixed Assets
Relationships Between Fixed Assets Components
Configure Fixed Assets Components
Derived Books
Enable Fixed Asset Integration
Fixed Asset Transaction Options
Demonstration - Create a Fixed Asset
Lab - Work with Fixed Assets
Introduction
Life Cycle of a Fixed Asset
Fixed Asset Management Workspace
Fixed Assets Page
Set Up Fixed Assets
Create a Fixed Asset
Activate a Stock Item
Set Up Acquisitions
Proposals
Acquire Assets Through Procurement
Estimate and Eliminate A Project to A Fixed Asset
Manual and Automatic Methods to Create Fixed Assets
Lab - Acquire A New Asset
Introduction
Asset Budgeting
Transfer a Fixed Asset
Set Up Fixed Asset Groups
Split a Fixed Asset
Update Fixed Asset Information
Recalculate Replacement Costs and Insured Values for Fixed Asset Groups
Fixed Assets Roll Forward Report
Introduction
Depreciation
Dispose of And Lend Fixed Assets
Sell A Fixed Asset by Using a Free Text Invoice
Dispose of Fixed Assets as Scrap
Exercise - Create a Depreciation Proposal

Need a tailored curriculum?

We can customize the agenda to match your assets, operational challenges, and sector-specific Saudi requirements.