3714709 - Advanced Filter Does not Display the Expected Results When Using the Exclude Parameter

When using the Exclude option in the Advanced Filter for the Preceding Document ID, the results do not show the Invoice Requests connected to the Preceding Document in the Invoice Requests OWL (Object Work List).

SAP Business ByDesign

In our example we will use the Document Type Sales Orders as Preceding Document.

1. Go to the Customer Invoicing work center.
2. Select the Invoice Requests view.
3. Select All Invoice Requests.
4. Click on the Advanced Filter symbol.
5. In the Section Preceding Document enter the Document Type Sales Orders.
6. Click on the More Filter symbol for the field Document ID.
7. Under the Options select the parameter ... Between
8. In the Value field enter X1 in the Valid To enter X9 (X1 represents the starting number of the rage and X9 represents the final number of the range for the Document ID)
9. Click on the Go button

In the Result List you will see the Sales Order Invoice Requests X1 to X9 and also any Outbound Delivery Invoice Request or Service Confirmation Invoice Request associated to the Sales Order X1 to X9.

In our example Sales Order X1 was delivered with Outbound Delivery Y1 and therefore Outbound Delivery Invoice Request Y1 is also displayed in the Result List.

However, when you add the Exclusion parameter to the Advanced Filter the associated Outbound Delivery Invoice Request or Service Confirmation Invoice Request associated are not displayed in the result list anymore. 

1. Go to the Customer Invoicing work center.
2. Select the Invoice Requests view.
3. Select All Invoice Requests.
4. Click on the Advanced Filter symbol.
5. In the Section Preceding Document enter the Document Type Sales Orders.
6. Click on the More Filter symbol for the field Document ID.
7. Under the Options select the parameter ... Between.
8. In the Value field enter X1 in the Valid To enter X9 (X1 represents the starting number of the rage and X9 represents the final number of the range for the Document ID).
9. Activate the But exclude indicator.
10. Enter Parameter = Equal to and the Value X5 (X5 represents a Document ID between the start and end ID of the range).
11. Click on the Go button.

No Outbound Delivery Invoice Request or Service Confirmation Invoice Request associated to the Sales Orders that are still included in the range are not displayed in the result list anymore e.g.  Outbound Delivery Invoice Request Y1.

This is a current system limitation.

When using the exclude indicator in the Advance Filter for the Preceding Document ID, only the Invoice Requests of the Document Type are displayed e.g. if the Document Type is Sales Order only the Sales Order Invoice Requests are displayed or if the Document Type is a Contract only the Customer Contract Invoice Requests are displayed in the result list. The associated Invoice Requests such as e.g.  Outbound Delivery Invoice Requests or Service Confirmation Invoice Requests are not displayed in the result list.

This is the current system behavior

Advance Search, Advance Filter, Exclude, missing, Outbound Delivery Invoice Request, Service Confirmation Invoice Request, wrong, OWL, Search, but exclude, check box, indicator , KBA , AP-CI-CIR , Customer Invoice Request , Problem