@stacy16 if you shared a screenshot of the Related Tables Tab and the Results Grid tab of the generic inquiry we might be able to add some additional details on how to do it for your GI specifically but the short answer is yes you can is a few different ways.

One way would be to look at the SOLine qty fields for open qty, qty on shipments, qty invoiced, and with a formula and calculate the open/shipped/invoiced lines

Another option would be to add just a simple condition looking at SOLine Open qty greater than 0

I will point out that some of these fields are dependant on if a shipment is still not yet completed. 

 

@stacy16, As suggested by @ccleary We can able to know whether the Sales Order line is completely shipped or not from SOLine table by using these fields (OrderQty, OpenQty, and ShippedQty). Please find the screenshot for reference.

@Naveen B I was doing that before but found that it confused the sales people. i was hoping that there was an actual status by line in the system but that is okay. I will just have to add the formula like @ccleary mentioned and hide the columns so they only see the status. 

Thank you both for the help! :)

@stacy16 you could get a little creative and use a formula 

iff(equals(openqty > 0), ‘Open’, ‘Complete’)

Some variation of the above might make it a more user friendly field result!

@ccleary That is exactly what i did :)

Thank you so much :)