Welcome, Guest. Please Login.
05/20/25 at 03:59:07
News:
Home Help Search Login


Pages: 1
Send Topic Print
Editing serial numbers (Read 554 times)
jfillmore
Browser
*


Small Manuf

Posts: 6
Editing serial numbers
08/23/04 at 13:31:17
 
When my office staff is entering serial numbers in sales orders, it seems something frequently goes wrong. (I wish I could tell you more. )
(1) The system doesn't allow duplicate serial numbers, so we enter numbers followed by -1, -2, -3. Is there a way to enable duplicates, we are just using this system to enable future lookups of when certain serial numbers were shipped.
 
(2) Is there a way to edit serial numbers later?
 
Thanks.
Back to top
 
 
  IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Editing serial numbers
Reply #1 - 08/23/04 at 14:20:04
 
Uhhhh, the concept of duplicate serial numbers is rather contrary to the very basic premise of a serial number......
 
As to editing them, yes, you can. If they aare attached to a Sales Order line they can be edited in BKSOSER and in SERIAL in maintain DB. If not in SO but on a WO you can edit them in WORECV and in SERIAL. If memory serves, these are the tables to be dealt with for editing.
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: Editing serial numbers
Reply #2 - 08/23/04 at 14:31:52
 
Perhaps lot numbers would be more useful than serial numbers?
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
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
Re: Editing serial numbers
Reply #3 - 08/23/04 at 15:23:42
 
JFillmore,
We too use serial #s in a way they weren't supposed to be used....But it works GREAT  for us.
 
Heres how:  We rework, recover, fix, repair our customers' widgets.  Over a yr period we might see the same widget 10-20 times.    The cusomer has already named his widgets something like AZ01, AZ02, ...AZ87 etc.
 
Everytime we do something to widget we use the customers number, add the inverted date, and then abbreviate the process.  
 
So when a customer calls and wants to know what we have done to AZ49....we just print the report which would look something like this:
 
w#         y/m/d    process
AZ49 20040113 grind
AZ49 20040203 beari
AZ49 20040228 grind
AZ49 20040411 grind
Az49 20040526 beari
AZ49 20040730 grind
 
We can tell the customer we ground it 4 times since January and put bearings on it twice.  
We are also able to print a neat concise for our customer.  It also very easy to export to an EXCEL spreadsheet.
 
As for editing serials #s,  Idid it a few yrs back thru Maintain database, can't remember the file names though
 
 
 
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
jfillmore
Browser
*


Small Manuf

Posts: 6
Re: Editing serial numbers
Reply #4 - 09/01/04 at 14:18:53
 
>  Uhhhh, the concept of duplicate serial numbers is rather contrary to the very basic premise of a serial number......  
 
Yea, unless you have to send the same product out again because of a repair (warranty or otherwise).
 
Thanks for information about how to edit and other ideas about how to use serial numbers.
Back to top
 
 
  IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: Editing serial numbers
Reply #5 - 09/01/04 at 20:29:20
 
OK, if you are bringing an item back in that is serialized to do repairs (warranty or whatever), then you need to create a negative 1 quantity SO and select the serial number that the item originally went out under. This will put it back in stock as an on-hand quantity of 1. Do your repairs and such and then send it out again on the SO and that will releive inventory for that serial. WITHOUT using -1, -2, etc.
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
Pages: 1
Send Topic Print