- Learn how to analyze list data by using data analysis mode in Dynamics 365 Business Central.
This module explains the following concepts:
- Data analysis mode
- Date hierarchy and pivot mode
- How to share data analysis
- Make Business Central data available for easy reporting with Excel and intelligent analysis with Power BI.
By the end of this module, students are able to:
- Create Business Central web services that can be used as data sources in Power BI
- View data in Power BI reports in Business Central
- Enable business data for Power BI
- Export business data to Excel
- If you want to know how to use general journals, then this module can help. This module explains how to use general journals to post information into the general ledger and other accounts. You can also use the general journal to post cost allocations and other adjustments to the accounts, and then you can reverse and correct entries that are incorrect.
By the end of this module, you'll be able to:
- Create and post general journal entries.
- Use standard journals to save and retrieve general journal lines.
- Preview the posting of general journal lines.
- Reverse journal entries.
- Process a fixed asset disposal.
- When you frequently need to enter the same journal postings, Dynamics 365 Business Central provides recurring journals so you can post journal lines on a recurring basis. Additionally, when you use recurring journals, you can post cost allocations by using allocation keys that are based on amounts or percentages.
By the end of this module, you'll be able to:
- Understand how to use recurring journals.
- Use recurring journals with fixed and variable amounts.
- Record accruals by using recurring journals.
- Do you want to know how to manually process customer payments in Business Central? If so, then this module is for you. This module will focus on how to enter payments manually in the cash receipt journal and payment journal, and it will also explain how to apply payments.
By the end of this module, you'll be able to:
- Process a customer payment manually.
- Enter a line in the payment journal manually.
- Apply a payment to customer and vendor ledger entries.
- Process a partial payment.
- Unapply entries to customer and vendor ledger entries.
- Process payment differences automatically.
- Do you want to find out how to reconcile bank accounts in Dynamics 365 Business Central? Then this module is for you. The bank reconciliation feature is used to check the bank ledger entries and the balance on the accounts against the statement from the bank.
By the end of this module, you'll be able to:
- Populate bank reconciliation lines.
- Import bank statements.
- Match reconciliation lines.
- Post the bank account reconciliation.
- Learn how to correct or adjust fixed assets entries in this module, including correcting single entries and multiple entries at once.
In this module, you'll:
- Correct a single entry.
- Correct multiple entries at once.
- Reverse journal postings.
- Do you want to know how to post a purchase document for a fixed asset? This module shows how to use purchase invoices to post the acquisition cost to a fixed asset.
In this module, you'll:
- Create a purchase document for a fixed asset.
- Post the acquisition cost to a fixed asset.
- Duplicate the acquisition cost to other depreciation books.
- Check the fixed asset ledger entries to consult the acquisition cost.
- Learn how to calculate and post periodic depreciation in Microsoft Business Central, including setting depreciation days.
In this module, you'll:
- Calculate asset depreciations in Business Central.
- Set the number of depreciation days.
- Check the total depreciation for a fixed asset.
- Print reports with fixed assets depreciations.
Stuck in Tutorial Hell? Learn Backend Dev the Right Way
AI, Data Science & Cloud Certificates from Google, IBM & Meta
Overview
AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
Syllabus
- Analyze list data using data analysis mode in Business Central
- Introduction
- Prerequisites and getting started
- Work with data analysis mode
- Date hierarchies and pivot mode
- Share data analysis
- Check your knowledge
- Summary
- Configure Business Central for Excel and Power BI
- Create web services to link Power BI and Business Central
- Add Business Central as a data source in Power BI
- Create list data Power BI reports to display in Business Central
- Configure Business Central apps in Power BI
- Work with business data in Excel
- Analyze, group, and pivot data on list pages using data analysis mode
- Exercise - Create a Business Central web service to use as a Power BI data source
- Check your knowledge
- Summary
- Create and process journal entries in Dynamics 365 Business Central
- Introduction - Create journal entries
- Correct dimensions on posted entries
- Process journal entries
- Use standard journals
- Use deferrals in journals
- Correct journal entries
- Set up checking documents and journals while you work
- Process fixed asset disposals
- Exercise - Create and post a journal entry
- Check your knowledge
- Summary
- Post periodic journal entries in Dynamics 365 Business Central
- Introduction to recurring journals
- Allocate amounts
- Set up bank export and import formats
- Edit recurring journals in Excel
- Exercise - Create and post a recurring journal
- Check your knowledge
- Summary
- Enter payments in the cash receipt journal and the payment journal in Dynamics 365 Business Central
- Introduction - Enter payments
- Apply payments
- Unapply customer and vendor ledger entries
- Process payment registrations
- Set up payment tolerances
- Set up G/L accounts for payment tolerances
- Process payment tolerances when posting payments
- Print customer statements
- Exercise - Register a customer payment
- Check your knowledge
- Summary
- Perform a bank reconciliation in Dynamics 365 Business Central
- Introduction to and completing the reconciliation process
- Post the bank account reconciliation
- Import a bank statement
- Reconcile bank accounts with Copilot
- Undo a bank account reconciliation
- Check your knowledge
- Summary
- Correct entries in Dynamics 365 Business Central
- Introduction
- Cancel multiple entries
- Cancel a fixed asset sale
- Reverse journal postings
- Check your knowledge
- Summary
- Purchase fixed assets in Dynamics 365 Business Central
- Introduction
- Post the acquisition cost from a journal
- Post additional acquisition costs
- Duplicate entries
- Exercise - Purchase a fixed asset
- Check your knowledge
- Summary
- Calculate and post depreciations in Dynamics 365 Business Central
- Introduction
- Work with the number of depreciation days
- Print depreciation reports
- Exercise - Calculate depreciation
- Check your knowledge
- Summary