ISTech Support Forum - Exporting Payroll Data

Welcome, Guest. Please Login.

	05/16/24 at 20:32:26 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Payroll

‹ Previous topic | Next topic ›

Pages: 1

Exporting Payroll Data (Read 1207 times)

friske13 Browser Cats rule! Posts: 9	Exporting Payroll Data 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
Back to top	IP Logged

rphitch Browser Posts: 43	Re: Exporting Payroll Data Reply #1 - 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
Back to top	IP Logged

friske13 Browser Cats rule! Posts: 9	Re: Exporting Payroll Data Reply #2 - 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
Back to top	IP Logged

aricon Active Member Systems Consulting-See website for products! Posts: 1283 Gender:	Re: Exporting Payroll Data Reply #3 - 07/28/04 at 17:39:21 If memory serves, all the information you are looking for is in BKPRMSTR.
Back to top	Sincerely, Lorne Rogers President Aria Consulting & Implementers Ltd. Phone: (780) 471-1430 Fax: (780) 471-4918 E-mail: lrogers@ariaconsulting.net IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: Exporting Payroll Data Reply #4 - 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.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

aricon Active Member Systems Consulting-See website for products! Posts: 1283 Gender:	Re: Exporting Payroll Data Reply #5 - 07/28/04 at 19:11:51 Ah well....so much for pure memory, huh?
Back to top	Sincerely, Lorne Rogers President Aria Consulting & Implementers Ltd. Phone: (780) 471-1430 Fax: (780) 471-4918 E-mail: lrogers@ariaconsulting.net IP Logged

friske13 Browser Cats rule! Posts: 9	Re: Exporting Payroll Data Reply #6 - 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?
Back to top	IP Logged

aricon

Active Member

Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male

Re: Exporting Payroll Data
Reply #7 - 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.

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net

IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Payroll

‹ Previous topic | Next topic ›