nerdexam
Microsoft

MB-800 · Question #272

Case Study 4 - Fabrikam, Inc Background Fabrikam, Inc., is a manufacturer of products for the gift industry. The company plans to implement Business Central as its new enterprise resource planning (ER

The correct answer is Row definition; Column definition; Row definition; G/L account categories. Business Central Financial Reports: Drag-and-Drop Explanation Background: How Financial Reports Are Built in Business Central A Financial Report in Business Central is assembled from three components: Row Definition - controls what lines/rows appear (accounts, totals, description

Financial management

Question

Case Study 4 - Fabrikam, Inc Background Fabrikam, Inc., is a manufacturer of products for the gift industry. The company plans to implement Business Central as its new enterprise resource planning (ERP) system. The company sells to two types of customers: wholesale and retail. Retail customers order at special events and online. Wholesale customers send in orders by email. Current Environment Order processing - The company uses a purchase order (PO) workflow for any PO over $500. - The system has been fully configured for sales order prepayments and will check for a prepayment invoice at posting. - Customers can special order products with a prepayment that is due on receipt. Invoicing - Wholesale customer payment terms are net 30, with a 2% discount if paid within 10 days. - Retail customer payment terms are payable on receipt or shipment. Reporting - The company uses headcount (number of employees) and square footage for statistical accounts. Integrations The company currently uses Outlook, Excel, Word, and Teams to communicate internally and externally with customers and vendors. Requirements Order processing - The company must be able to combine multiple purchase receipts into one vendor invoice. - Posted vendor invoices must be reverted when damages are reported or a product is returned to the vendor. - Fully invoiced POs must not appear on the PO list page. - Customer prepayments vary based on customer relationship. Special orders from new customers have a 25% prepayment. Established customers have only a 15% prepayment. - The company must be able to approve POs by email without opening Business Central. - 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. Invoicing - 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. - Accounts receivable must be posted to separate G/L accounts based on customer type. The G/L account must have subcategories for wholesale and retail accounts receivable. - Currently, inventory is sold at a cost based on purchase and sales over a period. Reporting - Financial reports must include statistical accounts. - The financial report structure must map to account categories. Integrations The company requires the following integration capabilities: - Create sales orders while collaborating with customers by email. - Edit customer information while messaging the sales team in a group chat. - Communicate a brochure to all customers at once about a sales campaign. General ledger posting accounts The company requires the following G/L posting accounts: - Retail Receivables = 13100 - Wholesale Receivables = 13200 - Payment Discount = 54800 - Retail Sales = 44100 - Wholesale Sales = 44200 - Sales Prepayments = 22160 Issues - Order entry takes too long for wholesale customers. - Vendors ship partial orders but send one monthly invoice. The company is unable to associate one invoice with multiple POs in the current environment. - Inventory reconciliation was difficult in the company's old system because it allowed users to sell more inventory than was physically available. - Users must log in to the system to provide workflow approvals. Drag and Drop Question You need to create financial reports per company reporting requirements. Which report configuration should you use to add the report descriptions to financial reports? To answer, move the appropriate report configurations to the correct report descriptions. You may use each report configuration once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:

Exhibit

MB-800 question #272 exhibit

Answer Area

Drag items

Row definitionColumn definitionFinancial Report pageG/L account categories

Correct arrangement

  • Row definition
  • Column definition
  • Row definition
  • G/L account categories

Explanation

Business Central Financial Reports: Drag-and-Drop Explanation

Background: How Financial Reports Are Built in Business Central

A Financial Report in Business Central is assembled from three components:

  • Row Definition - controls what lines/rows appear (accounts, totals, descriptions per row)
  • Column Definition - controls what columns appear (periods, budget vs. actual, etc.)
  • G/L Account Categories - a chart of accounts taxonomy that can auto-generate row structure

The Correct Arrangement (Slot by Slot)

The question presents 4 report descriptions that need a configuration matched to them. Based on the answers, the descriptions likely map as follows:


Slot 1 → Row Definition

Why: Row definitions contain the individual line-level descriptions. Each row in a financial report has a description field (e.g., "Revenue," "Total Assets") defined directly in the Row Definition setup. This is where you manually type or generate the label for each row.

Fabrikam relevance: Statistical accounts (headcount, square footage) must be added as rows - this is done in the Row Definition.


Slot 2 → Column Definition

Why: Column definitions define what each column shows - a specific period, prior year, budget, variance, etc. Each column also has a header/description (e.g., "Current Period," "YTD"). Column descriptions are configured inside the Column Definition layout.

Common mistake: Confusing column headers with row descriptions. Rows = what you're measuring; Columns = over what time/comparison frame.


Slot 3 → Row Definition (used again)

Why: Multiple descriptions in a report can trace back to Row Definition. For example, both individual account lines and subtotal/formula rows have their descriptions defined there. The question notes items can be used more than once - this is a prime case.

Fabrikam relevance: Both the retail revenue lines and wholesale revenue lines (44100, 44200) need labeled rows - all defined in Row Definition.


Slot 4 → G/L Account Categories

Why: The case study explicitly states: "The financial report structure must map to account categories." In Business Central, G/L Account Categories (found under the Chart of Accounts) allow you to assign accounts to categories/subcategories (e.g., Income → Retail Revenue). You can then generate a Row Definition from these categories, meaning the financial report structure inherits the category hierarchy.

Fabrikam relevance: The requirement for subcategories under wholesale/retail revenue and receivables (13100, 13200, 44100, 44200) is fulfilled by setting up G/L Account Categories with subcategories, which then drives the report structure.

Common mistake: Thinking "Financial Report page" handles this - the Financial Report page only links a Row Definition and Column Definition together; it does not define the structural mapping itself.


Summary Table

SlotConfigurationCore Reason
1Row DefinitionDefines per-row labels and account references
2Column DefinitionDefines column headers and period/comparison types
3Row DefinitionReused - multiple row descriptions come from here
4G/L Account CategoriesMaps report structure to account category hierarchy

Key Misconception to Avoid

The Financial Report page itself is where you name the report and link the row and column definitions - but it does not add descriptions to the report content. It's the container, not the content. Many candidates mistakenly assign description-related tasks to the Financial Report page.

Topics

#financial reports#report configuration#account categories#statistical accounts

Community Discussion

No community discussion yet for this question.

Full MB-800 Practice