Aaron Pelz Green Ribbon

Thanks!

Thanks John. That was my first thought. My concern is really on the operational side that I dont get notified when any repack is done. Even as a Non-Inventory would it not still accrue quantities that I would need to then disburse somehow? Aaron

That worked!! Thank yall so much for your help!

Yes, that is the formula I was using, and that is showing me what is currently in Transit. The only thing that I am missing now is where the {quantityonshipments} is 0, meaning there have been no shipments against that Item/PO. It is returning a blank/null. Is there a way to have that return a numeric value to provide a 0?…

Herdi and Shamaine: Looking further into this, this solution is still not quite accurate. The Quantity on Shipments is actually pulling too much data. That field is including any shipments that have already been received, and are therefore no longer In transit. The In Transit is what I need to isolate. I will try and write…

Thank you Herdi! At first glance it looks like this is giving me the results I am looking for. I will run some more tests to verify.

Hello Shamaine. We did try to use the Search function. However, what we are finding is that the Location External Quantity in Transit is an Item field. Because it is using the Item as the base, the reports are showing the total across all POs, not using a specific PO. The example below shows. Across all POs and locations…