Sage 100

Does anyone know if the following is possible with V/I? The client needs to import payroll data entry records. The source file doesn't have an Earnings Code, but it has other values that translate to earnings codes. For instance, when the record has a ""200"", the earnings code should be ""M1""; a ""650"" is earnings code ""SA""; a ""1"" is earnings code ""01"". I thought I could use a temp field to point to that column, and then have the Earnings Code field be a calculation using the Temp field and some kind of condition, or an if/then formula. Nothing I'm trying is working.

Have you tried: Temp field for that column, followed by MULTIPLE lines ASSIGNING the Earnings Codes based on the value of the Temp field.

Beth, that just might do the trick. My syntax isn't erroring out. Thanks!

Make an access database with a translation table and have the VI job read a table that does all the translations you need.

if there are only a few I would use Beth's method and add the earnings code (assigned) 3 times, and each one would have a condition reading from the temp field

On companies with a lot of employees, we go with the Access translation tables. Otherwise, the file assign works very well.