SAP Knowledge Base Article - Public

3368681 - When exporting Payment Proposal to Excel Sheet - Total amount is Missing.


When you try to print the Payment proposal for Payment Run XXX(XXX refers to Payment Run ID), There you can see Total Column in end and this is the system calculated result and shows the values in Print Preview + Downloaded Print File. But when you are trying to export the same payment proposals to excel, there the total amount is not showing in the excel sheet. This has missing system calculated Total amount Row in the end. 




SAP Business ByDesign

Reproducing the Issue

  1. Go to the Payables Work center.
  2. Go to the Periodic Tasks sub View.
  3. Search for Payment Run XXX and click its Execution ID YYY. (XXX represents Payment Run ID, YYY represents the Execution ID).
  4. Here view the Payment proposals and click Show All Payment proposals.
  5. Select Print
  6. Select "Landscape"
  7. Change the size to 45%.

All the payment proposals cannot be printed, so instead you export the data to Excel.

  1. Select Export
  2. Select Microsoft Excel

In the Export file the "Total amount" is not shown.


Due to huge number of data (i.e. Invoices and its details), the total amount row is missing when you are export to Excel sheet.


There are two ways to get the totals as expected.

  1. Export the data from Payment proposal to Excel sheet  - In this data, you have to select the respective amount columns and click on SUM button manually then click on print option to get the total values as expected.
  2. Print option - Click on Print button, and select the page Orientation 'Landscape', Adjust the size to 42% and page size is 'tabloid' then click on print to save the PDF with totals.


Payment Run, Payment proposals, Print, Export to Excel Sheet. , KBA , AP-ACC , Business ByDesign: Financial Accounting , Problem


SAP Business ByDesign 2308