Microsoft MB-800 Microsoft Dynamics 365 Business Central Functional Consultant Exam Practice Test

The Accounts Receivable (AR) team often needs to correct payment applications when cash is applied incorrectly. In Business Central, unapplied entries can be corrected in several ways:

From the Customer Card, under Navigate > Ledger Entries, users can select entries and use the Unapply Entries action.

From the Customer Ledger Entries page, users can directly select a posted application and choose Unapply Entries.

The Detailed Customer Ledger Entries page is used for analysis and shows how entries were applied, but the actual “Unapply” action is not typically performed here (it is read-only in terms of correction).

“Apply entries” can be done from Detailed Customer Ledger Entries, but unapplies are performed from Customer or Customer Ledger Entries.

Correct answers: A and C

The AR users reported an issue about reconciling AR subledger to the G/L. In Business Central, subledger control accounts (like Accounts Receivable and Accounts Payable) must not be posted to directly; they should only be posted through transactions (invoices, payments).

If Direct Posting = Yes, users can post directly into AR or AP control accounts, which causes reconciliation issues.

To prevent this, you set Direct Posting = No on the G/L Account Card for control accounts.

Why not others:

A. Switch Blocked on the Customer Card → Blocks transactions but does not solve reconciliation issues.

B. Switch Direct Posting on the G/L Account Card to Yes → Makes the issue worse.

C. Switch Blocked on the G/L Account Card to Yes → Prevents all postings, even system ones, which is incorrect.

Correct answer: D. Switch Direct Posting on the G/L Account Card to No

The requirement is: “You need to configure retail store customer cards to track revenue by market.”

In Business Central, to track revenue by customer market (Retail, Veterinarian, Breeder), you configure default dimensions on the Customer Card.

Assign the dimension code → Market

The business wants to analyze revenue by Market (Retail, Veterinarian, Breeder).

Therefore, the dimension code must be Market.

Assign the dimension value code → Retail

For this specific setup, the customer is a retail store, so the dimension value must be Retail.

Select a value posting → Same code

To ensure that every posting for this customer always carries the same dimension value, use Same Code.

Other options:

Blank = no default dimension.

No code = optional dimension.

Code mandatory = requires entry but allows flexibility in values.

Since we want strict tracking by a fixed market (Retail), Same code is correct.

This ensures that every transaction posted for the customer will always have Market = Retail, enabling accurate revenue tracking.

Microsoft Learn references:

Work with Dimensions

Set Up Default Dimensions

Dimension Value Posting Options

The requirement is:

“When viewing G/L entries, the finance and accounting teams must be able to see debits and credits instead of a positive or negative amount.”

In Business Central, the General Ledger Entries page can display amounts in two different ways:

Amount (positive/negative): This is the default display of entry amounts as signed numbers.

Debit Amount / Credit Amount (separate fields): This allows accounting teams to clearly see whether an entry is a debit or a credit, consistent with traditional accounting presentation.

The configuration option "Debit/Credit" is specifically provided to control this display. By enabling this setting, amounts are shown in two columns (Debit Amount and Credit Amount) instead of one column with positive/negative signs.

Why not the other options?

B. Show Amounts – This relates to toggling whether amounts are displayed on certain ledger pages but does not change the format to Debit/Credit.

C. Check G/L Account Usage – This is a validation function for checking how accounts are used, not related to entry display format.

D. G/L Account Card – Used to configure properties of individual G/L accounts (posting type, direct posting, account category), not the general display mode for entries.

Therefore, the correct configuration to meet the requirement is Debit/Credit.

Microsoft Learn references

Work with General Ledger Entries – explains how G/L entries can be displayed and filtered.

Business Central General Ledger Setup – includes configuration options such as showing amounts as debit/credit.

General Ledger Overview in Business Central – details on how entries are posted and viewed.

The scenario requires configuring Business Central to meet sales department needs:

Sales discounts

