MB-800 Microsoft Dynamics 365 Business Central Functional Consultant Questions and Answers

The requirement is: “Customer pricing is determined by the customer market type (Retail, Veterinarian, Breeder). Each customer is associated with only one market type.”

A. Assign the Customer Price Group code on the customer card → Correct, because each customer must be tied to its market type via a Customer Price Group.

C. Create a Sales Price List by using the assign-to type of Customer Price Group → Correct, because pricing and discounts should be managed at the group level, not per individual customer, ensuring easier maintenance.

E. Create Customer Price Groups that allow line discounts → Correct, because discounts are offered by item, brand, or product category, and must flow to sales lines automatically.

Incorrect options:

B. Exclude line discounts → Opposite of requirements.

D. Create a Sales Price List for the customer → Not scalable; must be done by group, not individual customer.

Correct answers: A, C, E

Comprehensive Detailed Explanation

The requirement is to configure the system so that sales discounts are visible and tracked correctly in Dynamics 365 Business Central.

Define simultaneous posting → General Ledger Setup

In Business Central, the General Ledger Setup page contains fields that control whether discounts are posted separately or combined with sales postings.

By defining discount posting behavior at the General Ledger Setup level, you ensure consistency across all sales transactions and financial reporting.

Other options (Sales & Receivable Setup, Customer, Item) do not define global simultaneous posting behavior for discounts; they control transaction processing but not the separation of discount postings.

Specify type to post separately → Discount Posting

To show sales discounts separately, you must enable Discount Posting.

This ensures discounts are posted to a dedicated G/L account, rather than being netted off directly against sales.

As a result, financial statements can show both gross sales and discounts given, which is critical for profitability analysis and discount tracking.

The other options in the list:

Invoice Disc. Code → Used to define specific invoice discounts, but not to enforce posting separately.

Special Prices & Discounts → Controls pricing rules but not posting behavior.

Adjust for Payment Disc. → Manages how payment discounts affect invoices, but again, not posting visibility.

With this setup, Wide World Importers can track gross sales, discounts, and net sales transparently in reports, allowing management to analyze the financial impact of discounts.

Microsoft References

General Ledger Setup in Business Central

Discount Posting Field (Post Discounts Separately)

Work with Sales Discounts in Business Central

Correct Answer:

Define simultaneous posting: General Ledger Setup

Specify type to post separately: Discount Posting

Business Central Functional Consultant at end of each question below

In Business Central, posting periods and deferral posting control are managed through the User Setup page.

The User Setup table/page allows you to assign user-specific posting restrictions by specifying Allow Posting From and Allow Posting To dates.

These restrictions apply to all posting transactions for that user, including deferrals. This ensures you can control in which periods each user is allowed to post.

This setup overrides the company-wide settings in General Ledger Setup (where you also have global Allow Posting From/To dates).

Why the other options are incorrect:

A. User Tasks – Provides task reminders or workflow assignments for users, not posting date control.

B. My Settings – Lets a user configure personal settings like Role Center, company, region, or work date, but it does not control posting periods.

D. Profiles (Roles) – Define user interface profiles (role-tailored experience), not transactional posting periods.

Therefore, the correct configuration page is User Setup.

Microsoft Learn References

Define Posting Periods for Users (User Setup with Allow Posting From/To):https://learn.microsoft.com/en-us/dynamics365/business-central/finance-how-specify-posting-periods

User Setup (fields and functionality including posting restrictions):https://learn.microsoft.com/en-us/dynamics365/business-central/ui-how-users-permissions

Deferrals in Business Central (and how they respect posting periods):https://learn.microsoft.com/en-us/dynamics365/business-central/finance-how-defer-revenue-expenses

This ensures users can only post deferrals in the periods defined in their User Setup.

The requirement is to configure the new customer creation process in Dynamics 365 Business Central. The goal is to make sure that when users quickly add new customers (for example, at the Cash & Carry desk), all required fields and correct defaults are consistently applied.

1. Configuration Worksheet (B)

The Configuration Worksheet is used in RapidStart Services to plan and manage setup data across tables.

It lets you map out which tables (e.g., Customers, Vendors, Items) you want to configure and load master data into.

For customer creation, this ensures that the Customer table and related setup tables are properly configured before using templates.

