SAP Knowledge Base Article - Public

3447795 - Advanced Filter is Not Working as Expected When Filtering Based On Contract End Field

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

  1. Go to the Sales Orders work center.
  2. Go to the Contracts view.
  3. Open the Advanced Search window.
  4. Set Contract End as 01.01.2024, click GO.
  5. 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

Product

SAP Business ByDesign all versions