Symptom
You try to filter the customer contracts by using advance search, and enter Contract End value as criteria, but contracts are not filtered out properly.
For example, the contract ABC is with contract end date as 01.01.2024. You set the Contract End as 01.01.2024 in Advanced Search, but this contract ABC does not appear. (ABC represents the ID of the contract)
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Sales Orders work center.
- Go to the Contracts view.
- Open the Advanced Search window.
- Set Contract End as 01.01.2024, click GO.
- The contract ABC is not shown up.
Cause
When a single date is set for the search field Contract End, the query itself takes a date range as input.
For example, contract end is 01.01.2024, then the query takes the range between 2024-01-01T23:00:00Z and 2024-01-02T22:59:59Z.
Since the contract end date for ABC is 2024-01-01T16:20:00Z in backend, so it is not filtered out.
Resolution
To show the contract ABC, the Contract End in the search should be set as 2023.12.31 or less than 2024-01-01.
This is the current behavior.
Keywords
contract end; advanced search; advanced filter; contract not displayed; not showing. , KBA , AP-SLO-SO , Sales Order , Problem