This acts as the foundation of the process: deciding what must be included in the customer creation workflow.

2. Configuration Template (C)

Configuration Templates define default values for new master data records (e.g., customers, vendors, items).

For example, when creating a new customer, the template can pre-fill fields like:

Posting groups

Payment terms

Customer source dimension

Responsibility center (if required)

This ensures consistency and reduces errors when users add new customers.

In this scenario, since the company wants fast and accurate customer creation, templates are essential.

Why not A (Responsibility center)?

Responsibility centers are used to manage operations by location, department, or profit center.

They are useful for reporting and segregation of transactions, but not mandatory for customer creation setup.

Why not D (Permissions)?

Permissions define who can create or modify customers.

While important for security, this is not part of the configuration process for ensuring consistent field population and defaults in customer creation.

Microsoft References

Set Up Configuration Packages and Templates (RapidStart Services)

Configuration Templates for Customers, Vendors, and Items

Customer Table Setup and Creation

Create security rules that will grant users required access → Permission Sets

Assign the predefined security rule sets to the requested users → User Card

Comprehensive Detailed Explanation

In Dynamics 365 Business Central, security is managed using Permission Sets and then assigned to users.

Create security rules → Permission Sets

A Permission Set defines which tables, reports, and pages a user can access (read, insert, modify, delete).

To restrict access to a particular set of customer data, you would configure a Permission Set that includes only the required tables/records, possibly combined with security filters.

Assign rules to users → User Card

After creating or selecting predefined permission sets, you assign them to users via the User Card page.

The User Card links Business Central users with the permissions they need to perform their job roles.

Other options not correct:

Profiles (Roles): These control the Role Center (UI experience) but not security.

Microsoft 365 admin center: Used for licensing and user account management but not Business Central data security.

Microsoft Learn References

Permissions and Permission Sets

Assign Permission Sets to Users

Manage Users and Permissions

Comprehensive Detailed Explanation

The requirement is to report profitability by business line (cash & carry vs. brokered). In Business Central, the way to achieve this is by creating a Global or Shortcut Dimension (for example, a dimension called Business Line) and ensuring that it is captured on every sales, purchase, and general ledger transaction.

Create a dimension → Value

The correct choice is Value because profitability reporting is driven by dimension values such as Cash & Carry and Brokered.

Combination, Default Priorities, and Account Type Default are used for control and automation of dimensions, not for the initial creation of reporting dimensions.

Comprehensive Detailed Explanation

The requirement is to ensure that every transaction posted to a customer account includes the Customer Source dimension (e.g., Cash & Carry, Brokered). This is achieved by creating and enforcing a mandatory dimension rule in Business Central.

Step 1: Create a dimension code to identify the customer source

First, define a Dimension Code such as Customer Source.

This will hold values like Cash & Carry and Brokered.

Dimensions are the foundation for all reporting segmentation in Business Central.

Step 2: Create dimension values for the customer source dimension code

After creating the dimension, define the specific Dimension Values (e.g., Cash & Carry, Brokered).

These represent the business lines the company wants to track.

Step 3: Add the Customer table

To enforce the dimension on customers, link the dimension to the Customer table.

This ensures that every transaction involving a customer account requires this dimension.

Step 4: Set the Value Posting to Code Mandatory

On the Default Dimensions page, set Value Posting = Code Mandatory for the Customer Source dimension.

This forces users (or the system) to provide a dimension value on every transaction involving customers.

Without this, users might skip dimension assignment, leading to incomplete reporting.

Step 5: Select the Dimension Value Code that is used for the customer source

Finally, assign the correct Dimension Value (Cash & Carry or Brokered) to each customer record.

This ensures automatic defaulting during transaction entry, reducing user errors and maintaining consistency.

Why not the other actions?

Chart of Accounts: Not needed here, since the requirement applies to customers, not G/L accounts.

Account Type Default Dimension: Useful for G/L accounts, but here we are applying it at the Customer table level.

Search icon, Customers: While this helps you navigate, it’s not a required setup step in the sequence.

Microsoft References

Work with Dimensions in Business Central

Set Up Default Dimensions for Customers

Dimension Value Posting Options

