SAP Knowledge Base Article - Public

2701455 - Balance Confirmation Statement Cannot be Sorted on Due Date of Invoice.

Symptom

You want to know if the Balance Confirmation Statement can be sorted based on Due Date of Invoice.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Receivables Work center.
  2. Go to the Customers view and then to Balance Confirmation Subview.
  3. Show All Released Balance Confirmations.
  4. Choose the Balance Confirmation ID 123(123 here represents Balance Confirmation ID).
  5. Choose Preview and select Send Options.
  6. Choose the Hyperlink of Template Name Balance notification.

You could see that the Balances are sorted based on Invoice Date.

Cause

Currently, the list of Invoices in Balance Confirmation Statement is sorted as per the following fields in this order: Document Date, Document ID, Document Type Code, Open Amount, Transaction Amount.

It is not possible to change the behaviour to sort the Invoices based on Due date in Balance Confirmation Statement.

Resolution

The system works as designed.

Keywords

"Balance Confirmation Statement" "Due Date" , KBA , balance confirmation statement sorting , SRD-FIN-ACR , Receivables , Problem

Product

SAP Business ByDesign 1808 ; SAP Business ByDesign 1811 ; SAP Business ByDesign 1902