Welcome, Guest. Please Login.
05/15/25 at 07:15:00
News:
Home Help Search Login


Pages: 1
Send Topic Print
WO Report Question (Read 876 times)
cmsk
Senior Member
****




Posts: 279
WO Report Question
11/02/05 at 04:54:17
 
Hi there,  
 
we have a need to "segragate" certain WO on a printed report... more specifically, Sales WO's and Stock WO's.  Is there a flag to do this somehow?  I thought of simply putting an 'S' in front of the WO #, but alas, the field doesn't accept letters.  Can this be done?  If so how?
 
Many thanks
Chris
Back to top
 
 

--
Thank you
Chris Simo-Kinzer
Vice President
brookfield industries, inc.

Evo-ERP 2017.2 Build 4.5.17 Update T7-7i R11
Pervasive 9.5
Email WWW cmskbii   IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: WO Report Question
Reply #1 - 11/02/05 at 06:19:57
 
On stock WO's we start the WO # with 99xxx-x and for sales we use a different #. The WO's have a different # range and can be reported seperate.
 
John
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: WO Report Question
Reply #2 - 11/02/05 at 06:53:25
 
That's what we do also.  It works for us!
Also, if you build for stock you should have STOCK as the customer code.  It's automatically put there by DBA.  You can sort by customer code.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Karen Mason
Active Member
*****


Ain't life grand!?!

Posts: 728
Gender: female
Re: WO Report Question
Reply #3 - 11/02/05 at 06:57:55
 
We also segregate same as John, only we break down WO further.  Certain large customers have their own series of numbers, as well as segregating tool & die orders/repairs, Accumulations for indirect labor, and assets(new or major repairs).
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
cmsk
Senior Member
****




Posts: 279
Re: WO Report Question
Reply #4 - 11/02/05 at 07:14:45
 
Great tips all, thank you... I can't believe how easy that turned out to be.  The customer code actually works perfectly... and I can't believe I missed that... D'OH!!
Back to top
 
 

--
Thank you
Chris Simo-Kinzer
Vice President
brookfield industries, inc.

Evo-ERP 2017.2 Build 4.5.17 Update T7-7i R11
Pervasive 9.5
Email WWW cmskbii   IP Logged
cmsk
Senior Member
****




Posts: 279
Re: WO Report Question
Reply #5 - 11/02/05 at 08:39:06
 
One odd thing though... when using F2 to lookup a customer code, STOCK doesn't list.  If I simply type STOCK in the customer code field, it does work, but why wouldn't STOCK come up in the Find list?
Back to top
 
 

--
Thank you
Chris Simo-Kinzer
Vice President
brookfield industries, inc.

Evo-ERP 2017.2 Build 4.5.17 Update T7-7i R11
Pervasive 9.5
Email WWW cmskbii   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: WO Report Question
Reply #6 - 11/03/05 at 05:08:47
 
We use the SO number if it's for Sales (either by SO-N or manually using the SO#), and auto-assigned WO numbers if it's for stock. Since those number ranges are far apart it's easy to separate them.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: WO Report Question
Reply #7 - 11/04/05 at 10:59:33
 
Quote from cmsk   on 11/02/05 at 08:39:06:
One odd thing though... when using F2 to lookup a customer code, STOCK doesn't list.  If I simply type STOCK in the customer code field, it does work, but why wouldn't STOCK come up in the Find list?

 
I suspect, and Lynn would have to confirm, that the lookup key goes to the customer file not the work order file  customer field.  Since you don't have stock set up as a customer code, it doesn't show up in the customer code lookup using the F2 key.  But when you type it in as a work order customer code, it is in the list of work orders with the customer code STOCK.  
Does this make any sense??
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
cmsk
Senior Member
****




Posts: 279
Re: WO Report Question
Reply #8 - 11/16/05 at 07:40:15
 
Actually Cathy, that makes perfect sense.
Back to top
 
 

--
Thank you
Chris Simo-Kinzer
Vice President
brookfield industries, inc.

Evo-ERP 2017.2 Build 4.5.17 Update T7-7i R11
Pervasive 9.5
Email WWW cmskbii   IP Logged
Pages: 1
Send Topic Print