The scenario describes cash and carry sales, where customers pay immediately at the desk and sales invoices must be posted as paid in full at the time of sale. In Dynamics 365 Business Central, this is achieved by setting Payment Terms that indicate no delay between invoice date and due date.

Why D (Payment Terms = 0D)

The Payment Terms setup in Business Central allows you to define how the Due Date is calculated.

For cash and carry transactions, the invoice is due on the same day (zero days). Setting the Due Date Calculation to 0D ensures that the system always marks invoices as immediately due, reflecting the cash-and-carry business process.

This aligns with requirements: “Invoices must be posted at the cash and carry desk at the time of sale” and “Invoices already paid in full should not appear as outstanding on aging reports.”

Why not A (Payment Service)

Payment Services are used for integration with external services like PayPal or credit card gateways. Wide World Importers does not require a POS or online payment gateway—just simple cash handling at the desk.

Why not B (Direct Debit Mandate)

Direct Debit is used for recurring bank withdrawals (SEPA mandates, subscription-type payments). It does not apply to one-time, immediate cash payments.

Why not C (Payment Method = Bank Account)

While Payment Methods (e.g., Cash, Bank Transfer, Check) are also important for tracking how customers pay, the critical requirement in the scenario is ensuring the invoice is due immediately. That is achieved by Payment Terms = 0D, not by Payment Method alone.

Best Practice Setup in Business Central for Cash & Carry:

Payment Terms: 0D (ensures invoice due immediately).

Payment Method: Cash (ensures posted directly against the cash account).

Apply to invoices at posting: Invoices will automatically be shown as paid in full.

This combination ensures correct cash sales processing and eliminates the issue noted in the case study where invoices incorrectly appear in aging reports.

Microsoft References

Set Up Payment Terms in Business Central

Set Up Payment Methods in Business Central

Work with Payment Transactions

Buying groups require all invoices in a month to be due on the 20th of the following month (from the case study).

In BC, this is achieved by setting up Payment Terms = CM+20D (Current Month + 20 Days). Example: Invoice on Sept 5 → due Oct 20.

Payment terms are assigned directly to the customer card, not to the posting group or price group.

Option E (D20) would set due date 20 days after invoice date, which is incorrect.

Assigning to Customer Posting Group or Price Group does not control due dates.

Correct: A and C

In BC, invoices can be generated from:

Sales Order Invoicing (D): Post invoices directly from sales orders.

Combine Shipments (A): Consolidate multiple shipments into a single invoice (used for customers who require weekly or monthly invoices).

Get Shipment Lines from Sales Order (B) is incorrect — shipment lines are retrieved in warehouse processing, not for invoicing.

Sales Order Shipping (C) posts shipment only, not invoices.

Get Shipment Lines from Sales Invoice (E) is used for service scenarios but is not the standard sales invoicing process here.

Correct: A and D

This sequence makes sense because you first create the series itself, then define the lines (the actual numbers within the series), and finally define the relationships to link the series to the specific data table (like the Accounts table) where it will be used.

Sequence 2: Using a Configuration Package to Manage Data

This sequence focuses on using a configuration package to manage and update data, which might include fixing issues with existing accounts or importing new ones.

Create a configuration package.

Configure the Vendor Table on the configuration package.

Create the Data template.

While this sequence is plausible, it has a significant flaw: the prompt mentions "Accounts," but this sequence specifically mentions the Vendor Table. If we assume the "Vendor Table" is a placeholder for a generic data table like the Accounts table, the sequence makes sense. You create a package, configure it for a specific table, and then create a data template to import the data into that table.

Sequence 3: Resolving Issues by Defining the Number Series on the Configuration Template

This sequence focuses on resolving issues by directly modifying the configuration template within a configuration package.

Create a configuration package.

Create the Data template.

Define the No. Series on the configuration template.

This sequence is logical for a scenario where you're using a configuration package to manage both data and its associated number series. You first create the package, then create the data template (which is a core component of the package), and finally define the number series on that template to ensure the imported data uses the correct number sequencing.

The scenario mentions that the company needs to properly record received items before invoices arrive.

In Business Central, enabling Expected Cost Posting ensures that receipts (goods received but not invoiced) are reflected in both inventory and the general ledger.

This avoids the need for a manual accrual process (one of the issues in the case study) and satisfies the requirement to record accounting impact for items received but not yet invoiced.

