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

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.

Regular price: $20.00

Buying group discount: $18.00

Autumn promotion price: $19.00

Overstock special: 15% off regular price ($20 × 0.85 = $17.00)

However, the case study requires the system to always give the lowest available price.

Comparison of all active prices:

Regular = $20.00

Buying group = $18.00

Autumn promotion = $19.00

Overstock 15% discount = $17.00

Lowest available = $17.00. But since the customer belongs to a buying group and it’s also an overstock day, the system applies stacking rules: the overstock discount applies on top of buying group price.

$18.00 × 0.85 = $15.30.

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

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

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

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.

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.

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

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

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.