ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Serial Control - Dups, Removing, etc. (SC-A)
http://www.istechforum.com/YaBB.pl?num=1304524155

Message started by AndyOB on 05/04/11 at 08:49:15

Title: Serial Control - Dups, Removing, etc. (SC-A)
Post by AndyOB on 05/04/11 at 08:49:15

We've been banging our heads on SC for a little while now, we're getting duplicate entries when we recieve then assign a serialized item to a WO, we can't just delete an item serial number. If we enter the wrong serial # there's no way to edit the number or just remove it from the system.

It's incredibly confusing. Anyone out there who uses the SC module that we could call and get some questions answered?

Also need some lovin from someone who uses Data Collection, Routings, as well.

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by GasGiant on 05/04/11 at 09:56:07

We use serial control on hundreds of items and multiple BOM levels, so I'd be happy to help. I'm not sure if your post above covers one issue or two. Let me deal with "wrong serial number" first.

When someone here enters the wrong serial number (assigns the wrong # at WO-I), we always back out the WO-I and redo it. The "wrong" serial number will still have a record in the SERIAL.B file (unless you remove it with MDB), but the transactions will be removed. We then redo WO-I with the correct number. We need to have the transactions in there for traceability, so undoing and redoing the transaction is the "right thing to do", so to speak.

When consuming items that have serial numbers, whether via WO-G or backflushing during WO-I, we have trained our people to use F2 to look up the SN and select it from the list. This way they are checking to make sure they have completed WOs placing lower level items into stock and eliminating keying errors.

I'll pause here to make two notes (call them complains, if you like): Firstly, if the serial number you need is not available at this point then you cannot back out of the transaction. you must complete it, even if it means entering a dummy #. Then you have to reverse the transaction and go fix the problem. Second, F2 does not pop up a list of available serial numbers (or lot numbers) like other programs (e.g. IN-L-M), but shows every serial number ever entered for that item.

As to duplicate entries, we have found that performing negative transactions, such as WO or SO for negative quantity, causes DBA/Evo to add a second entry to the SERIAL.B table instead of updating the UOH. Using SC-A can cause the same issue unless you use F2 to look up the serial number before editing.

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by GasGiant on 05/04/11 at 10:24:33

Here's an interesting factoid: just ran SC-F and received a 230 page report of serial number exceptions!

yay :'(

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by AndyOB on 05/05/11 at 10:01:03

thanks, that's a start. Still confusing, but I'll chime in with more questions in a moment I'm sure.

Curious about your two complaints about having to enter in a dummy# then deleting it when you make an entry mistake. My questions is, what do you find is the best way to get issues addressed/fixed in Evo?

I'll have more SC stuff in a moment or two.

-Andy

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by AndyOB on 05/05/11 at 10:57:49

AndyOB wrote:

Hello, This is Franko chiming in here. I also have an issue when assigning SC units to a WO. For instance, if the order calls for 12 units let's say, I have to enter 24 units on the amount column for it to accept my 12...This may be tied to the Duplicating issue you are discussing here...

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by RPCAdmin on 05/05/11 at 11:40:53

Not sure if this will help Franko or not (and I am not sure if I am totally correct :) ) We use serial numbers on repair items and I believe we previously found that if you have serial control turned on for a BOM part AND for the finished good, it will seem to ask for serial numbers twice - just make sure that you notice if it is asking for the serial number for the finished good or for a part of the assembly. Again - Not sure if this will help.

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by AndyOB on 05/10/11 at 09:49:23

So far no luck, we've been working on this for far too long now and no one can seem to tell us (or is willing to remote connect in and see) what is going on.

It seems like issuing inventory to work orders is the problem. Were getting double and quadruple duplicate entries for each serial number, and really have no idea why this is happening. We're trying to follow what documentation is available online, but even following verbatim were getting all these problems.

We are not serializing finished goods, but we eventually want to start putting serial numbers on everything (with barcodes), so we can achieve better traceability.

