Symptom
You want to see the total result of the transaction amounts through report Bank Statement Items Details. But you find that the total result is not equal to the sum of all transaction amounts.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Liquidity Management work center.
- Go to List view.
- Open report Bank Statement Items Details.
- Enter the required parameters and click Apply.
- Show Result Row of Statement ID.
- The Result amount is not equal to the sum of all Transaction Amounts.
Cause
The Result row is not based on the sum of the transaction amounts therefore the result is different than expected. The Result characteristic can be performed on any column however this a Line Item based report and will therefore not display the total sum of the line items. With this in mind, the report takes the Bank Statement Line with the highest value and displays this as the Result.
Resolution
As this is the expected system behavior in this case, you may suggest a change on our Customer Influence web site. Here other customers can see your ideas and inputs and if they are interested, they can vote for this change in functionality. The more votes it receives, the better the chances are of getting this functionality implemented.
As an alternative, there are other reports which do sum the Transaction amounts:
Cash Position by Transaction Source
Cash Position - Transaction Details
See Also
Keywords
Bank Statement Item Details, Transaction Amount, Result , KBA , AP-PAY-ANA , Analytics , Problem