Other options:

A. Standard Costing is unrelated (they need FIFO/average etc. for produce).

B. Automatic Cost Posting just posts automatically but doesn’t address received-not-invoiced.

D. Automatic Cost Adjustment = Always updates inventory values for costing, not expected costs.

Comprehensive Detailed Explanation

The requirement in the case study is that the company warehouses products as Case quantities but wants to expand capabilities by setting up all inventory in a quantity of Each. This means they need to configure Units of Measure (UoM) so that one item can be managed both by Case and by Each.

In Business Central:

Units of Measure Table – defines the available unit codes (e.g., EACH, CASE, BOX) with descriptions.

To use Case as a unit, you must first define it in the Units of Measure table.

Correct: D. Add a Code and Description to the Units of Measure table.

Item Units of Measure (Qty. per UoM) – links the item to multiple units of measure and specifies conversion (e.g., 1 Case = 10 Each).

For example, if a Case = 10 Each, you set Qty. per Unit of Measure = 10 for Case.

Correct: A. Set a Unit of Measure for case to a Qty. of 10.

Why the other options are incorrect:

B. Qty. per UoM = 1 is redundant (default Each already equals 1). It does not meet the requirement for Case-to-Each conversion.

C. Case with Qty. = 1 would make Case = Each, which is incorrect because Case must represent multiple units (10 Each).

Microsoft Learn References

Work with Units of Measure

Set Up Item Units of Measure

The case study specifies that:

Salespeople manage opportunities/quotes and release orders to the warehouse.

Warehouse staff fulfill orders and complete shipments.

Office/accounting staff are responsible for invoicing (separation of duties).

Therefore, the correct sequence for processing sales orders is:

Add External Document No. to Sales Order

An office employee enters this reference (often the customer’s PO number) before processing.

This step ensures traceability for auditors and aligns with required documentation.

Warehouse employee performs Post and Ship

The warehouse is responsible for picking, packing, and shipping items.

They must post the shipment in Business Central, creating a posted shipment record.

The warehouse does not invoice, since invoicing is the responsibility of the office.

Office employee performs Post and Invoice only

After confirmation that the order shipped, the office staff posts the invoice.

This matches the new division of duties and provides the financial document to the customer.

Why not the other options?

Warehouse performs Post, Ship, and Invoice: Incorrect because invoicing is not the warehouse’s responsibility.

Warehouse performs Post and Invoice only: Wrong, warehouse does not invoice.

Office employee performs Post, Ship, and Invoice: Wrong, because shipping is handled by warehouse.

Warehouse employee changes Posting Date: Not a standard requirement for fulfilling orders in this case.

Microsoft Learn References

Process Sales Orders

Post Shipments and Invoices Separately

Comprehensive Detailed Explanation

Deliver on a specific customer date

Salespeople must avoid promising inventory that is not available.

To check whether the requested delivery date can be met, the correct action is to review Item Availability by Periods.

This allows them to see when stock will be available across time periods, ensuring promised delivery dates are realistic.

Other options are less accurate:

Change the Requested Delivery Date → does not confirm if stock is available.

Check the Catalog on Sales Line → only for product lookup, not availability.

View the Location Code → shows location assignment, not time-phased availability.

Correct: View the Item Availability by Periods

Process quotes

Requirement: Salespeople must convert quotes to orders once they are finalized.

In Business Central, this is done by selecting Make Order from the Sales Quote.

Other options:

Make Invoice → bypasses order process, not applicable here.

Copy Document → creates a new document, not the required process.

Release → applies to orders but not to quotes-to-orders conversion.

Correct: Choose Make Order

Microsoft Learn References

Check Item Availability

Convert Sales Quotes to Orders

Create a Customer Discount Group

Create an Item Discount Group

Select the Item Discount Group for the Item

Comprehensive Detailed Explanation

To configure sales discounting in Dynamics 365 Business Central, you need to set up the relationship between customers and items so that the system can automatically apply the correct discounts during sales transactions. The process involves both customer grouping and item grouping.

1. Create a Customer Discount Group

This step defines which customers are eligible for group-based discounts (e.g., a retail chain, buying group, or brokers).

By creating a Customer Discount Group, you can later apply uniform discount rules across all customers belonging to that group, instead of configuring each customer individually.