Will be looking at this today a bit, any help appreciated.

Andy@Nortra-Cables.com
408-942-1106

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by Kelloggs on 05/10/11 at 10:47:36

AndyOB wrote:

......We are not serializing finished goods......
Andy@Nortra-Cables.com

What type of inventory are you serializing?

:-?

Kelloggs

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by AndyOB on 05/10/11 at 10:52:06

Purchased Goods, when we receive 12 items, we have to tell evo to receive 24 and then it'll let us scan in 12. We have no idea why, but it seems to be related to the problem.

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by Kelloggs on 05/10/11 at 11:15:50

Are you using SC-G? or you are entering your own?
BTW we dont use it.

Are you using location? do you have duplicate location and/or Items on those locations?

:-X

Kelloggs

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by AndyOB on 05/10/11 at 11:43:40

Were not generating serial numbers (for now), were just recording Serial Numbers that have been assigned to incoming purchased goods, specifically power supplies. Assiging them to work orders and making sure the serial number gets printed to packing lists for the customer and so we'll have a record of when certain items shipped.

Don't think were using location, though let me know where I should look and I'll let you know how we have it set.

-A.

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by Kelloggs on 05/10/11 at 12:28:49

So you are serializing both the Purchased Item and the Finish good.

Anyways, on a play company, serialized the Finish Good only, see what happens.
Try to narrow down the problem.

:-[

Kelloggs

BTW: have you contact Lynn?

:P

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by GasGiant on 05/10/11 at 19:19:48

We have some items that are serialized when they come in through receiving and we have no issues entering the numbers. Evo will not let you receive the same number twice. If you are receiving and enter a new serial number it will ask if you wish to add the new number, then it gives you a screen to allow entry of notes.

Once the items are received, you can look up serial availability and see that they are listed correctly and whether there are the same number of serial numbers on hand as there are items.

When issuing parts to WO, do you use WO-G or do you backflush at WO-I?

Are the items made/created on the WO serialized?

I'll be happy to help, but if you are looking for IS Tech to jump in, then this thread needs to be in the Problems section. I can make myself available on Wednesday for a phone call where we can walk through the steps on our test companies simultaneously, if that would help.

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by AndyOB on 05/11/11 at 07:52:31

I am using WO-G

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by dameng on 05/19/11 at 09:17:25

interesting read.
what version of DBA or EVO are you using to PO-C recieve? what is the date of the module that is being used?

the recieving of 24 to get in 12 serial numbers is definitely from the land of the not quite right.
my system, works correctly. is your serial'd item on the PO, does it have a conversion factor?

i'm available to remote in to your system and walk thru this erroneous behaviour if you'd like.

side note: in regards to the lookups..... i'd like to see more of a Grid for Tagging the serial numbers instead of typing them in when issueing.
and yes, definitely need to fix the entry of Serial numbers maybe so it's processed in a batch..... to where the user can review before saving.

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by carie on 05/19/11 at 10:04:14

I second the review before saving option!!!

Title: Re: Serial Control - Dups, Removing, etc. (SC-A)
Post by AndyOB on 05/24/11 at 06:54:04

dameng wrote:

Using 1/18/2011 - SP1 right now.
I believe were using the DBA modules on PO recieving, not the Evo ones. I'd have to take inventory of our access and let you know. (Been meaning to put everyone on the same Menu access record to elliminate these problems of some people using DBA versions and others using Evo).

If you want, the guy you want to contact is Franko, he's working in purchasing and has been working through these little issues, maybe we can conference call and get something going this week or next (I'm getting married 6/4, so after that I'll be MIA for a few weeks. :).

Drop me a note at andy@nortra-cables.com

Quote:

side note: in regards to the lookups..... i'd like to see more of a Grid for Tagging the serial numbers instead of typing them in when issueing.
and yes, definitely need to fix the entry of Serial numbers maybe so it's processed in a batch..... to where the user can review before saving.

Yeah, That would be nice.