Symptom
During material cost estimate of a product, one of its input product uses purchase list prices as valuation method. However, now there are multiple list prices for this product with same company but different suppliers. Which price will system select for material cost estimate?
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to work center Inventory Valuation.
- Access view Material Cost Estimates.
- Click New - Cost Estimate, maintain mandatory fields and click Estimate.
- Return to view Material Cost Estimates, select corresponding line item, click View.
- In the section Material Items, material ABC has Valuation Method as Purchase List Prices.
- Go to work center Product Portfolio.
- Access view List Prices.
- Search material ABC, there are multiple list prices for same company but different suppliers.
You want to know the logic how system selects the price from them for Material Cost Estimate as cost.
Resolution
- If all these list prices have no scales maintained, system will always select the lowest price from them as cost in Material Cost Estimate.
- Example: List Price 1 with price 1 CNY, List Price 2 with price 5 CNY, List Price 3 with price 10 CNY. System will select 1 CNY as cost in Material Cost Estimate.
- If some list prices have scales maintained, then during Material Cost Estimate, system will check the prices in corresponding scales according to the valuation quantity set of material ABC in Material Cost Estimate, and also other prices without scales, finally select the lowest price as the cost.
- Example: List Price 1 has scale as from 0 price is 10 CNY, from 5 price is 8 CNY, from 10 price is 5 CNY. List Price 2 has no scale but only price 7 CNY; List Price 3 has scale as from 0 price is 20 CNY, from 6 price is 5 CNY. In Material Cost Estimate, material ABC has valuation quantity as 8, then system will firstly find price 8 CNY in List Price 1, 7 CNY in List Price 2 and 5 CNY in List Price 3, finally select 5 CNY as cost.
Above logic applies to ByD system with version 2311 or versions after that.
See Also
Help Document "Material Cost Estimates"
Keywords
List Price, Material Cost Estimate, Scales , KBA , AP-SOU , Sourcing , Problem
Product
SAP Business ByDesign all versions