Requirement: “Discounts must post to a unique general ledger (G/L) account.”

In Business Central, this is managed through the Discount Posting field in Sales & Receivables Setup.

When enabled, the system posts line discounts and invoice discounts to dedicated G/L accounts instead of combining them with revenue.

This ensures transparency and compliance with accounting’s requirement to track discounts separately.

Correct match: Sales discounts → Discount posting

Credit limits

Requirement: “The sales department should receive a warning when entering the order if a customer is over their credit limit.”

In Business Central, this behavior is controlled by Credit Warnings in the Sales & Receivables Setup.

This setup defines whether to warn the user, block posting, or allow posting when the customer’s balance exceeds the defined credit limit.

Correct match: Credit limits → Credit warnings

Why not the other options?

Calc. inv. discount – Controls whether invoice discounts are automatically calculated, but not relevant here.

Stockout warnings – Alerts when an item has insufficient inventory; unrelated to discounts or credit limits.

Microsoft Learn references

Set Up Sales and Receivables

Discount Posting setup – posting discounts to G/L accounts.

Credit Warnings setup – warnings and blocking options.

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

Query successful

Sales Invoice Correction

Based on the scenarios, here is the correct action for each:

Scenario 1: Use this action when the posted invoice has not been paid and the original invoice was posted from a sales order.

Action: Correct

The Correct action is specifically designed for this scenario. It automatically creates a new sales order, reverses the original posted invoice, and copies the original lines to the new order. The new sales order is then ready for editing, allowing you to make corrections and post it again.

Scenario 2: Use this action when the posted invoice has not been paid and the original invoice was not posted from a sales order.

Action: Cancel

The Cancel action is used when the invoice wasn't created from a sales order. It creates a credit memo to fully reverse the posted invoice. This effectively cancels the invoice without needing to go through a new sales order process, as no original sales order exists.

Scenario 3: Use this action when the posted invoice has been paid and warehouse documents are not required.

Action: Create corrective credit memo

The Create corrective credit memo action is the appropriate choice when the invoice has already been paid. Since the payment has been applied, you can't simply "correct" or "cancel" the invoice directly. Instead, you create a credit memo that can then be applied against the payment, effectively reversing the transaction. This action is also used when warehouse documents are not necessary, as a separate sales return order with warehouse processes is not required.

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

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.

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

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

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

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

In Dynamics 365 Business Central, date formulas define due dates, discount dates, and payment terms. The requirement states: "standard vendor payments on the seventh day of the next month."

1M+7D → Adds one month to the document date, then 7 days, resulting in the 7th day of the following month. This exactly matches the requirement.

37D → Simply adds 37 calendar days, which does not always equal the 7th of the next month.

1M+6D → Results in the 6th of the following month, which is incorrect.

CM+7D → Refers to the current month plus 7 days, which would not push into the next month.

Thus, the correct date formula is 1M+7D.

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

Processing a Purchase Order in Business Central follows a standard sequence:

Add a vendor – Every purchase order must begin with selecting a vendor. This establishes the vendor card defaults (e.g., currency, lead times, payment terms).

Add a Purchaser Code – The Purchaser Code identifies the buyer responsible for the order and is often used in approval workflows and reporting.

Add Items, including Quantity, to the lines – On the lines of the purchase order, specify which items/services you are buying and the quantity to be received.

Change the Purchase Order to a Status of Released – Draft orders are “Open.” Before posting, you must change to “Released.” This signals that the document is ready for posting (and may also trigger approval processes if workflows are enabled).

Post the Purchase Order –

Post and Receive = records the goods receipt into inventory, but does not create a purchase invoice yet.

Post and Invoice = performs both receipt and invoice posting in one step (commonly used when receiving and invoicing happen at the same time).

Other options not in the sequence:

Run a Test Report – Optional, to preview the expected posting entries; not mandatory in the flow.

