For the people using the Inbound Shipment feature what have

Question

For the people using the Inbound Shipment feature what have you found the easiest way to look at a PO and see which of the open items are already in transit on an inbound shipment I had a saved search but I found out its not working as I thought The QTY On Shipment column does not calculate correctly Looking for a report saved search that shows all PO Line Items that still have a remaining balance along with what qty of that remaining balance is on an open inbound shipment if that makes sense

S Feld · Answer

We have been relying on the `quantity on shipment` where how have you seen it not being accurate

Nichole Broom · Answer

< S Feld> I thought it was working fine but when looking at it on a larger scale i have noticed some being off Example in these screenshots We ordered 1 000 of item 00212 625 on PO L21732P We have previously received 600 from this PO The remaining 400 are on an open inbound shipment But it is saying we have 1 000 on shipments I have a total of 3 100 on all open inbound shipments On one IS theres 2 900 The 400 remaining from this PO 100 from another PO and 2 400 from another PO

Nichole Broom · Answer

I was hoping the QTY on Shipments would be PO Line specific as my report is a PO Search with main line being no Maybe I have something else on the search wrong and its pulling the data from wrong spot

S Feld · Answer

Quantity on shipments are received and unreceived quantity In order to get unreceived only you have to do minus quantity received

Nichole Broom · Answer

< S Feld> Wow I feel stupid LOL Thats why it was working before Because I had that column as a formula taking QTY on shipments QTY Rec I created a new search for same thing but a few different criteria filters and forgot that part THANK YOU It has been a long week Makes me happy to know that I havent been looking at the wrong data this whole time though

S Feld · Answer

We ve all been there

Nichole Broom · Answer

< S Feld> sadly I used my original search to start this new one But in the mess of moving things around and changing criteria results I removed the main thing I needed haha I go on vacation next week so I guess my mind is just already there slightly smiling face thanks again Have a good night

Nichole Broom · Answer

< S Feld> one more question you wouldnt happen to know a way to easily see items received directly from PO and not from an inbound shipment Was still seeing some off but I see whats causing it Some items had been received directly from the PO and were never on an inbound shipment So item says I have 118 on the PO I have received 100 I have 18 still inbound However since the original 100 were received directly off the PO and were never on an inbound shipment the QTY On Shipment is 18 Formula thinks 18 100 received = 64 still in transit Just wanting to see how many items were received that way

S Feld · Answer

None that I recall on top of my head