SAP Knowledge Base Article - Public

3471596 - Sales Documents Actual Costing - Cost Breakdown (Item Type) Report Shows Double Allocation Amount for Material/ Sales Document Item

Symptom

In the Sales Documents Actual costing cost breakdown (Item Type) the Allocated Amount appears doubled for output material XYZ (XYZ represents the material ID). 

Environment

SAP Business ByDesign

Reproducing the Issue

  1. In the Inventory Valuation work center go to the Reports view and find the Sales Documents Actual costing  cost breakdown (Item Type).  
  2. In the report enter all mandatory data.  
  3. In the Product field enter material XYZ and press Apply.
  4. You can now see all costing results for sales document items connected with the product.  
  5. Add the Allocation Amount key figure to the report.
  6. You notice the Allocation Amount, derived from the Actual Cost Allocation run. It appears doubled.
  7. Navigate from the allocation amount to the Sales Documents - Line Items report. Here, the actual cost allocation amount appears correctly.

Cause

For produced materiasl the data of the product/sales document item is derived from the Production Lot Actual Costing view.

The Sales Documents Actual costing cost breakdown (Item Type) displays multiplied values of the Allocation Amount when production models involve multiple item types, such as materials as well as services. 

Resolution

In the report add the Item Type-Break Down attribute. The allocation amount appears for all involved item type.

Keywords

sales documents actual costing -cost breakdown (item type) report, allocation amount , KBA , SRD-FIN-COR , Cost & Revenue , Problem

Product

SAP Business ByDesign all versions