Trying to skip record in VI Import if the field is 0.00


Running Sage 100 v2016.  Have a VI job that imports data that typically contains a numeric value (the field is Quantity) as well as a total unit price.  The import file does not have a per unit price but it's needed.  In order to get the unit price I added two temp fields (Temp001 is the total unit price and Temp002 is the Quantity).  I then added a calculation for Unit Price as Temp001 / Temp002.  This all works well until a record comes in with no quantity...then I get the divide by zero error.  

I added a "Skip" option within the Record tab to skip any record that contained "0.00" in the Quantity field but that doesn't seem to work.  Any ideas would be helpful.

Thank you

Parents Reply Children
No Data