2. Create an Item Discount Group

Next, you create Item Discount Groups to categorize items into discountable product lines (e.g., Olive Oils, Spices, Snacks).

This ensures that discount rules apply consistently across items in the same category, rather than having to define rules item by item.

3. Select the Item Discount Group for the Item

Finally, you link each relevant Item Card to the correct Item Discount Group.

This connection ensures that whenever a sales order/invoice is created for a customer belonging to a discount group and includes items in an item discount group, the system automatically applies the correct Sales Line Discounts.

Why not the other actions?

Define the Sales Invoice Discounts → Used for invoice-level discounts, but here the requirement is item/line-based discounting.

Define the Customer Special Sales Prices & Discounts → Used for customer-specific or promotional pricing, not for group-wide discount structures.

Configure Discount Posting in Sales & Receivable Setup → Relevant for accounting/reporting (whether discounts post separately) but not for setting up how discounts are determined and applied.

Define the Sales Line Discounts → This is the outcome of linking customer discount groups and item discount groups, but it requires the setup steps above first.

Microsoft References

Set Up Customer and Item Discount Groups

Work with Sales Line Discounts

Special Prices and Discounts in Business Central

Comprehensive Detailed Explanation

In Business Central, financial reporting is built from several components:

Row definition

Used to define which accounts or statistical accounts appear as rows in the financial report.

Since Headcount and Square Footage are statistical accounts (non-financial data tracked for reporting), they must be added via Row definition.

G/L account categories

Used to structure the income statement and balance sheet into financial categories such as Income, COGS, Assets, Liabilities.

The requirement states: “The financial report structure must map to account categories.”

Therefore, Income, Retail must be configured using G/L account categories.

Financial Report page

Used to assemble and present the report, combining row definitions, column definitions, and filters.

Accounts Receivables, Wholesale is a financial reporting output that must be displayed using the Financial Report page where the actual data is gathered.

Why not Column definition?

Column definitions control time periods (month, quarter, year, variance, etc.) but are not needed for these particular requirements.

Microsoft Learn references

Financial Reporting in Business Central

Set Up Row and Column Definitions

G/L Account Categories

The requirement is to resolve the order entry issue:

“Customers often reorder the same items with similar quantities. The system must be configured to ask the user if recurring lines should be added to sales orders.”

Business Central has Standard (Recurring) Sales Lines functionality to address this.

Configure standard sales lines → Add items and quantities

Standard sales lines define templates of frequently ordered items and their quantities.

When configuring these, you specify which items and quantities belong to the recurring order.

This resolves the need to avoid retyping common order combinations.

Add recurring sales lines to customers → Set insert on orders to Always Ask

On the Customer Card, you assign the standard sales lines and configure how they should be inserted when creating sales orders.

The setting Always Ask prompts the user each time an order is created for that customer, allowing them to choose whether to insert the recurring sales lines.

This satisfies the requirement to “ask the user if recurring lines should be added.”

Why not other options?

Add valid from and to dates – Useful for time-limited campaigns, but not mentioned in the requirement.

Set insert on quotes to Automatic – Applies to sales quotes, not orders. The requirement specifically concerns sales orders.

Microsoft Learn references

Set Up Standard Sales and Purchase Lines

Assign Standard Sales Lines to Customers

Comprehensive Detailed Explanation

The case study mentions reconciliation issues caused by manual entries being made directly into certain G/L accounts, which led to discrepancies between subledger balances (like customers, vendors, or inventory) and the General Ledger. To resolve this, Business Central allows you to restrict how accounts are posted.

Restrict use on → G/L Account Card

The most appropriate place to restrict usage of specific accounts (such as control accounts for A/R, A/P, or Inventory) is on the G/L Account Card.

Here, you can configure posting restrictions for each account individually (e.g., Accounts Receivable account should only be posted through the customer subledger, not by manual G/L journals).

Other options:

General Ledger Setup → Controls global accounting settings, not account-specific restrictions.

Sales & Receivable Setup → Defines control accounts but does not enforce restrictions.

Chart of Accounts → Displays accounts but restrictions are managed per account card.

Set value for → Direct posting

On the G/L Account Card, the field Direct Posting determines whether users can post manual entries directly into the account.

