2933609 - Net Value is Calculated Incorrectly in Sales Order

The Net Value in the Sales Order is not what you expect. You expect Net Value should be equal to the List Price multiplied by the Quantity.

Quantity * Net Price = Net Value.

SAP Business ByDesign

1. Go to Sales Orders Work Center.
2. Open Sales Order ABC (where ABC stands for Sales Order document).
3. Navigate to the Items tab.
4. You can see Line Item 10 is Quantity of 1 KG for List Price 100 USD.
5. The Net Value is 27.78 USD. You expect the Net Value should be 1 * 100 = 100 USD.

The system calculates the Net Value based on Price Unit and Quantity Conversion maintained in Product Master Data.

1. Go to Product and Service Portfolio Work Center- Products View
2. Open Product EFG (where EFG stands for Product maintained in the Sales Order ABC).
3. Click View All button.
4. Navigate to Genral tab.
5. You can see the Base UoM is KG-KG.
6. In Quantity Conversions session, you can see 1 GAL - GAL = 3.6 KG - KG
7. Navigate to Sales tab, Sales Prices sub-tab.
8. For Account XYZ (where XYZ stands for Account maintained in the Sales Order ABC), Price is 100 USD, Price Unit is 1 GAL-GAL

So in the Sales Order ABC, the Net Value equals to 1 KG ÷ 3.6 *100 USD = 27.78 USD

If you maintain KG as the Price Unit and set 1 GAL in the Sales Order for List Price 100 USD. The Net Value equals to 1 GAL *3.6 *100 USD = 360 USD. By default, the system will set the Base UoM as Price Unit if you didn't maintain it.

This is the expected behavior. You can make the Field "Price Unit" visible in the Sales Order via Personalization Mode.

KBA 2596856 - How Rounding Off Works For Net Value And Net Price In Sales Order

Net Value, Price Unit, Sales Order, Quantity Conversion, Base UoM , KBA , SRD-CRM-ORD , Orders & Contracts , Problem