nerdexam
Microsoft

MB-500 · Question #314

Drag and Drop Question A company uses Dynamics 365 Commerce for sales and distribution operations. The following reporting changes are required based on feedback from user acceptance testing: - Add…

The correct answer is Microsoft 365; Visual Studio. Explanation: Dynamics 365 Commerce Development Tools Requirement 1: Add a field to a business document template → Microsoft 365 Business document templates in Dynamics 365 are managed via the Business document management feature (part of the Electronic Reporting framework)…

Implement reporting

Question

Drag and Drop Question A company uses Dynamics 365 Commerce for sales and distribution operations. The following reporting changes are required based on feedback from user acceptance testing: - Add a field to a business document template. - Adjust the location of the customer address on an SSRS report. You need to implement the changes. Which development tools should you use? To answer, drag the appropriate development tools to the correct requirements. Each development tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:

Exhibit

MB-500 question #314 exhibit

Answer Area

Drag items

Power BIVisual StudioMicrosoft 365

Correct arrangement

  • Microsoft 365
  • Visual Studio

Explanation

Explanation: Dynamics 365 Commerce Development Tools

Requirement 1: Add a field to a business document template → Microsoft 365

Business document templates in Dynamics 365 are managed via the Business document management feature (part of the Electronic Reporting framework). These templates are Excel-based files that users can open and edit directly through the Microsoft 365 (Office) integration - specifically Excel. No code or IDE is required. The workflow is:

  1. Navigate to Business document management in D365
  2. Open the template - it launches in Excel via Microsoft 365
  3. Add/modify fields, save, and publish back

Why not Visual Studio here? Business document templates are not code artifacts; they are configuration-based Excel files. Modifying them in VS would be the wrong tool for the job.

Requirement 2: Adjust customer address location on an SSRS report → Visual Studio

SSRS (SQL Server Reporting Services) reports in Dynamics 365 Finance/Commerce are X++ development artifacts - they consist of report designs, data providers, and contracts deployed to the AOS. To change the layout (e.g., move a field's position), you must:

  1. Open the SSRS report design in Visual Studio (with the D365 developer tools extension)
  2. Use the Report Designer to reposition the control
  3. Build and deploy the report to the environment

This requires direct code/designer-level access only available in VS.

Why Power BI is Not Used

Power BI is for analytical dashboards and self-service BI - it is not used to modify existing operational SSRS reports or business document templates. A common mistake is selecting Power BI whenever "reporting" is mentioned, but Power BI does not interact with SSRS report layouts or D365 document templates.

Summary Table

RequirementToolReason
Add field to business document templateMicrosoft 365Templates are Excel-based; edited via Office integration
Adjust address location on SSRS reportVisual StudioSSRS layouts are code artifacts requiring the D365 developer toolset

Topics

#SSRS reports#business document templates#Visual Studio#reporting tools

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full MB-500 Practice