To prevent reconciliation issues, Direct Posting must be disabled (unchecked) for accounts controlled by subledgers (e.g., A/R, A/P, Inventory).

This ensures that postings only come from system-generated entries (like sales invoices, purchase invoices, or inventory adjustments) and not from manual journals that could break reconciliation.

Other options:

Reconciliation account → Relevant in SAP, not BC.

Check G/L account usage → Not a standard control in BC.

Gen. Posting Type → Defines how entries are posted (Sale, Purchase, Inventory), but does not enforce direct posting restrictions.

With this setup:

Reconciliation issues are avoided because control accounts cannot be posted to manually.

Users are guided to post through the proper subledger processes (sales, purchasing, inventory, etc.).

Financial integrity between subledgers and the G/L is maintained.

Microsoft References

G/L Account Card - Direct Posting Field

Prevent Direct Posting to Control Accounts

Chart of Accounts in Business Central

The requirement is:

“You need to train users on order processing requirements and how to process purchase invoices created from combined receipts.”

From the case study requirements:

“The company must be able to combine multiple purchase receipts into one vendor invoice.”

“Fully invoiced POs must not appear on the PO list page.”

“Posted vendor invoices must be reverted when damages are reported or a product is returned to the vendor.”

To meet these requirements:

Correct or cancel unpaid purchase invoices (B)

Users need to know how to reverse or correct vendor invoices that were created from combined purchase receipts if errors or issues occur.

Business Central provides Correct and Cancel actions for unpaid purchase invoices, ensuring proper reversal and audit trail.

Delete POs that are fully invoiced (C)

Once a PO has been fully invoiced (and all lines are closed), it should be deleted so it no longer appears in the purchase order list.

This keeps the purchase order list clean and ensures users don’t attempt to reuse completed POs.

Why not the others?

A. Create a purchase credit memo – This is used for vendor returns, not directly tied to the process of combined purchase receipts training.

D. Create recurring purchase lines – Used for repeated purchases of the same items (like monthly subscriptions or utilities), not relevant to combining receipts into one invoice.

Microsoft Learn references

Correct or Cancel Unpaid Purchase Invoices

Work with Purchase Orders

Combine Receipts on a Single Invoice

The correct solution to meet the company's order processing requirements involves two key components: the type of workflow to be created and the engine that will power it.

A. Create a purchase order approval workflow: This is a core component of most order processing systems. A purchase order approval workflow automates the process of submitting purchase orders for approval, sending notifications to the appropriate approvers, and ensuring that all orders comply with company policies. This is a common requirement to control spending and maintain an audit trail.

D. Use Power Automate as the engine for the workflow: Power Automate (formerly Microsoft Flow) is a powerful, cloud-based service that allows you to create automated workflows and connect various applications and services. It is the modern and highly versatile solution for creating complex and customized workflows that go beyond the basic capabilities of many built-in systems, including those in Business Central. While Business Central has a native workflow engine (as mentioned in option C), Power Automate is the recommended solution for more robust and integrated order processing workflows, especially when they need to interact with multiple systems or require advanced logic.

The requirement is:

“Customer revenue must be posted to separate general ledger (G/L) accounts based on customer type. The G/L account must have subcategories for wholesale and retail revenue.”

In Business Central, sales revenue posting is controlled by the General Posting Setup, which combines two posting groups:

General Business Posting Groups (A)

These represent the type of customer or vendor (for example, WHOLESALE or RETAIL).

They allow you to differentiate revenue by customer type.

General Product Posting Groups (C)

These represent the type of item or resource being sold (for example, FINISHED GOODS, SERVICES).

They allow you to map revenue to the correct accounts by product line or category.

The combination of General Business Posting Group + General Product Posting Group determines which Revenue G/L Account is used.

Why not the others?

B. Customer posting groups – Control AR control accounts, not revenue.

D. Bank account posting groups – Used for bank transactions, not revenue.

E. Inventory posting groups – Control inventory accounts and adjustments, not revenue.

Microsoft Learn references

Posting Groups in Business Central

Set Up General Posting Groups

FIFO is a widely used costing method where the oldest inventory items are sold first. This is a common and straightforward method for valuing inventory.

