SAP Knowledge Base Article - Public

3463209 - How the Net Value and Net Price for the Items are Calculated in a Invoice Document

Symptom

When navigating in a Customer Invoice, the Net Price and Net Value for each Item are displayed in the document.

This documentation aims to provide further details regarding how the Net Value and Net Price for the items are calculated in a Customer Invoice document.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Customer Invoicing Work Center.
  2. Go to the Invoice Documents View.
  3. Filter for All Invoice Document.
  4. Search for the Invoice XYZ (where XYZ represents the Invoice ID).
  5. Open, Select View All.
  6. Navigate to the Items tab.

The Net Value and Net Price amount are displayed for the Line Item XX (where XX represents the Line Item Number).  

Resolution

The calculation of the Net Value and Net Price occurs in the following order:

First the system calculates the Price Component Value (List Price) using the below equation:

  • Price Component Value (List Price) = Line Item Quantity x Unit Price (Amount)

After the Price Component Value (List Price) is obtained, the system calculates the Net Value for the Item using the following equation:

  • Net Value = Price Component Value (List Price) + Addition Price Components

Note: The Addition Price Components are optional for each Item (for example a Surcharge, Quality Loss Fee, Freight, etc.).

Then, the system uses the Net Value for the Item in the below equation to obtain the Net Price value:

  • Net Price = Net Value/ Line Item Quantity

Note that currency conversions in the Sales Orders and rounding are required to be taken into consideration for the values displayed for each Price Component.

See Also

KBA 2250861 - Is it Possible to Change the Default Decimal Notation for Currencies?

Keywords

Net Value, Net Price, Invoice, Sales Order, Item, Items, byd , KBA , SRD-CRM-INV , Customer Invoicing , How To

Product

SAP Business ByDesign all versions