Symptom
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.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Payables Work center.
- Go to the Periodic Tasks sub View.
- Search for Payment Run XXX and click its Execution ID YYY. (XXX represents Payment Run ID, YYY represents the Execution ID).
- Here view the Payment proposals and click Show All Payment proposals.
- Select Print
- Select "Landscape"
- Change the size to 45%.
All the payment proposals cannot be printed, so instead you export the data to Excel.
- Select Export
- Select Microsoft Excel
In the Export file the "Total amount" is not shown.
Cause
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.
Resolution
There are two ways to get the totals as expected.
- 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.
- 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.
Keywords
Payment Run, Payment proposals, Print, Export to Excel Sheet. , KBA , AP-ACC , Business ByDesign: Financial Accounting , Problem