SAP Knowledge Base Article - Public

3370285 - How to Add Sum row in the Supplier Invoicing work center in SAP Business ByDesign(BYD)

Symptom

This KBA will help you on how you can add Sum row in the Supplier Invoicing work center.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Supplier Invoicing Work Center
  2. Go to Invoice and credit memos
  3. Search for any Supplier Invoice with more than one Quantity
  4. Click on "Start personalization mode"
  5. Go to Items tab
  6. Under UI elements "Item"
  7. Right Click on mouse under Quantity field and you will get an pop up window at side of items
  8. Select "Table calculation"
  9. For "Configure calculations" have maintain SUM under the four possible Column Name.

However and despite this configuration being published, you cannot see any Yellow line at the bottom of the the items line with the total being calculated.

sum1.jpg

Resolution

Please Follow the below steps to add sum row to Items tab:

  1. Go to Supplier Invoicing Work Center
  2. Go to Invoice and credit memos
  3. Search for any Supplier Invoice with more than one Quantity
  4. Click on "Start personalization mode"
  5. Go to Items tab
  6. Under UI elements "Item"
  7. Right Click on mouse under Quantity field and you will get an pop up window at side of items
  8. Select "Table calculation"
  9. For "Configure calculations"

Table Configuration.jpg

  1. For quantity select "Sum"
  2. Mark "Display Result Rows at Top of Table"
  3. Click on apply

Calculations.jpg

  1. The user has to expand the table explicitly to see the total row 

expand.jpg

It will display the sum in the yellow row as displayed in the below screenshot.

Sum.jpg

Keywords

Sum, Supplier Invoice, Adaptation, Items, Quantity , KBA , supplier invoice , quantity , quantity sum , AP-RC-UIF-RT-B , ByD HTML5 Client (not for Cloud for Customer) , Problem

Product

SAP Business ByDesign all versions