Automatic cost adjustment is a crucial setting for resolving inventory reconciliation issues. When this is enabled, Business Central automatically adjusts the cost of goods sold (COGS) to match the actual cost of the inventory. This helps prevent discrepancies between the inventory sub-ledger and the general ledger, ensuring that the financial data is accurate.

Comprehensive Detailed Explanation

The requirement: “You need to train users on how to process a special order for an established customer.”

From the case study:

“Special orders from new customers have a 25% prepayment. Established customers have only a 15% prepayment.”

Prepayments must be invoiced before the final invoice is posted.

Step-by-step process in Business Central:

Create a sales order

The user begins by creating a sales order for the special order.

Enter 15% in the Prepayment % field

Since this is for an established customer, the prepayment percentage is 15%.

The Prepayment % field on the sales order line or header controls how much must be prepaid before the order can be processed.

Enter the code for due on receipt in the prepayment payment terms code

Prepayments are typically due immediately. The code for “due on receipt” ensures that the prepayment invoice requires immediate payment.

Post and print the prepayment invoice

This generates the prepayment invoice for the customer and ensures that prepayment is received before delivery.

Why not “Enter the code for net 30 in the prepayment payment terms code”?

That applies to wholesale customer regular payment terms, not to prepayments. Prepayments are due immediately.

Why not 25%?

25% prepayment applies to new customers. For established customers, the requirement specifies 15%.

Microsoft Learn references

Set Up Prepayments

Process Sales Prepayments

Create Sales Orders with Prepayments

Based on the provided image, the correct values to select for the customer payment terms are the ones already highlighted.

Due Date Calculation for retail customer payment term:

Select the value 10.

Discount Date Calculation for wholesale customer payment term:

Select the value 10D.

Due Date Calculation for wholesale customer payment term:

Select the value 30D.

Due Date Calculation for wholesale customer payment term:

Select the value 15D.

When importing opening balances in Dynamics 365 Business Central, each type of balance requires a different component:

Item → Item journal

Opening inventory balances (quantities and values) are entered using the Item Journal.

This ensures that inventory valuation (costs and quantities) are properly reflected in item ledger entries.

Bank → Bank account reconciliation

Opening balances for bank accounts are usually posted through the Bank Account Reconciliation page.

This allows the opening balance to match the bank statement as of go-live.

Customer → General journal

Opening customer balances (outstanding receivables) are entered using the General Journal.

This allows you to enter each customer’s outstanding invoices and balances correctly.

Other notes:

Vendor opening balances would also be entered through the General Journal (but in this case, we only need Customer).

Using the correct component ensures the system creates the proper ledger entries in the sub-ledgers (Customer, Bank, Item).

Microsoft Learn References

Post Inventory Opening Balances

Post Bank Opening Balances

Post Customer and Vendor Opening Balances

The requirement is to match each integration requirement with the correct Microsoft integration solution in Business Central.

Customer email collaboration → Business Central Outlook add-inThe Business Central Outlook add-in allows users to create sales documents such as quotes, orders, or invoices directly from Outlook emails. This supports the requirement to create sales orders while collaborating with customers by email.

Sales team collaboration → Business Central app for TeamsThe Business Central app for Teams enables users to view, share, and even edit Business Central data such as customer records while working inside Microsoft Teams chat or channels. This aligns with the requirement to edit customer information while collaborating with the sales team in a group chat.

Customer notifications for sales campaign → Power AutomatePower Automate is designed for automating workflows such as sending notifications, approval requests, or bulk communications. To notify all customers at once about a sales campaign, Power Automate can integrate Business Central data with email or marketing tools.

Why not Word template?

Word templates are mainly used for document formatting and mail merges but do not handle automated notifications at scale. For distributing campaign notifications to multiple customers, Power Automate is the correct tool.

Microsoft Learn references

Business Central and Outlook integration

Use Business Central in Teams

Automate Business Central with Power Automate

The requirement is:

“You need to configure the system to post to the receivables account for wholesale customers.”

From the case study, the G/L posting accounts required are:

Retail Receivables = 13100

Wholesale Receivables = 13200

In Business Central:

Customer Posting Groups (B)

Customer Posting Groups are used to map customers to specific Receivables G/L accounts.

You typically create separate posting groups, e.g., "RETAIL" and "WHOLESALE," and assign them to customers based on type.

