Sage 100

Creating a VI job to import SO invoices. Data has qty and extension but no unit price. We need vi to calculate the unit price. However when we do this we get an error 40 (divide by zero). In Crystal I would always preface formula with if x <> 0 then y/x. Can't seem to get it right for VI

If you leave the unit price blank, doesn't it get calculated automatically?? (What version?)

Customer is on 4.5

Make the if statement a conditional instead of part of the formula.

How are you using VI to calculate unit price? Is this a simple Extension / QTY? I've usually done as Jeff suggests and use some variation of a conditional import. I'm sure it's less efficient than code but it's quick and can get the job done.