3363670 - Material Cost Rollup Run Error Message - Valuation With Cost Estimate of Material Failed for Internally or Externally Procured Material

You execute a Material Cost Estimate Rollup run. For some materials it finishes with the error message "Valuation with cost estimate of material XYZ failed" (XYZ represents the material ID).

In the Material Cost Estimates view you find the material cost estimate with status In Preparation. The status is In Preparation as one or more items involved in the cost estimate had errors during cost calculation. 

SAP Business ByDesign

• In the Inventory Valuation work center go to Periodic Tasks and select Material Cost Estimate Rollup.
• Select the run.
• In the Details section underneath go to the Execution tab, select a log and press View.
• Navigate to the Processed with Errors tab.
• Select material XYX.
• The error message  "Valuation with cost estimate of material XYZ failed" is displayed. 

There can be a few reasons for this error message:

For in-house produced materials: 

• The cost estimate might fail as it was not possible to derive the costs for one of the purchased input materials:

For purchased materials: 

• Either the procurement type of the material is not External or Internal Procurement or/and
• Failed material cost estimates with status In Preparation exist or/and

For internally procured materials: 

• Transport lanes between business residences are missing or/ and 
• There is a loop in the transport lanes for the material

For externally procured materials

• For the material no purchase price exists and the current inventory cost for the used business residence is 0,00 

To successfully create a cost estimation for purchased materials that are used for in-house productions

1. there must not be any existing material cost estimate with status In preparation. 

To check the procurement type of the material

1. access the material master data: From the Processed with Errors tab press the material ID to access the master data.
2. In the Planning tab find the respective planning area. 
3. Under Procurement check the procurement type.
4. the procurement type of the material must be External or Internal Procurement.

2. there must not be any existing failed material cost estimates with status In Preparation: 

To check for existing material cost estimates in preparation

1. go to the Material Cost Estimates view in the Inventory Valuation work center.
2. Find material XYZ. 
3. Check if there are any cost estimates with status In preparation. 

Delete or release all these material cost estimates. Then execute the run again. This time the run should finish successfully. 

3. ensure that all transport lanes are set up correctly. If valuation is not maintained at the business residence level, and if the material is internally procured, the system checks the default transportation lane between the business residence and its source. The cost is then taken from the source business residence. 

Ensure that there is no loop between the transport lanes: 

To set up the transport lanes:

First check the used transport lanes of the material cost estimate: 

1. In the Inventory Valuation work center go to the Material Cost Estimates view and find the failed cost estimate with status In Preparation. 
2. Press Edit.
3. Expand all levels of the cost estimate structure.
4. Find the level for which an exception appears (red x). Very likely this level is in exception because there is a loop between the sending (ship-from) and receiving (ship-to) business residences.
5. Go through all the cost estimate levels from top to bottom and check the business residence and the transport lane to identify the loop. 

Example:

Level 1: 

Business residence: ABC (ABC is the ID of the source business residence).

Transport lane: XX - From DEF to ABC (XX represents the transport lane ID, DEF represents another business residence)

Level 2: Business residence DEF

Transport Lane: YY- From ABC to DEF (YY represents another transport lane ID).

Here, we have a loop from business residences DEF to ABC and back to DEF. 

To successfully complete the material cost estimate you could (even just temporarily) block the redundant transport lane: 

1. Go to the Supply Chain Master Data work center and here to the Transport Lanes view. 
2. Open the advanced search and use the Product ID. Or, if you create transport lanes for all products just check the transport lanes.
3. Find all transport lanes for ship-to business residence DEF. 
4. Block transport lane YY via the Change Status button. 
5. Ensure that there is another transport lane available for ship-to business residence DEF that does not loop with any of the other involved transport lanes for the cost estimate of product XYZ. 

Creation of Cost Estimates

purchased material; Valuation With Cost Estimate of Material Failed , KBA , SRD-FIN-INV , Inventory , Problem