401k export

system · March 19, 2001, 11:25am

Thanks, Jerry.

Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
16335 814-333-6331 fax: 814-337-2548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>

-----Original Message-----
From: Jerry Boyle [mailto:jboyle@...]
Sent: Monday, March 19, 2001 10:40 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 401k export

Terry, here is the one we use, but it does not include all the info you
need:

for each PRChkDed Where PRChkDed.Company = cur-comp
and (PRChkDed.DeductionID = '401k' or
PRChkDed.DeductionID = 'EMPLR'or
PRChkDed.DeductionID = 'LOAN') and
PRChkDed.Voided = no and
PRChkDed.CheckDate = 03/02/01 no-lock,
each PREmpDed Where PREmpDed.Company = PRChkDed.Company
and PREmpDed.EmpLink = PRChkDed.EmpLink
and PREmpDed.DeductionID = PRChkDed.DeductionID
and PREmpDed.DeductionNum = PRChkDed.DeductionNum no-lock,
each PREmpMas Where PREmpMas.Company = PRChkDed.Company
and PREmpMas.EmpLink = PRChkDed.EmpLink no-lock
By PRChkDed.EmpLink:

Jerry Boyle, IS Manager
Sipco Molding Technologies
Meadville, Pa. 16335-6725
814.724.2243
Visit our web site at www.sipco.com

I need to export the basic employee information along with current hours
worked for period, gross compensation for the period, current employee
pre-tax deferral, current employee matching contribution, employee loan
repayment, current employer base contribution. All this will be exported to
a CSV file for transmission to the plan administrator.

Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
16335 814-333-6331 fax: 814-337-2548 tlw@...
<mailto:tlw@...> www.chipsco.com < http://www.chipsco.com/>

Yahoo! Groups Sponsor
Click Here to Find Software Faster
Click Here to Find Software Faster
<http://rd.yahoo.com/M=162801.1342103.2934627/D=egroupmail/S=1700007183:N/A=
599088/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_Comput
ersInternet_Software_WhiteGridTime&t=ad>

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

[Non-text portions of this message have been removed]

system · March 19, 2001, 9:51am

Anyone have a 401k export routine they are using and wouldn't mind sharing?

Thanks.

Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
16335 814-333-6331 fax: 814-337-2548 tlw@... www.chipsco.com

system · March 19, 2001, 9:59am

What exactly are you looking for?

Terry Williams wrote:

>
> Anyone have a 401k export routine they are using and wouldn't mind sharing?
>
> Thanks.
>
> Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
> 16335 814-333-6331 fax: 814-337-2548 tlw@... www.chipsco.com

system · March 19, 2001, 10:12am

I need to export the basic employee information along with current hours
worked for period, gross compensation for the period, current employee
pre-tax deferral, current employee matching contribution, employee loan
repayment, current employer base contribution. All this will be exported to
a CSV file for transmission to the plan administrator.

Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
16335 814-333-6331 fax: 814-337-2548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>

-----Original Message-----
From: Joe Konecny [mailto:jkonecn@...]
Sent: Monday, March 19, 2001 10:00 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 401k export

What exactly are you looking for?

Terry Williams wrote:

>
> Anyone have a 401k export routine they are using and wouldn't mind

sharing?

>
> Thanks.
>
> Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
> 16335 814-333-6331 fax: 814-337-2548 tlw@... www.chipsco.com

Yahoo! Groups Sponsor
Click Here to Find Software Faster
Click Here to Find Software Faster
<http://rd.yahoo.com/M=162801.1342103.2934627/D=egroupmail/S=1700007183:N/A=
599089/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_Comput
ersInternet_Software_WhiteGridOptions&t=ad>

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

[Non-text portions of this message have been removed]

system · March 19, 2001, 10:15am

What do you want to do this with? Do you have provision?
If so what version?

Terry Williams wrote:

>
> I need to export the basic employee information along with current hours
> worked for period, gross compensation for the period, current employee
> pre-tax deferral, current employee matching contribution, employee loan
> repayment, current employer base contribution. All this will be exported to
> a CSV file for transmission to the plan administrator.
>
> Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
> 16335 814-333-6331 fax: 814-337-2548 tlw@...
> <mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>
>
> -----Original Message-----
> From: Joe Konecny [mailto:jkonecn@...]
> Sent: Monday, March 19, 2001 10:00 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] 401k export
>
> What exactly are you looking for?
>
> Terry Williams wrote:
> >
> > Anyone have a 401k export routine they are using and wouldn't mind
> sharing?
> >
> > Thanks.
> >
> > Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
> > 16335 814-333-6331 fax: 814-337-2548 tlw@... www.chipsco.com

