I am trying to get a fill rate on orders. I only want the first shipment for any particular order. I used conditional formatting to show when an order number is listed more than once. Is there some way I can keep an Invoice from showing up in my list, if the order has already had a partial shipment?
This is my main NL Statement
=NL("Rows","Sales Invoice Header",,"Posting Date",$C$2,"Sell-to Customer No.",$C$3,"Order No.",">1")