Has anyone other than Scott had any luck with this?
Scott's situation is an exact matches to my problem exactly however it does not seem to work in my 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$)
------------------------------
Thomas Rogers (TomTarget)
Target System Technology, Inc.
------------------------------
Original Message:
Sent: 09-29-2022 11:22
From: Scott Firgens
Subject: Importing Production Management (v2022 Sage Rewrite) Transactions - Any Progress???
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)
------------------------------
Original Message:
Sent: 09-22-2022 18:00
From: Jeff Schwenk
Subject: Importing Production Management (v2022 Sage Rewrite) Transactions - Any Progress???
Where do you locate this without DFDM? Modify the inquiry screen to display it? And if you have multiple WT's?
------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
Original Message:
Sent: 09-22-2022 17:18
From: Scott Firgens
Subject: Importing Production Management (v2022 Sage Rewrite) Transactions - Any Progress???
We tried the WT No originally and that failed. Only importing the WT Key worked.
------------------------------
Scott Firgens
CLA (CliftonLarsonAllen LLP)
Original Message:
Sent: 09-22-2022 12:04
From: David Overholt
Subject: Importing Production Management (v2022 Sage Rewrite) Transactions - Any Progress???
I have not imported into 2022, but have you tried importing the work ticket number into the KEY field? I would expect the business logic to translate the number to the key automatically like it does for GL account number/account Key and payroll employee numbers