This ensures postings go to the correct control account.

Receivables account 13200 (D)

For wholesale customers, the posting group must be configured to point to 13200 (Wholesale Receivables).

Why not the others?

A. Receivables account 13100 – This is for retail customers, not wholesale.

C. General Posting Setup – This setup manages how transactions post based on combinations of General Business Posting Groups and General Product Posting Groups, but it does not control receivables accounts.

E. General Business Posting Groups – These are used for revenue, COGS, and VAT postings, not receivables control accounts.

Microsoft Learn references

Posting Groups in Business Central

Set Up Customer Posting Groups

Comprehensive Detailed Explanation

In Business Central, when a user changes departments or responsibilities, you may need to remove all personalizations tied to their profile. Personalizations include changes like hidden fields, rearranged page layouts, or custom filters applied by the user.

Steps:

Select User Settings and then select the related link

From the search bar, go to User Settings to manage user profiles and personalization.

Open the User Settings card

Select the user in question and open their User Settings Card to view configuration and personalization options.

Navigate to the User Page Personalizations page

On the card, there is a link to User Page Personalizations. This shows all the pages where the user has applied personalization.

Delete the personalization(s)

Either:

Select the line for the page personalization you want to remove and click Delete, or

Use Clear Personalized Pages to remove all at once.

This sequence ensures that all personalizations are cleared so that the user gets the standard profile setup when they log in again.

Microsoft Learn References

Personalizing Your Workspace

Administer Personalization and Profiles

Clear Personalized Pages

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

When using Configuration Packages (RapidStart) to import related data into Dynamics 365 Business Central, you must handle parent/child table relationships properly (e.g., Vendor → Vendor Bank Account).

Create a configuration package.

Start by creating a configuration package and adding the relevant tables (Vendor and Vendor Bank Account).

Define the Vendor table as a parent in Parent Table ID for VendorBankAccount table.

This ensures that the VendorBankAccount records link correctly to the Vendor records during import.

The parent-child relationship guarantees that the Vendor record exists before its related VendorBankAccount is inserted.

Import one Excel template that contains vendor and vendor bank account data.

Since the client provided a single Excel file with both vendors and vendor bank accounts, you load it into the configuration package.

Select Apply package on the header.

This applies the data into Business Central, creating Vendors and their linked Vendor Bank Accounts.

Not selected:

Define VendorBankAccount table as a parent… → Incorrect, because Vendor must be the parent, not the bank account.

Import two separate Excel files… → The scenario specifies a single Excel file, not multiple.

Microsoft Learn References

Use Configuration Packages to Import Data

RapidStart Services Overview

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

The scenario requires setting the default Purchase Order report. The solution incorrectly configures the Report Selection – Service page, which is used for Service Orders (service management module), not Purchase Orders. Therefore, it does not meet the requirement.

To configure the default report for purchase orders, you must update the Report Selection – Purchase page. Here, you set Usage = Order and update the Report ID to the new report object. This ensures the new custom purchase order report is used when printing purchase orders.

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 to restrict visibility of sales orders so that salespeople only see the documents they created. This is achieved by using Security Filters in Dynamics 365 Business Central.

Step 1: Select the Permission set and select Permissions.

First, you go to the Permission Sets assigned to the user. From there, you open the detailed Permissions for tables.

Step 2: Select the Security Filter column in Sales Header row.

Locate the Sales Header (Table 36) permission entry and edit its Security Filter. Security filters allow restricting access to certain records based on field values.

Step 3: Select the field number for the Salesperson code.

In the Sales Header, the Salesperson Code field determines which salesperson is responsible for the order. Choose this field as the filter basis.

Step 4: Enter the Salesperson code.

Assign the salesperson’s code (or variable for the team code). This ensures the user only sees orders with their own Salesperson Code in the Sales Header.

Why not the other options?

Enter Salesperson/Purchase Code in User Setup → This is used for default assignment of sales documents, not for restricting visibility.

Enter Sales Responsibility Center → Used to assign responsibility centers for transactions, not to limit access.

Thus, the only valid approach is configuring Security Filters on the Permission Set.

Microsoft Learn References

Set Up Permissions and Security Filters

Salesperson Codes in Business Central

Final Answer Sequence: