Welcome, Guest. Please Login.
05/17/24 at 20:46:42
News:
Home Help Search Login


Pages: 1
Send Topic Print
UT-K-G (Read 1700 times)
Prier Products
Full Member
***


I Love YaBB 2!

Posts: 107
UT-K-G
06/17/14 at 11:27:19
 
Good afternoon,
We have a mystery we would like to solve. We ran UT-K-G twice in the month of May.  Both listed a particular part number twice. The first UT-K-G ran did not add the second line of the part number in to the summary of changes, but the second did. We just found out that the part number is listed twice in our system. How do we get rid of one? Which one should we choose to delete/make obsolete?
Back to top
 
 
  IP Logged
Prier Products
Full Member
***


I Love YaBB 2!

Posts: 107
Re: UT-K-G
Reply #1 - 10/02/14 at 03:34:17
 
If you are experiencing this problem as well, run SM-J-C Master Level, Method A. This worked for us.
Back to top
 
 
  IP Logged
Vman
Senior Member
****


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

Posts: 460
Gender: male
Re: UT-K-G
Reply #2 - 10/16/14 at 14:34:30
 
SM-J-C Transaction level has methods A and B.  Master level does not.  Anyways, EVO (at least in the years I have used it) has the habit or creating partial part number records, normally in the Inventory Master File Manufacturing.  If you look at the file using Maintain Database, the duplicate record or shell will be incomplete. I have had dupes as well as junk records (like part number "M") popup when I run SM-J-C Master.  I wonder if sometimes this happens when you are in IN-B and exit out without completing an entry.
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: UT-K-G
Reply #3 - 10/16/14 at 15:15:14
 
No only duplicates, some tables have orphan records
 
Anyways.......
 
SELECT BKIC_PROD_CODE, COUNT(*) TotalCount
FROM BKICMSTR
GROUP BY BKIC_PROD_CODE
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC
 
Go to System Mgr
Open DE-A
 
Paste the query, and click on "Execute"
 
if you don't have that menu go to
System Mrg  
Open UT-A  
and enter: SQLEXPORT.RWN  
 
You got Duplicates!!!!   Grin
 
http://www.istechforum.com/YaBB.pl?num=1281714671  
Orphan Records
 
 Cheesy
 
Kelloggs
Back to top
 
 

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


I Love YaBB 2!

Posts: 107
Re: UT-K-G
Reply #4 - 10/17/14 at 06:27:52
 
Thanks Vman and Kelloggs. I was given these instructions by Hec Tech and it definitely cleared the duplicate part number.
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print