NAV 2013 R2 Remove duplicate orders

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")

1 comment

Please sign in to leave a comment.