Views:

Applies to Product - Dynamics 365 Supply Chain Management


What’s happening?


The Cost Explorer does not total correctly when accessed from Inventory Transactions, leading to discrepancies between the displayed cost and the sum of the source items feeding into it.


 Reason:


This arises from a miscalculation in the Cost Explorer transaction, where the cost calculation does not align with the total cost of the products. Specifically, it has been observed that the route may show the quantity instead of the cost.


Resolution:

  1. Validate this in the Cost Explorer by checking if the cost calculation corresponds to the total cost of the products.
  2. Ensure in the Cost Explorer > Setup, decimals is greater than 0.
  3. If periodic costing model (FIFO, weighted average etc) is being used, ensure inventory closing has been run.
  4. Review the route configuration to ensure it is displaying the correct cost rather than the quantity.
  5. Gather the following information to assist in further investigation:
    1. Cost groups for each item involved (finished product and components).
    2. Item price calculation for the finished product.
    3. Item price for the components.
    4. Cost categories for the resources involved in the route.
  6. Replicate the issue in a standard environment to determine if it is specific to the current environment or a broader issue.
  7. If variances are present, check the physical cost against the financial costs, as discrepancies may occur when production is not completed. Ensure that the relevant columns are visible in the transaction view.
  8. Confirm if the physical value is being displayed in the Cost Explorer instead of the financial value that includes variances.