Skip to main content

Working on creating a shipment cut GI, and I would like to know how I would add a condition that only shows me lines that SOShipline.Orderqty does not equal the SOshipline.Shippedqty. 

 

In other words I don’t want to see if an order was shipped complete only the ones where the ship qty does not equal order qty.

 

Thanks

Hi,

Is this what you are looking for?

SOShipLine.ShippedQty | Does Not Equal | =[SOShipLine.OrigOrderQty]

 

Hi @byates  You can also check with a single field i.e. OPEN QTY.


If OPEN QTY is greater than 0, which means there is Unshipped is available in the Sales Order. Please find the screenshot for reference.

 

 

Hi @byates Assuming that you are looking for the Sales Order line items, please use the below condition.

 

Thanks

Hi @byates Please find the attached Generic Inquiry created for your convenience and reference.

Hi @byates With the generic Inquiry posted in the previous post, please find the below results successfully showing only the Open items to be shipped.

 

Exported to Excel and verified the results.

 

Thank you all for the feedback!! Classic example of overthinking a solution, never thought about using the already available Open Qty.

 

@ChandrasekharM, thank you for the GI as well!! 

Reply


Terms & ConditionsCookie settings