SAP Knowledge Base Article - Public

2933609 - Net Value is Calculated Incorrectly in Sales Order

Symptom

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.

Environment

SAP Business ByDesign

Reproducing the Issue

  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.

Cause

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.

Resolution

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

See Also

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

Keywords

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

Product

SAP Business ByDesign all versions