Sage 100

2018 - Anyone know if it is possible to do a conditional field in VI on an Array or a list without using Perform Logic? I have a client importing into Bill of Materials and there are 4 Bill Numbers being imported that don't match up. If I could use Alias Bill Numbers, I would be all set! So I am hoping to be able to do a conditional on a temp. I.e. Temp001$ is one of [S, SS, SP, 20P]. Otherwise, does anyone have a VI import where they are doing multiple temp fields against a single field in Sage that I can use as an example? I cannot seem to wrap my brain around this one. TIA!

It's because it's not like Crystal (or any other multiple IF statement). You have to just assign a value based on ONE conditional, then the next line you assign a value based on the SECOND Conditional, etc. When you run it, you will have 4 lines, and only ONE of them should have a conditional that is true. The others should say NOT ASSIGNED.

@BethBowers right, thanks for the reminder. The issue I face is it is not just 4 or 5 values, so if it were like crystal or excel it would have an open ELSE statement. So the TRUE condition needs to be if it is not equal to any of the prior 4 conditions... So can I do that? In the example below, what is the last statement? Temp001$ = ""20p"" ASSIGN ""SQP"" Temp001$ = ""S"" ASSIGN ""SCRAP"" Temp001$ = ""SS"" ASSIGN ""SCRAPS"" Temp001$ = ""SP"" ASSIGN ""SCRAPP"" Temp001$ <> ???? REPLACE Column 4

Temp001$ <>""SP"" and Temp001$<>""20p"" and Temp001$<>""S"" and Temp001$<>""SP"" - that's your whole conditional

Thanks @BethBowers !!! I knew I was making it more complicated than it needed to be :)

I always find it hard to switch between Crystal and VI thinking.

Tip: you'll probably have to set your Temp fields to be Key Assigns Only.