When users apply a filter in All Purchase Orders using a large list of purchase order numbers, the system accepts the full list during data entry but silently removes part of the entered values when the filter is applied.

In the reported scenario, a user entered 598 purchase order numbers in the filter criteria. After selecting Apply, the filter retained only 368 values. Investigation confirmed that this occurs because the generated filter expression exceeds the system's internal 4000-character limitation.

While the limitation itself is understood, the current user experience is confusing because the system allows users to enter more values than can actually be processed, without displaying any warning, validation message, or indication that data has been removed.

Current Behavior

• User enters 598 purchase order numbers into the filter.
• The system accepts all values during data entry.
• Upon applying the filter, the value list is automatically reduced to 368 entries.
• No warning, error message, or validation is displayed.
• Users may not realize that a significant portion of their filter criteria has been excluded.

Expected Behavior

When the filter exceeds the supported limitation, the system should:

• Process all entered values correctly, or
• Prevent users from exceeding the supported threshold and display a clear validation message before the filter is applied.

The system should never silently remove values that were accepted during data entry.

Business Impact

The current behavior creates a data reliability and usability concern. Users reasonably expect that all values entered into a filter will be included in the resulting query.

Because values are silently removed:

• Returned results may be incomplete.
• Users may incorrectly assume that all requested purchase orders are being reviewed.
• Missing records can go unnoticed.
• Operational reviews, financial analysis, audits, and reporting activities may be based on incomplete datasets.

Proposed Solution

Introduce validation before applying the filter whenever the generated query exceeds the supported character limit.

Possible enhancements:

1. Display a warning indicating that the filter exceeds the supported limit and cannot be processed as entered.
2. Show the maximum supported number of characters or values.
3. Prevent the filter from being applied until the criteria are reduced.
4. Optionally provide a more scalable filtering mechanism for large value lists.

Customer Value

This enhancement would improve transparency, user trust, and data accuracy by ensuring users are fully aware when system limitations affect the filter criteria. It would eliminate confusion and reduce the risk of business decisions being made using incomplete information.