Sage 100

Client using VI payroll import which works fine except that the VI routine brings in terminated employees. Tried to set a conditional based on employee status on the employee number field (since status is not available on select tab) but then all employees fail. Any ideas?

What version, and what data file are you importing into?

Sage2016 pr.dataent

I think you need to create a temp variable and use ""File Assign"" to populate it with a status or perhaps the termination date field from PREMP. then set your conditional based on the value in that temp01$ make sure you assign that temp field AFTER you assign the employee number/division

here is how I would setup that temp variable (make it type string)

Thanks! It worked. I appreciate the help.