The following is a post I found elsewhere in the forum that matches my problem exactly however it does not seem to work in a client I am currently hoping to upgrade this coming weekend, but we just realized that we had not updated the VI job for this. The only difference between the answer below is that I had to modify it to pad with 5 zeroes because my import file has 7 digits.
Oddly enough, I can't get the employee number to import either even though I'm using the same functions in payroll that are being used in another import job for this client.
_obj'ConvertToEmployeeKey$(Temp004$,Temp007$)
----------
We worked with Scott Brady at Sage and found a solution to our issue with importing into the Production Management WorkTicketKey field with VI.
Our import source file had the last 5 digits of the WT #, not all 12 digits. So we had tried a calculation of temp2("0000000")+temp1(last 5 digits) in the WTKey field. But it would not recognize the WT# and convert it to the key. If all 12 digits of the WT# were in the import file, VI converted the WT# to the WTKey.
Scott Brady sent us this formula and it works with only 5 digits in the import source file.
_OBJ'ConvertToWorkTicketKey$("0000000"+Temp001$)
------------------------------
Scott Firgens
CLA (CliftonLarsonAllen LLP)
------------------------------
------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
------------------------------