Welcome, Guest. Please Login.
05/14/24 at 06:06:17
News:
Home Help Search Login


Pages: 1
Send Topic Print
PR-P & PR-Q showing all employees, not just ac (Read 733 times)
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
PR-P & PR-Q showing all employees, not just ac
06/18/04 at 08:19:57
 
When going into PR-P & PR-Q, if you hit lookup, just the active people show, but when you print a range of people, the report actually includes terminated employees.  
 
Since there are no good employee name/address or name telephone lists, we would like to use the first slot of the review to make these lists.  But I would like to limit it to active employees.
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: PR-P & PR-Q showing all employees, not jus
Reply #1 - 06/18/04 at 08:43:26
 
You could get this in minutes by creating an ODBC link and using Excel to grab the data from BKPRMSTR and filter on the Active (Y/N) field.
 
Just an idea....
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
Re: PR-P & PR-Q showing all employees, not jus
Reply #2 - 06/18/04 at 11:17:49
 
WE MANUALLY TYPE IT INTO A SPREADSHEET...I'M NOT SURE HOW TO DO THE OTHER...ANY ADDITIONAL HINTS WILL BE APPRECIATED.
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
Re: PR-P & PR-Q showing all employees, not jus
Reply #3 - 06/18/04 at 13:50:04
 
Figured out how to do some of this and make some of the fields come up in excel.  
 
What is the name of the field for Job Position?
Back to top
 
 

Karen Mason, Vice President
Bula Forge & Machine, Inc.
1-60# forgings, machining, & assembly
Cleveland, OH
Tel:216-252-7600 Fax:216-252-7601 www.bulaforge.com
EVO-ERP 09/16/09 SP2
Email WWW   IP Logged
Pages: 1
Send Topic Print