Create a warehouse receipt – Only required if using advanced warehouse management (directed put-away & pick), not in the base purchase order flow.

Microsoft Learn References

Create Purchase Orders:

Posting Purchase Orders (Receive/Invoice):

Purchase Order Lifecycle:

Thus, the correct ordered steps:

In Dynamics 365 Business Central, every item must have a Base Unit of Measure. This is typically the smallest unit in which you transact or track inventory.

The requirement states the company “refers to the items as pieces,” so Pieces must be the base unit of measure.

A Box = 12 pieces, a Pallet = 144 pieces.

When creating item units of measure, you set Quantity per Unit of Measure relative to the base unit.

Base Unit: Piece (Qty. per Unit = 1)

Box: Qty. per Unit = 12

Pallet: Qty. per Unit = 144

This way, Business Central can automatically convert quantities when selling in boxes, pallets, or pieces.

Why not others?

A: Incorrect → Box cannot be the base if pieces are the standard reference.

B: Incorrect → Pallet as base unit with pieces as 0.0069 is not practical and makes transactions confusing.

D: Incorrect → Pallet as base unit with Box as fraction (0.08333) again introduces complexity.

In Dynamics 365 Business Central, the Best Price feature ensures that the system automatically applies the most advantageous price or discount for the customer based on various price and discount configurations.

The three components that are part of this calculation are:

Sales Line Discounts

Allow you to configure percentage discounts on sales lines, based on conditions like minimum quantity, currency, customer, or customer group.

These are evaluated in the best price calculation.

Discount Groups

Used to group together multiple items, customers, or vendors for applying collective discounts.

Helps ensure the correct discount group conditions are considered in the best price feature.

Special Prices

Allow configuration of special prices for specific customers, customer groups, or items.

The system evaluates these against line discounts and discount groups to pick the best applicable price.

Why not the others:

A. Unit cost on items → Used for purchase and costing, not for sales best price calculation.

E. Unit prices on items → The base unit price on the item card is only a fallback/default, not part of the best price algorithm; best price comes from Sales Prices, Discounts, and Groups.

In Business Central, the Payment Terms calculation uses the Document Date (not Posting Date or Order Date). The system takes the Document Date and applies the due date calculation formula defined in the Payment Terms.

Order Date is primarily for purchase/sales documents scheduling.

Posting Date drives G/L posting date.

Due Date is the result of the calculation, not the input.

The company requires multiple number series for Raw Materials, WIP, and Finished Goods, with unique prefixes, selectable at item creation, and automatic assignment. In Dynamics 365 Business Central, number series are configured in a structured order:

Create a number series.

