We have a BAQ where we are pulling all open lines for all orders. We want to add a column with checkboxes that checks the box for all open lines with the same order that has a closed line on it (partial shipment). How would a calculated field for this look like?
FWIW… made a really quick BAQ to show Open line counts
and Closed line counts if they exist too
( yeah, it’s a nice and slow afternoon… so far)
But… from your description I am not really sure what you wanted to display.
CUS-OpenSO.baq (22.6 KB)
1 Like
I can work with this. Thank you
If any order had a closed line, all the open lines showing up would have a checkmark noting the order has at least a closed line but an open line as well. Not a completely closed order or open order