Symptom
You create a new bank statement. However, you notice that the display sequence of the bank statement open items changed during step 2 and step 3, and you want to know the logic behind.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Liquidity Management work center.
- Go to Bank Statements view.
- Click New - Create new Bank Statement.
- When you go to step 2: select items, you notice that the display sequence of the open items is ABC.
- However, when you go to step 3: create and edit Items, you notice that the display sequence of the open items is ACB.
Cause
Currently, there is no specific logic written on the display sequence of the open items. The system can display the items in any sequence.
Resolution
The sequence can be determined by the user.
In order to set the sorting rule, please note you can follow steps provided below:
- At the affected screen, Go to the User.
- Select Key User and Start Adaptation Mode.
- Click with the right mouse button on Transactions and then select 'Sorting & Group'. Here you can configure Sorting and Group.
In the Sorting and Group view, you can select any item you want. For example, if you hope the display sequence to be consistent during step 2 and step 3, you could maintain the same sorting rules in step 2 and step 3.
You can only move the field 'Issue Date' from the left to the right column. Then set the 'Sort Ascending' or 'Sort Descending' according to your business needs.
Keywords
bank statement, open items sequence, 银行对账单, display sequence , KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem