ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Payroll >> Exporting Payroll Data
http://www.istechforum.com/YaBB.pl?num=1090016769

Message started by friske13 on 07/16/04 at 14:26:09

Title: Exporting Payroll Data
Post by friske13 on 07/16/04 at 14:26:09

Does anyone have experience with exporting payroll data? I need to be able to export the current payroll information to our bank in a delimited format.

Bonnie

Title: Re: Exporting Payroll Data
Post by rphitch on 07/20/04 at 07:33:28

Its easy enough to do in the export data program (DE-A) in the system manager. My question is what do they need, because that determines what file to exoprt from. You also need to have adequate security to operate that program.

R Hitch

Title: Re: Exporting Payroll Data
Post by friske13 on 07/28/04 at 14:53:48

Fields to be exported after each pay period are: employee name, check number, net pay, and payroll date.

I have been experimenting with this, but so far have not been able to come up with e the information requested!

B Friske

Title: Re: Exporting Payroll Data
Post by aricon on 07/28/04 at 17:39:21

If memory serves, all the information you are looking for is in BKPRMSTR.

Title: Re: Exporting Payroll Data
Post by Lynn Pantic on 07/28/04 at 18:10:20

No, you need to link BKPRMSTR and BKPRHIST - BKPRMSTR will get you the name based on the employee number and BKPRHIST will get the pay detail for a given pay date. BKPRMSTR doesn't contain individual pay detail, just YTD and QTD totals.

Title: Re: Exporting Payroll Data
Post by aricon on 07/28/04 at 19:11:51

Ah well....so much for pure memory, huh? ;)

Title: Re: Exporting Payroll Data
Post by friske13 on 07/30/04 at 16:45:02

I understand about relying on memory!!

And I am almost there with exporting the data - but how do I link the two files so that the employee names are on the data page - or can they be on the same page?

Title: Re: Exporting Payroll Data
Post by aricon on 07/31/04 at 12:25:50

You need to do 2 exports. Then bring up the files in Excel and you can copy the data from one to the other as appropriate. An easier method would be to create an ODBC instance and then use the ability in Excel to create a query where both files would be in the query and linked via the key data field and then you can refresh this data each time you would open that saved Excel file.