Symptom
In the Pricing and Invoicing tab of a Sales Order you notice an unexpected cost amount for an item which distorts the profit margin.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Sales Order work center.
- Go to the Sales Order view.
- Find sales order XXX (XXX represents the sales order ID).
- Press View All and navigate to the Pricing and Invoicing tab.
- Select line item XX and press Expand (X stands for the Line Item ID).
- For the Cost price component an unexpected amount appears.
You expect the cost to be derived from the inventory cost value of the business residence of the ship-from location.
Cause
The material ordered in item XX is stocked in different business residences. The Cost price component displays an average value of the inventory costs of all business residences of the selling company:
- In the Inventory Valuation work center go to the Materials view.
- Search for All Materials and find material YYY (YYY represents the product ID of line item XX in sales order XXX).
- In the Company column filter for the selling company of sales order XXX.
- You notice, the material is maintained for more than one business residence, displaying different inventory costs.
- The sales order item cost is calculated as an average of all valid inventory costs (provided they are higher than zero and the respective org unit is still a valid business residence).
Resolution
This is the expected system behaviour.
Please note: The value maintained for the sales order item's Cost price component is of display purposes only. For the actual goods issue posting, the inventory cost maintained for the ship-from location's business residence is derived.
Keywords
sales order item cost, pricing and invoicing, profit margin, wrong cost , KBA , SRD-FIN-COR , Cost & Revenue , AP-PRC-PC , Calculation , How To