Welcome, Guest. Please Login.
05/18/24 at 12:42:07
News:
Home Help Search Login


Pages: 1
Send Topic Print
serial number woes (Read 875 times)
cathyh
Active Member
*****


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

Posts: 1213
Gender: female
serial number woes
05/05/04 at 11:47:22
 
WE have discovered that work order was finished and shipped against a sales order with the wrong serial number entered.  I would like to fix the serial history in DBA.  What files do I need to change in maintain database?
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
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: serial number woes
Reply #1 - 05/05/04 at 14:23:13
 
Has it been invoiced and the invoice posted?
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
cathyh
Active Member
*****


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

Posts: 1213
Gender: female
Re: serial number woes
Reply #2 - 05/05/04 at 14:44:21
 
YES... IT WAS A WHILE AGO.
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
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: serial number woes
Reply #3 - 05/05/04 at 15:23:25
 
Look at the files INVTXN, SERIAL, and BKSOHSER.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1213
Gender: female
Re: serial number woes
Reply #4 - 05/07/04 at 11:35:27
 
Those files fixed it, thanks!  I had to make sure I changed both transactions in the invtxn file, both the work order finish and the sales transaction.  The other tricky part was changing the serial number in the serial file by changing the Key code, not the serial number.  Changing the key changes the serial number automatically.  Changing the serial number first does not change the key.
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
Pages: 1
Send Topic Print