Need help to create Visual Integrator Import function to Sage 4.40 and Kronos
Need help to create Visual Integrator Import function to Sage 4.40 and Kronos
(OP)
I have a Kronos file where it will contain the employee number, earning code and hours to pay. Started programming the VI import function but would like to look at one that's working or if possible have someone create remotely a new VI function to work. Also would like to create a desktop icon to launch the VI import.
Also not sure on how to apply automatic deductions since they are in the program and that data will not come from the Kronos system.
Also not sure on how to apply automatic deductions since they are in the program and that data will not come from the Kronos system.
RE: Need help to create Visual Integrator Import function to Sage 4.40 and Kronos
Visit Sage's Online Community
http://community.sagemas.com/sagemas/?category.id=...
RE: Need help to create Visual Integrator Import function to Sage 4.40 and Kronos
Yes but short on time and would use some help.
I understand version 4.5 has some import jobs already created. Would look into that.
RE: Need help to create Visual Integrator Import function to Sage 4.40 and Kronos
division, employee number, earning code, hours worked
00,0000059,01,00080.00
00,0000142,OT,00001.00
00,0000142,01,00079.25
00,0000163,01,00080.00
00,0000332,01,00080.00
00,0000369,ST,00003.25
00,0000369,SR,00002.00
00,0000369,MR,00000.25
00,0000369,OT,00003.50
00,0000369,01,00076.50
00,0000469,01,00039.75
00,0000469,VC,00040.00
00,0000683,BD,00008.00
00,0000683,01,00072.00
00,0000764,01,00080.00
00,0000921,MR,00002.00
00,0000921,01,00078.00
00,0000921,OT,00003.75
00,0001053,01,00080.00
00,0001053,OT,00000.25
00,0001053,ST,00005.00
00,0001224,01,00080.00
00,0001236,01,00049.50
00,0001273,01,00078.00
00,0001273,OT,00002.00
00,0001372,OT,00000.50
00,0001372,01,00079.75
00,0001445,VC,00008.00
00,0001445,01,00072.00
00,0001607,01,00080.00
00,0001656,ST,00005.00
00,0001656,VC,00008.00
00,0001656,01,00072.00
00,0001894,01,00080.00
00,0002292,ST,00003.25
00,0002292,OT,00000.50
00,0002292,MR,00000.50
00,0002292,01,00080.00
00,0002469,OT,00004.25
00,0002469,01,00079.50
00,0002540,01,00072.00
00,0002605,01,00080.00
00,0002797,SL,00008.00
00,0002797,01,00038.00
00,0002797,MR,00000.25
00,0002867,01,00070.00
00,0002867,OT,00005.00
00,0002867,ST,00002.00
00,0002867,SR,00003.00
00,0002867,SL,00005.00
00,0002983,SR,00000.50
00,0002983,OT,00000.25
00,0002983,ST,00004.50
00,0002983,01,00077.25
00,0003571,OT,00001.25
00,0003571,01,00075.25
00,0003671,01,00080.00
00,0003747,01,00080.00
00,0003787,OT,00005.00
00,0003787,01,00048.00
00,0003801,SR,00005.00
00,0003801,SL,00006.00
00,0003801,OT,00000.50
00,0003801,01,00070.25
00,0003888,OT,00003.00
00,0003888,MR,00001.00
00,0003888,01,00077.00
00,0003910,ST,00000.50
00,0003910,SR,00003.50
00,0003910,OT,00000.50
00,0003910,01,00075.25
00,0004287,MR,00000.50
00,0004287,01,00080.00
00,0004378,ST,00008.00
00,0004378,SR,00001.50
00,0004378,OT,00001.50
00,0004378,01,00078.50
00,0004381,SR,00005.00
00,0004381,01,00013.00
00,0004542,01,00080.00
00,0004578,01,00080.00
00,0004620,MR,00000.50
00,0004620,01,00036.00
00,0004712,SL,00004.50
00,0004712,OT,00001.00
00,0004712,01,00071.50
00,0004755,01,00080.00
00,0004852,OT,00004.00
00,0004852,01,00076.00
00,0005102,01,00072.00
00,0005716,01,00080.00
00,0005722,OT,00002.75
00,0005722,MR,00000.50
00,0005722,01,00078.25
00,0005937,OT,00001.00
00,0005937,MR,00000.50
00,0005937,01,00052.75
00,0006021,ST,00008.75
00,0006021,OT,00001.50
00,0006021,MR,00000.50
00,0006021,01,00080.00
00,0006063,ML,00080.00
00,0006074,BD,00008.00
00,0006074,01,00072.00
00,0006305,01,00080.00
00,0006324,SL,00003.25
00,0006324,01,00076.75
00,0006547,OT,00002.25
00,0006547,01,00079.00
00,0006658,SL,00048.00
00,0006658,01,00032.25
00,0006828,01,00080.00
00,0006983,ST,00005.00
00,0006983,OT,00001.25
00,0006983,01,00080.00
00,0007150,01,00080.00
00,0007282,ST,00005.25
00,0007282,MR,00000.25
00,0007282,01,00080.00
00,0007394,OT,00002.25
00,0007394,MR,00008.50
00,0007394,01,00077.00
00,0007443,OT,00001.00
00,0007443,BD,00008.00
00,0007443,01,00071.00
00,0007686,ST,00009.25
00,0007686,OT,00004.50
00,0007686,MR,00001.75
00,0007686,01,00080.00
00,0007794,01,00080.00
00,0007851,ST,00004.00
00,0007851,SR,00001.00
00,0007851,OT,00001.00
00,0007851,01,00079.00
00,0007883,01,00080.00
00,0007899,VC,00003.00
00,0007899,ST,00001.25
00,0007899,SR,00003.25
00,0007899,OT,00001.50
00,0007899,01,00071.75
00,0008004,ST,00006.50
00,0008004,SR,00003.50
00,0008004,OT,00003.50
00,0008004,01,00076.50
00,0008021,01,00080.00
00,0008142,01,00080.00
00,0008157,01,00079.75
00,0008160,OT,00001.00
00,0008160,01,00079.00
00,0008207,SL,00008.00
00,0008207,01,00072.00
00,0008228,01,00080.00
00,0008417,SM,00008.00
00,0008417,01,00072.00
00,0008554,SM,00008.00
00,0008554,01,00077.00
00,0009293,ST,00004.75
00,0009293,01,00080.00
00,0009354,OT,00002.00
00,0009354,01,00049.00
00,0009487,ST,00004.75
00,0009487,OT,00003.25
00,0009487,MR,00000.75
00,0009487,01,00080.00
00,0009536,SR,00016.00
00,0009537,SL,00008.00
00,0009537,01,00072.00
RE: Need help to create Visual Integrator Import function to Sage 4.40 and Kronos
I recommend that you do real actual data entry on a few employees, then make a VI Export Job so you can see all the data and fields that get created when you do it manually, then start adding fields until you get it right (Or hire someone). The Hire Someone is great if you don't need to learn how to do this stuff for future use, but if you are your companies "Guy" when it comes to this stuff, go in on a Saturday when you won't be bothered and get used to frustration of trial and error. I took a class on VI a number of years ago and didn't get much out of it, it was a very basic setting with little or no take away documentation. VI can be extremely useful so trial and error education is worth the time.
There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That DonÆt.
http://www.thelegacyreturns.com/