system · March 19, 2001, 10:26am

I don't have provision. I'm gonna use the Vantage export utility. I just
don't want to reinvent the wheel if anyone else already has it.

Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
16335 814-333-6331 fax: 814-337-2548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>

-----Original Message-----
From: Joe Konecny [mailto:jkonecn@...]
Sent: Monday, March 19, 2001 10:15 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 401k export

What do you want to do this with? Do you have provision?
If so what version?

Terry Williams wrote:

>
> I need to export the basic employee information along with current hours
> worked for period, gross compensation for the period, current employee
> pre-tax deferral, current employee matching contribution, employee loan
> repayment, current employer base contribution. All this will be exported

to

> a CSV file for transmission to the plan administrator.
>
> Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
> 16335 814-333-6331 fax: 814-337-2548 tlw@...
> <mailto:tlw@...> www.chipsco.com < http://www.chipsco.com/>
>
> -----Original Message-----
> From: Joe Konecny [mailto:jkonecn@...]
> Sent: Monday, March 19, 2001 10:00 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] 401k export
>
> What exactly are you looking for?
>
> Terry Williams wrote:
> >
> > Anyone have a 401k export routine they are using and wouldn't mind
> sharing?
> >
> > Thanks.
> >
> > Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
> > 16335 814-333-6331 fax: 814-337-2548 tlw@... www.chipsco.com

Yahoo! Groups Sponsor
Click Here to Find Software Faster
Click Here to Find Software Faster
<http://rd.yahoo.com/M=162801.1342103.2934627/D=egroupmail/S=1700007183:N/A=
599088/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_Comput
ersInternet_Software_WhiteGridTime&t=ad>

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

[Non-text portions of this message have been removed]

system · March 19, 2001, 10:39am

I have a provision solution but chances are you would
want to modify it slightly to meet you needs.

Terry Williams wrote:

>
> I don't have provision. I'm gonna use the Vantage export utility. I just
> don't want to reinvent the wheel if anyone else already has it.
>
> Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
> 16335 814-333-6331 fax: 814-337-2548 tlw@...
> <mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>
>
> -----Original Message-----
> From: Joe Konecny [mailto:jkonecn@...]
> Sent: Monday, March 19, 2001 10:15 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] 401k export
>
> What do you want to do this with? Do you have provision?
> If so what version?
>
> Terry Williams wrote:
> >
> > I need to export the basic employee information along with current hours
> > worked for period, gross compensation for the period, current employee
> > pre-tax deferral, current employee matching contribution, employee loan
> > repayment, current employer base contribution. All this will be exported
> to
> > a CSV file for transmission to the plan administrator.
> >
> > Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
> > 16335 814-333-6331 fax: 814-337-2548 tlw@...
> > <mailto:tlw@...> www.chipsco.com < http://www.chipsco.com/>
> >
> > -----Original Message-----
> > From: Joe Konecny [mailto:jkonecn@...]
> > Sent: Monday, March 19, 2001 10:00 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] 401k export
> >
> > What exactly are you looking for?
> >
> > Terry Williams wrote:
> > >
> > > Anyone have a 401k export routine they are using and wouldn't mind
> > sharing?
> > >
> > > Thanks.
> > >
> > > Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
> > > 16335 814-333-6331 fax: 814-337-2548 tlw@... www.chipsco.com
>

system · March 19, 2001, 10:39am

Terry, here is the one we use, but it does not include all the info you
need:

for each PRChkDed Where PRChkDed.Company = cur-comp
and (PRChkDed.DeductionID = '401k' or
PRChkDed.DeductionID = 'EMPLR'or
PRChkDed.DeductionID = 'LOAN') and
PRChkDed.Voided = no and
PRChkDed.CheckDate = 03/02/01 no-lock,
each PREmpDed Where PREmpDed.Company = PRChkDed.Company
and PREmpDed.EmpLink = PRChkDed.EmpLink
and PREmpDed.DeductionID = PRChkDed.DeductionID
and PREmpDed.DeductionNum = PRChkDed.DeductionNum no-lock,
each PREmpMas Where PREmpMas.Company = PRChkDed.Company
and PREmpMas.EmpLink = PRChkDed.EmpLink no-lock
By PRChkDed.EmpLink:

Jerry Boyle, IS Manager
Sipco Molding Technologies
Meadville, Pa. 16335-6725
814.724.2243
Visit our web site at www.sipco.com

I need to export the basic employee information along with current hours
worked for period, gross compensation for the period, current employee
pre-tax deferral, current employee matching contribution, employee loan
repayment, current employer base contribution. All this will be exported to
a CSV file for transmission to the plan administrator.

Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
16335 814-333-6331 fax: 814-337-2548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>