SAP Knowledge Base Article - Public

3562557 - Material Inventories - Balance Summary Report Shows Fields as Not Assigned (#)

Symptom

The Material Inventories - Balance Summary report (Report ID FININVU14_Q0001) shows the symbol "#" (which means not assigned) for fields Valuation Level ID and Product Specification for Material ABC.

ABC means the Material ID.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Navigate to the Business Analytics work center.
  2. Go to the Design Reports view.
  3. Open report Material Inventories - Balance Summary (Report ID FININVU14_Q0001).
  4. Enter selection data by giving Material ABC
  5. Execute the report.
  6. Observe that the system displays Valuation Level ID and Product Specification fields as "#" (not assigned) for Material ABC.

Cause

For Material ABC, there's no valuation master data maintained at product specification level.

Resolution

Maintain valuation data at product specification level by following the steps below:

  1. Go to the Inventory Valuation work center.
  2. Go to the Master Data view and Materials sub view.
  3. Find Material ABC and click Edit.
  4. Move to Valuation tab.
  5. If Valuation Type is already 2 - Product Specification, click Maintain Product Specification Valuation button.
  6. Maintain Product Specification, Account Determination Group, etc.
  7. Save the changes.

As a result, when running the report Material Inventories - Balance Summary data will be displayed in Valuation Level ID and Product Specification fields for Material ABC.

See Also

KBA 2467630 - Product Specification (Valuation Level ID) Shows no Data in Material Unit Costs Report

Keywords

Material Inventories, Balance Summary Report, Material ID, Valuation Level ID, Product Specification, Inconsistency, Report ID FININVU14_Q0001 , KBA , SRD-FIN-INV , Inventory , How To

Product

SAP Business ByDesign all versions