ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> WO Report Question
http://www.istechforum.com/YaBB.pl?num=1130936057

Message started by cmsk on 11/02/05 at 04:54:17

Title: WO Report Question
Post by cmsk on 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

Title: Re: WO Report Question
Post by JNAPIER on 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

Title: Re: WO Report Question
Post by cathyh on 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.

Title: Re: WO Report Question
Post by Karen Mason on 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).

Title: Re: WO Report Question
Post by cmsk on 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!!

Title: Re: WO Report Question
Post by 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?

Title: Re: WO Report Question
Post by David Waldmann on 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.

Title: Re: WO Report Question
Post by cathyh on 11/04/05 at 10:59:33

cmsk wrote:

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??

Title: Re: WO Report Question
Post by cmsk on 11/16/05 at 07:40:15

Actually Cathy, that makes perfect sense.