Pass the Microsoft Certified: Dynamics 365 Business Central Functional Consultant Associate MB-800 Questions and answers with Dumpstech

To integrate Power BI with Dynamics 365 Business Central, you need to make Business Central data available to Power BI. The standard and recommended method is to use OData web services.

Option A: Enable the Power BI Embedded service (Incorrect)

This allows embedding Power BI reports inside Business Central but does not expose Business Central data to Power BI.

Option B: Publish the OData web services for the required entities (Correct)

Power BI can consume Business Central data through OData feeds or APIs.

You expose the required data by publishing OData web services in Business Central (e.g., Customers, Vendors, G/L Entries).

Once published, you connect to these OData URLs from Power BI Desktop to build reports.

Option C: Select the Share action in Business Central (Incorrect)

The Share action is used for sharing reports or documents within Business Central, not for exposing data to Power BI.

Option D: Create a user account in Business Central for Power BI access (Incorrect/Not sufficient)

While a licensed user account is needed to authenticate, just creating a user does not expose data. You still need OData or APIs.

Thus, the correct way to expose Business Central data to Power BI is by publishing OData web services.

Microsoft Learn References

Connect to Business Central data from Power BI

Publish a Web Service

Using OData in Business Central

Comprehensive Detailed Explanation along with All References available from Microsoft Dynamics 365 Business Central Functional Consultant at end of each question below

Business Central uses different journals to process payments and receipts, each designed for a specific type of financial transaction:

Suggested payments to external parties → Payment Journal

The Payment Journal supports the Suggest Vendor Payments function, which proposes vendor payments based on due dates, discount dates, and available funds.

 From the desired Item card, navigate to Set Special Discounts.

 Specify the customer who will receive a discount.

 Enter the discount percent in the Line Discount % field.

In Dynamics 365 Business Central, when the new sales pricing experience is NOT enabled, discounts are managed using the Sales Line Discounts functionality. To set up specific item discounts for customers:

From the desired Item card, navigate to Set Special Discounts

This opens the Sales Line Discounts page where you can define discounts tied to that item.

Specify the customer who will receive a discount

You must identify the target customer (or customer group) so the system knows to apply the discount only for them.

Enter the discount percent in the Line Discount % field

This is where you define the actual discount percentage to be applied when the customer purchases the item.

Why not the other options?

Define the required discount strategy on the Sales & Receivables Setup page → This is for general discount posting policies but does not configure item-specific discounts.

Configure the Standard Sales Lines page and assign it to a customer record → Standard Sales Lines are used for recurring order templates (like blanket orders), not for configuring line discounts.

Thus, the correct sequence is:

Set Special Discounts from Item Card → Specify Customer → Enter Discount %.

Microsoft Learn References

Set Up Line Discounts

Register Special Prices and Discounts

Comprehensive Detailed Explanation

The requirement is: filter the view to show all customers in the My Customers list and calculate the year-to-date sales.

Step 1: Open the customer list.This is the starting point to access customer records.

Step 2: Open the filter pane and filter to %MYCUSTOMERS.%MYCUSTOMERS is a system filter placeholder that limits the list to the logged-in user’s “My Customers” set.

Step 3: Add Date Filter with Y (year).Adding a Date Filter with Y restricts sales data to the current year (year-to-date).

Step 4: Save the filtered view.Save the filtered and calculated view for reuse and name it appropriately.

Alternative accepted sequence:

You could also apply the Date Filter before filtering customers, as both orders produce the same result.

Microsoft Learn References

Filter Data in Business Central

Save and Personalize List Views

Work with My Customers and My Vendors

The requirement is:

The use of locations must be mandatory for all users.

Bins must be set up as mandatory for each location.

Here’s how it is configured in Dynamics 365 Business Central:

Inventory Setup (A)

On the Inventory Setup page, there is a field called Location Mandatory.

When this is enabled, every inventory transaction must have a location specified.

This makes locations mandatory globally across the system.

Location Card (B)

On each Location Card, you can enable Bin Mandatory.

