Describe Dynamics 365 Supply Chain Management →hardMultiple ChoiceObjective-mapped

MB-920 Describe Dynamics 365 Supply Chain Management Practice Question

Exhibit

{
  "InventoryValueReport": {
    "Query": "SELECT ItemId, SUM(PhysicalInventory) as TotalQty, SUM(PhysicalCostAmount) as TotalCost FROM InventSum WHERE Closed = 0 GROUP BY ItemId",
    "Filters": [
      {"Field": "SiteId", "Value": "1"}
    ]
  }
}

Refer to the exhibit. An administrator is reviewing an inventory value report configuration in Dynamics 365 Supply Chain Management. The report shows total quantities and costs for items that are not closed. A user complains that the report does not include items from site 2. What is the most likely cause?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

The report is filtered to site 1 only.

The most likely cause is that the report is filtered to site 1 only, as indicated by the exhibit showing a filter on SiteId = 1. This restricts the report to items from site 1, excluding site 2. Option A is incorrect because the report uses InventSum, not InventTrans, but that is not the reason for missing site 2 items. Option C is incorrect because financial dimensions are not relevant to the site filter. Option D is incorrect because the report includes items that are not closed (Closed = 0), so that does not exclude site 2 items; the site filter is the issue.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
The report uses InventTrans instead of InventSum.
Why it's wrong here
The query uses InventSum, which is correct for inventory value; the issue is the site filter.
✓
The report is filtered to site 1 only.
Why this is correct
The exhibit shows a filter on SiteId = 1, limiting the report to site 1.
✗
The report does not include financial dimensions.
Why it's wrong here
The report does not include financial dimensions, but that would not cause site 2 items to be missing; the site filter is the issue.
✗
The report excludes closed inventory transactions.
Why it's wrong here
Closed = 0 excludes closed inventory, but this is a condition, not the cause for missing site 2 items.

Go deeper

MB-920 Describe Dynamics 365 Supply Chain Management Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question