This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

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.

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

<@U6C022FJT> 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.

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?

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

<@U6C022FJT> - 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

<@U6C022FJT> - 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

<@U6C022FJT> 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