This ensures that for all items at that location, transactions must specify a bin.

Other options:

Inventory Posting Setup (C): Defines how items post to the G/L (account mapping) but not about mandating locations or bins.

Sales & Receivables Setup (D): Controls sales process settings, not inventory/bin usage.

Item Card (E): Item-specific data; bins and mandatory settings are not defined here.

Microsoft Learn References

Set Up Locations

Inventory Setup

Bins in Locations

When a customer needs to create many similar items manually in Dynamics 365 Business Central, the most efficient way is to use Item Templates:

Save an existing item as a template

Open the Item Card for an existing item.

Use the action Save as Template to generate a reusable item template with the existing item’s information.

This speeds up creating new items with shared properties.

Correct option: B.

Edit the item template

Go to the Set Up Customer/Vendor/Item Templates page.

Here you can refine or modify the template details (such as default posting groups, costing methods, etc.) before reusing it.

Correct option: C.

Create a new item using the template

When creating a new item, select the saved template.

Business Central automatically copies the template information into the new item card.

Correct option: E.

Why not the others:

A. On the Set up Customer/Vendor/Item Templates page, create a new item template → While possible, the requirement here is about copying existing items, not creating templates from scratch.

D. On the Configuration Templates page, create a new template for item table → This is used for data migration/configuration packages, not for day-to-day item creation.

The scenario:

The customer wants to sell items that are not normally counted in the company's warehouse.

In Microsoft Dynamics 365 Business Central, you can define items as different Types:

Inventory → Stocked, physically tracked in the warehouse with inventory valuation.

Non-Inventory → Items that are not tracked in inventory. They can still be sold or purchased but are not included in inventory counts or valuations. This is commonly used for items like office supplies, spare parts not worth tracking, or resale products not stocked.

Service → Used for non-physical services (consulting, labor).

Resource → Used for capacity (e.g., machine or person for projects).

Item Charge → Used to distribute costs (freight, customs, handling) to item costs, not for selling tangible items.

Why the correct choice is A (Non-Inventory Item type):

Non-Inventory items allow the company to sell or purchase items without managing them in warehouse stock.

This matches the requirement that the company does not want the items counted in inventory.

Why not the others:

B. Item charge → Adds costs to items (e.g., freight), not for selling goods.

C. Inventory Item type → This would force tracking and counting in the warehouse.

D. Resource → Represents labor or machine capacity, not goods for sale.

Microsoft Learn References

About Item Types in Business Central

When posting opening balances using General Journals in Business Central and the Force Doc. Balance option is enabled, the system enforces that the journal must balance at the level of:

Document No. (D): Each document number must balance independently.

Posting Date (A): Each posting date must balance; otherwise, out-of-balance occurs.

Amount (C): The debit and credit amounts must balance to zero.

Incorrect options:

B (Balance by gen. posting type): Not a balancing condition for Force Doc. Balance.

E (Balance by dimension set ID): Dimensions are not required for balancing in journals, only for analysis.

Thus, to resolve the Out of balance error, the journal lines must balance by date, by amount, and by document number.

Microsoft Learn References

General Journals in Business Central

Post Transactions by Using Journals

Force Doc. Balance Option

Correct Answer: A, C, D

In Dynamics 365 Business Central, security is defined by assigning permissions to users. Each permission is associated with an object type. The allowed permission types differ depending on the object type:

Table

This refers to the table object definition, not its data.

Permissions allowed: Execute only (to access the table object, metadata).

Actual data permissions (read, insert, modify, delete) are handled separately by Table Data.

Page

A page is an interface object (e.g., Card, List).

Permissions allowed: Execute (grants access to run or view the page).

Table Data

Refers to the actual records stored in the database.

Permissions allowed: Read, Insert, Modify, Delete (CRUD).

This is where you control access to data, not just the object structure.

System

System objects are internal to the platform (system tables, codeunits).

Permissions allowed: Execute to allow access to system-level functionality.

Microsoft Learn References

Permissions and Permission Sets in Business Central

Types of Objects and Their Permissions