https://netsuiteprofessionals.com logo
n

Nichole Broom

05/04/2022, 11:22 PM
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

S Feld

05/04/2022, 11:40 PM
We have been relying on the
quantity on shipment
where / how have you seen it not being accurate
n

Nichole Broom

05/04/2022, 11:58 PM
@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.
message has been deleted
message has been deleted
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

S Feld

05/05/2022, 12:01 AM
Quantity on shipments are received and unreceived quantity In order to get unreceived only you have to do minus quantity received
n

Nichole Broom

05/05/2022, 12:06 AM
@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

S Feld

05/05/2022, 12:07 AM
We've all been there ...
n

Nichole Broom

05/05/2022, 12:10 AM
@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 🙂.. thanks again. Have a good night
@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

S Feld

05/05/2022, 1:05 AM
None that I recall on top of my head
👍 1