2039319 - How To Alphabetically Sort a Payment Proposal List by Supplier Name

You just executed a Payment Run and now want to check the Payment Proposal List generated by the run. Your aim is to order the list by Supplier Name in order to facilitate the execution of the payment proposals, however you notice that clicking Supplier Name column doesn't sort the list alphabetically.

SAP Business ByDesign

1. Go to Payables work center.
2. Go to Periodic Tasks.
3. Select the view Payment Runs.
4. Select any Active Run ID.
5. Under Execution Details section, select an Application Log ID with Processing Status as Finished.
6. Click View Payment Proposals.
7. Click Supplier Name column in order to sort the list by Supplier Name alphabetically. However this does not make a change that is expected.

The reason why you cannot see the Payment Proposal List sorted by Supplier Name in alphabetical order is that this list is configured with default grouping on Payment ID with subtotals, so when you try to sort by Supplier Name the sorting happens only within this group.

In order to have the entire Payment Proposal List alphabetically sorted by Supplier Name you have to set that order in personalization mode:

1. On the upper right corner of the screen, click Personalize.
2. Under Sections select Untitled Table.
3. Right click to select Field Properties.
4. Select the option Table Calculation.
5. With Display Intermediate Results for Sorted Columns ticked, click Exceptions button.
6. Unmark any selected checkbox (e. g. Payment ID). 
7. Click OK on the Exceptions button.
8. Select Supplier Name. This will then group the results by Supplier Name.
9. Click OK on the Configure Calculations popup.
10. Click Save on the Personalize menu.

As a result now you have removed any intermediate result and you can alphabetically sort the Payment Proposal List by Supplier Name.

Note that this change only applies to your user. If you want to apply the change to all users you need to perform the same steps using the Adapt mode.

Payment Proposal, order, sub totals , KBA , SRD-FIN-MOP , Payment Management , How To