1892270 - Field calculation for Total Net Value of Purchase Requests

SAP Knowledge Base Article - Public

1892270 - Field calculation for Total Net Value of Purchase Requests

Symptom

The field calculation for the total net value of all purchase requests is not working.

Reproducing the Issue

  1. Go to the Purchase Requests and Orders work center
  2. Go to the Purchase Requests view
  3. Click on Show > All Purchase Requests and Go
  4. Scroll down to the last results
  5. Verify that the sum for Open Quantity is working, but the sum for Net Value is blank
  6. Click on Personalize > This Screen
  7. Click on Configure Calculations
  8. Verify that the calculation is correctly configured for both Open Quantity and Net Value

Cause

The reason why the sum of net values for Purchase Requests is not displayed is due to the way the system was designed for this type of document. More precisely, the currency value of a Purchase Request is stored in two fields of an item: Net Amount and Limit. The field Net Value on the Purchase Request listing is then a collection of the contents of both fields at item level. The value displayed by the system is determined by a display rule; i.e., either the Net Amount is to be displayed, or the Limit amount. Since two fields are involved for Purchase Requests, the value is not displayed, as the Configure Calculation doesn't yield any response for this column.

Resolution

The system is working according to its intended design. You can verify that the Net Value sum works correctly in the Purchase Order listing, for example, because in that case only one field is mapped for this column (Total Net Amount).

Keywords

KBA , AP-PRP , Purchase Request Processing , How To

Product

SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1.0 ; SAP Business ByDesign 1302 ; SAP Business ByDesign 1305 ; SAP Business ByDesign 1308 ; SAP Business ByDesign 1311 ; SAP Business ByDesign 1402 ; SAP Business ByDesign 1405 ; SAP Business ByDesign 1408 ; SAP Business ByDesign 1411 ; SAP Business ByDesign 1502 ; SAP Business ByDesign 1505 ; SAP Business ByDesign 1508 ; SAP Business ByDesign 1511 ; SAP Business ByDesign 1602 ; SAP Business ByDesign 1605 ; SAP Business ByDesign 1608 ; SAP Business ByDesign 1702 ; SAP Business ByDesign 1711 ; SAP Business ByDesign feature pack 2.0 ; SAP Business ByDesign feature pack 2.5 ; SAP Business ByDesign feature pack 2.6 ; SAP Business ByDesign feature pack 3.0 ; SAP Business ByDesign feature pack 3.5 ; SAP Business ByDesign feature pack 4.0