Symptom
You have created an inter-company purchase order with a certain item price. Then the inter-company sales order is created out of this purchase order. But the sales order item shows unexpected net price as 0.00.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Purchase Requests and Orders work center.
- Go to the Purchase Orders view.
- Select the inter-company purchase order ABC you created (ABC represents the ID of the purchase order) and click Edit.
- Go to the Items tab.
- You can see that for example the line item 10 has Net Price 1.00 GBP and Net Value 75.00 GBP.
- Now, navigate to the Document Flow tab.
- Click the ID of the follow-up inter-company sales order created to open it.
- You see a warning message: "Item 10: Customer expected net value 75.00 GBP differs from item net value 0.00 GBP".
- Click View All and go to the Items tab.
- You can see that line item 10 has List Price 1.00 CLP (Chilean Peso) and Net Price and Net Value 0.00 GBP.
Cause
The purchase order has the document currency maintained as GBP and the item currency is also GBP.
The sales order has the document currency as GBP but the item currency as CLP, as the associated price list is in CLP.
The system makes sure that all Net Prices are in the document currency which is in this case GBP.
At this point, the Net Price calculation happens after applying the Exchange Rate from CLP to GBP.
But the Exchange Rate from CLP to GBP is too low, i.e. 1 Chilean Peso equals 0.000962325903 Pound sterling. Therefore, when it is applied on the List Price 1.00 CLP it becomes 0.00 GBP after the rounding to 2 decimals. The Net Value is then calculated using this Net Price.
Resolution
The system behavior is correct.
To avoid this issue you can:
- Maintain the price list currency of the item in GBP in the system,
or
- Maintain the document currency of the sales order in CLP in the General tab, so the Net Price is the same as the List Price.
Keywords
intercompany; currency; devise; 0; zero; prix net; commande , KBA , AP-PRC-PC , Calculation , Problem