Logic to separate in transit shipment on a purchase order from BIP report

Summary:

Business requirement is to finally close a purchase order but system is not allowing due to in transit shipment.

In report we have already added the logic for not to pick in-transit shipment PO that is (quantity_received = quantity_delivered AND quantity_shipped = quantity_delivered) and in-transit and satisfying this condition. We need logic for not to pick in-transit shipments as the mentioned logic is not working.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):