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?