Define unique number series for each item type (e.g., RM-#### for Raw Materials, WIP-####, FG-####).

Specify starting/ending numbers and format.

Create relationships between the number series.

Relationships allow the user to select among multiple number series when creating an item.

This ensures that at item creation, the correct prefix (series) can be chosen.

Enable the ability to use default numbers.

On the number series setup, set Default Nos. = Yes to enable automatic numbering when a new item is created.

Set the default number series on the Inventory Setup page.

Finally, assign the relevant number series as the default for items in Inventory Setup.

This ensures automatic numbering, but still allows selection of other related series when needed.

This sequence satisfies all requirements:

Unique series per item type → Done in step 1.

Selectable at creation → Handled in step 2.

Automatic number assignment → Steps 3 and 4 ensure automation with flexibility.

Microsoft Learn References

Create Number Series

Use Number Series in Business Central

Inventory Setup

Ship only from sales orders → Prohibited

Force invoice with receipts (purchase orders) → Mandatory

Ship or ship & invoice (inventory pick) → Allowed

Comprehensive Detailed Explanation

In Dynamics 365 Business Central, the Invoice Posting Policy controls whether shipments/receipts and invoices must be posted together or can be separated:

Allow the user to ship only from sales orders → Prohibited

If the invoice posting policy is Prohibited, the system will not allow posting invoices separately.

Users can only post shipments (sales orders) without posting invoices.

Force the user to post invoices together with receipts for purchase orders → Mandatory

If the invoice posting policy is set to Mandatory, the system requires that receipts and invoices are posted at the same time.

This ensures purchase order receipts are always matched to invoices.

Enable the user to ship or ship and invoice on inventory pick → Allowed

If the invoice posting policy is set to Allowed, users have the flexibility to post either:

Shipments/receipts separately, or

Shipment + Invoice together.

Other notes:

Mandatory enforces combined posting.

Prohibited prevents invoice posting (shipment-only scenario).

Allowed gives flexibility to the user.

Microsoft Learn Reference

About Invoice Posting Policy

When a company has limited funds in Dynamics 365 Business Central and must decide which vendors to pay first, the Vendor Priority functionality in the Suggest Vendor Payments batch job is used.

Here’s how it works:

Set Vendor Priority on the Vendor Card

On each vendor card, you assign a Vendor Priority value.

The lowest number (1) is the highest priority, except for zero, which means no priority defined.

To manage multiple purchase prices for the same item depending on the vendor, you can configure:

Item Card (B): At the item level, you can define vendor-specific purchase prices and assign conditions such as starting date, minimum quantity, currency, etc.

Vendor Card (E): Vendor-specific purchase prices can also be linked, enabling the system to pull correct pricing when creating purchase orders.

The requirement is to:

Import a series of payments from a bank account (file from bank, e.g., CAMT.053, MT940, BAI2, or CSV).

Automatically match the imported payments against customer/vendor ledger entries already in Business Central.

Apply those matched entries automatically, while allowing review and manual matching for exceptions.

This is exactly what the Payment Reconciliation Journal is designed for:

The Payment Reconciliation Journal page lets you import bank statement files or manually enter bank transactions.

The system then attempts to auto-apply payments to open customer/vendor ledger entries using match rules (based on amount, document number, or text).

Any unmatched payments can be handled manually or left open for investigation.

Once complete, posting the journal reconciles the bank account and applies the payments.

Why not the other options?

A. Payment Application Rules – These define how automatic application should work (match tolerance, priorities), but they are not the form to process the payments themselves.

B. Payment Services – Used for online payment processing (e.g., PayPal, WorldPay), not for bank file imports.

D. Payment Registration – A manual process to register payments (e.g., marking invoices as paid when receiving cash or checks at the counter). It does not support bank file imports or auto-matching.

Thus, the correct form is Payment Reconciliation Journal.

Microsoft Learn References

Apply Customer Payments Using Payment Reconciliation Journals:

Import Bank Statements and Match Automatically:

Payment Registration vs Payment Reconciliation:

Correct Answer: C. Payment Reconciliation Journal

When a new user is added to Microsoft 365, the steps to provision them in Dynamics 365 Business Central are:

Get New Users from Microsoft 365 / Update Users from Microsoft 365

Synchronizes new Azure AD/Microsoft 365 users into Business Central.

Select the user from the user list

The user will appear in the Business Central user list after synchronization.

Create a user group

Since existing user groups do not have the required permission sets, a new user group must be created with the appropriate permission sets.

Assign the user group to the user

This links the user to the new user group, thereby granting the proper permissions.

Assign the company to the user

Finally, specify which company (database/company within Business Central) the user can access.

Microsoft Learn References

Manage Users and Permissions

Create and Manage User Groups

Add Users from Microsoft 365

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

The scenario requires that partially shipped and invoiced sales orders that will not be fulfilled should not clutter the Open Sales Order list. However, management still wants visibility for reporting on ordered vs. delivered quantities.

This is achieved by archiving sales orders before deletion, and then adjusting the order properly. Let’s break down the steps:

Enable Archive Sales Orders in Sales & Receivables Setup.

This ensures that every time you delete or modify sales orders, a copy is archived. Archived orders provide a historical record for reporting and reconciliation.

Step-by-Step Explanation

Set up inventory periods: Before performing any inventory costing adjustments, you must first define the period for which the adjustments will be made. This step is a prerequisite for most inventory management tasks, ensuring that the work is contained within a specific timeframe.

Run the Adjust Cost – Item Entries batch job: This is the core action for adjusting inventory costs. This batch job automatically recalculates and updates the costs of all inventory items to reflect the most current and accurate valuation. It's a critical step for systems that use costing methods like average cost or FIFO, which might require periodic re-evaluation.

Run Post Inventory Cost to G/L: Once the inventory item costs have been adjusted, the next logical step is to post these updated values to the general ledger (G/L). This action synchronizes the inventory sub-ledger with the financial records, ensuring that the company's financial statements accurately reflect the true value of its inventory.

Close the inventory period: After all adjustments are made and costs are posted to the G/L, you must close the inventory period. Closing the period prevents any new entries or changes from affecting the adjusted costs, thereby maintaining the integrity of the financial data and satisfying audit and compliance requirements.

Comprehensive Detailed Explanation

The company’s reporting requirements are:

They need to analyze which customers are buying which items.

They need to analyze which salespeople are selling in which regions.

They also need consistent reporting for Customer Groups, Item Groups, Salesperson, and Region.

In Business Central, dimensions are the mechanism to capture these classifications (customer groups, item groups, salesperson, region). To configure reporting dimensions properly, the following steps are required:

Set up dimensions

Before using any dimensions, you must define them in the Dimensions page. This is where new entries such as Customer Group, Item Group, Salesperson, and Region are created.

Correct action: Create a new entry on Dimensions.

Configure global dimensions

Business Central allows two global dimensions that become available on all transaction lines and entries. These are the most used reporting breakdowns.

Since the company must always report sales by customer and item, these should be set as global dimensions.

Correct action: Change global dimensions on General Ledger Setup.

Configure shortcut dimensions

Shortcut dimensions (up to 8) are additional reporting dimensions that can be made available for entry on journals, documents, and transactions. These are perfect for Region and Salesperson requirements.

Correct action: Choose a shortcut dimension code on General Ledger Setup.

This setup ensures reporting can directly answer the business questions in financial results and enable analysis across Customer Groups, Item Groups, Salespeople, and Regions.

Microsoft Learn References

Work with Dimensions

Set Up Dimensions

General Ledger Setup – Global and Shortcut Dimensions

Analysis by Dimensions

Requirement: Each salesperson must be assigned to only one region, and combinations must be enforced automatically to avoid inconsistent commission reporting.

In Business Central, this is achieved by defining a Dimension Combination rule between the Salesperson dimension and the Region dimension.

Setting it to Blocked prevents users from posting with an invalid salesperson-region combination.

Other options:

A. Limited restricts only dimension values on certain accounts.

B. Default Dimension Priorities controls which default dimension wins, but does not enforce uniqueness.

D. Default Dimensions on Customer Cards helps with defaults, but doesn’t prevent invalid combos.

The case study states:

The company often receives a higher quantity of produce items than ordered because vendors allow for spoilage/damage during transit.

The company wants to allow over-receipt only for produce but not for non-produce items.

In Dynamics 365 Business Central, this requirement is handled by Over-Receipt Codes:

You define a code with a tolerance percentage (e.g., 5% or 10%).

The code can be assigned to specific items (e.g., produce) or vendors.

This allows receiving slightly more than ordered, while blocking over-receipt for other items.

Why not the other options?

B. Payment Tolerance % → relates to differences in payment amounts (e.g., customer underpaying by a few cents), not receiving inventory.

C. Default Deferral Template → used to defer revenue/expense recognition over time, unrelated to item receipt.

D. Dampener Quantity → used in demand planning/MRP to avoid unnecessary changes to supply orders; not for receiving more items.

So the correct configuration is Over-Receipt Code with Tolerance %.

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

Requirement: Invoices must be automatically emailed to customers using a fixed template.

Solution:

A. Set Email to Yes (Use Default Settings) → ensures invoices are sent automatically without prompting.

E. Apply Office Server Settings to the SMTP Mail Setup → configures the company’s mail server (SMTP/Office 365) so that emails are sent.

F. Assign a Document Sending Profile to the Customer where Email is set to Yes → links customers to the correct sending method (Email with fixed template).

Other options:

B. Allow Sender Substitution is optional, not required.

C. Prompt for Settings requires manual action (not automatic).

D. Assigning “Email = No” contradicts the requirement.

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

Query successful

Based on the image, the correct sequence of actions to configure a purchase order process is:

Add a vendor

Add a Purchaser Code

Add Items, including Quantity, to the lines

Change the Purchase Order to a Status of Released

This sequence follows the logical flow of creating and finalizing a purchase order for an audit trail:

Add a vendor: A purchase order must be linked to a specific supplier (vendor).

Add a Purchaser Code: This identifies who is creating the order, which is crucial for accountability and audit purposes.

Add Items, including Quantity, to the lines: You must specify what is being purchased and in what quantity.

Change the Purchase Order to a Status of Released: Releasing the purchase order locks it from further changes and makes it ready for processing, fulfilling the auditor's requirement for a finalized, traceable document.

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

Comprehensive Detailed Explanation

The company requires:

Preset vendor invoice discounts applied automatically.

Automatic calculation of invoice-level discounts.

Ability to keep a copy of purchase orders for historical reference (for vendor contract negotiations).

Let’s break each down:

1. Configure the preset invoice level discounts

Vendors give regular discounts at the invoice level.

In Business Central, you configure this in Vendor Invoice Discounts.

You set a discount % (e.g., 5%, 10%) for the vendor.

Correct action: Set Discount % on Vend. Invoice Discount

2. Configure the automatic invoice level discounts calculation

After defining vendor invoice discounts, you must enable automatic calculation.

This is controlled in Purchase & Payables Setup by setting Calc. Inv. Discount = Yes.

Correct action: Set Calc. Inv. Discount to Yes on Purchase & Payables Setup

3. Configure purchase order history

The requirement is to be able to “see a copy of the completed purchase order in the system” for reference during vendor contract negotiations.

Business Central provides this via the Archive Orders function.

When archiving is enabled, every time an order is changed or posted, the system retains a copy.

Correct action: Set Archive Orders to Yes

Microsoft Learn References

Set Up Vendor Invoice Discounts

Set Up Purchases and Payables

Archive Sales and Purchase Orders

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

Set up a new fiscal year

In Business Central, fiscal years are created in the Accounting Periods page.

To start a new fiscal year, you must Select Create Year, which generates the periods for the new fiscal year.

Other options like Close Year or Fiscal Year Balance are for closing or balancing, not for initial setup.Correct: Select Create Year

Define the fiscal year start date

The case study specifies that the company’s fiscal year starts on June 1.

Therefore, when creating the new fiscal year, you must ensure the first period begins on June 1.

The correct action is Check New Fiscal Year for June 1.Correct: Check New Fiscal Year for June 1

Restrict posting

The business requirement is:

Restrict users to post only in the current month.

Only certain accounting users may have broader posting permissions.

In General Ledger Setup, the Allow Posting From and Allow Posting To fields control the global posting date range.

For user-specific restrictions or exceptions, User Setup allows overriding posting ranges for individual users.

Since the requirement is to restrict all users generally, the best action is:In General Ledger Setup, set the Allow Posting From and Allow Posting To options to current dates.Correct: In General Ledger Setup, set the Allow Posting From and Allow Posting To options to current dates

Microsoft Learn References

Accounting Periods (Create and Close Fiscal Years)

General Ledger Setup – Allow Posting From/To

User Setup and Posting Date Permissions

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