Sage 100

Version 2014 Adv, need some help with VI Temp fields. I am exporting RMA's, and I want the field in column 8 to say the full spelling of ""Stock"", ""Scrap"" or ""None"", based on the value in the Item Action field (Sage has it as S, P, N). I created 3 Temp fields each with a calculation / condition (i.e.""ItemAction$=""S"" / ""Stock""). All 3 temp fields are assigned to Col 8. The problem I am having is that when a condion is NOT met, VI is exporting a blank column and when the condition is met it is exporting into the next column, 9 or 10. The data is ending up in either column 8, 9 or 10. I need the data to be in same column, 8 in this case. Tried all kind of things but nothing seems to work. Crystal export would work but not a good option for this project. Any ideas? TIA

That confirms what I thought I noticed once - the export doesn't even look at the column code but just exports out in the order the lines are input...

Yes Beth, I even changed the column to 7, hoping it would end up in 8 but it still went into 9 or10

Would an Excel query get close??

Thnaks Jeff, that's what I ended up doing. I was hoping to automate the process by automatically starting the VI Job thru a batch process. Instead the user is refreshing the query and manually sending the file out.

Didn't see this til too late... probably could have gotten away w/ one temp variable and use the TBL() command.

@RandyMarion, not too late, could still use your input as I'm not sure what the TBL() command does or how to use it. Will take a look but any help is much appreciated. Thanks

Try assigning a calculation to a temp variable tbl(pos(ItemAction$=""SPN""),""N/A"",""Stock"",""Scrap"",""None"")

Thanks very much Randy. Will try it as soon as I'm back from Summit and let you know.