By using this website, you agree to our Terms of Use (click here)
There may be a better way. I'm doing stock item imports and some have a conversion and others do not. I have the IIF that checks for it but I don't know how to skip the next two lines and figured I could just do a delete after the fact. I tried using the IIF with a linenumber and -2 to delete. It runs without error but does not actually delete the conversion.
**Edit** after posting the screenshot I noticed that I didn't have a from unit for the conversion factor and was throwing an error on the stock item screen as I had just set it as ''. I set it to 'HOUR' so there was something there. The screen allows me to delete it and save with no issues, but nothing happens on the import scenario side.
Only way i can think of is 2 import scenarios, one for those with conversions and one for this without.
Or depending on how many items need the conversion, add the conversions manually.
Also try whatever you are doing in the IS manually on the page. You might get a better idea of the validations on From Unit that way. It can't be blank, so your IIf statement that assigns it empty string is going to cause an error.