4 Replies Latest reply on Feb 18, 2014 2:50 PM by keywords

    Constrain Found Set not removing Blanks


      I am searching through invoices in a script fist by date and then if a checkbox is selected, I want to omit all records that aren't in the selected ship state.


      My problem, any international shipment that has a blank state is not omitted.


      I am setting a variable $ShipState to the selected state and then omitting records with a Constrain Found Set greater than $ShipState and less than $ShipState. Hopefully leaving records with only the ship state selected.


      Any reason why blank ship state records are not being filtered?


      Thank you,