Welcome, Guest. Please Login.
04/29/24 at 06:08:08
News:
Home Help Search Login


Pages: 1
Send Topic Print
Global part number change. (Read 1052 times)
Vman
Senior Member
****


If it ain't broke,
don't fix it

Posts: 460
Gender: male
Global part number change.
11/10/22 at 07:46:07
 
There used to be a program that allowed you to do a global part number change through all the date files using a comma delimited file.    
 Is it still available?
 
Back to top
 
 

EVO-ERP 2022.2
Build 4/22/22
Actican Zen V14 SP2 Workgroup
Win7 64-bit and Win10 Pro
WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Global part number change.
Reply #1 - 11/10/22 at 10:15:28
 
I think this is one
 
SM-J-L Change Part Numbers
 
Purpose of Program
 
Use this program to change a item number across all files in the system that contain records for that item number.  Generally this is used during system start-up when item numbers are subject to revision or as part of an overall renumbering of item numbers.  It can also be used to merge together history of exiting numbers if multiple items were set up that really are the same thing.
 
CAUTION: Be aware that this program changes history files as well as master files.
 
Manual Program Operation
 
Enter the existing item number or look one up via the F2 key (or click on the Lookup button) in the Old Part No field.  Enter the new item number in the New Part No field.  You are then given a warning that this program could take possibly hours to run, depending on the size of your data files.  If you elect to proceed you will see each file name display in sequence as the item number records get changed.
 
Automated Option
 
If you need to change or merge a number of items, you can create a comma delimited file of Old Part, New Part  using Excel and then enter the file name on the top part of the screen.  The program will then ask which information to keep in the event that both parts already exist (a merge).    The program will then step through the file unatttended processing each one.
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Vman
Senior Member
****


If it ain't broke,
don't fix it

Posts: 460
Gender: male
Re: Global part number change.
Reply #2 - 11/16/22 at 15:52:23
 
Yes, that's it.  I couldn;t remember where it was after we ugraded EVO after 14 years.
Thanks,
Back to top
 
 

EVO-ERP 2022.2
Build 4/22/22
Actican Zen V14 SP2 Workgroup
Win7 64-bit and Win10 Pro
WWW   IP Logged
Pages: 1
Send Topic Print