Welcome, Guest. Please Login.
05/10/25 at 22:34:17
News:
Home Help Search Login


ISTech Support Forum › Evo-ERP and DBA Classic › Items ‹ Previous topic | Next topic ›
Pages: 1
Send Topic Print
Inventory Items IN-B (Read 1643 times)
Donna Cardenas
Browser
*




Posts: 24
Gender: female
Inventory Items IN-B
06/10/15 at 12:38:22  
I am noticing duplicate records in my inventory items.  is there a way to remove the duplicate records?
 
They show up on reports as well as in IN-A or IN-B
Back to top
 
 
Donna Cardenas
TechStrand Specialty Wire
Evo-ERP 1/22/10 SP1
Pervasive v10.10
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Inventory Items IN-B
Reply #1 - 06/10/15 at 14:46:10  
I will start by running the SM-J-C Utility.
Run the reconciliation in 'report-only' mode, review the possible changes.
If everything looks reasonable run it again to apply changes.
 
If duplicates still showing, you will have to manually delete them, unless some knows a better way.
 
good luck....
 
 Cool
 
Kelloggs
 
 
Back to top
 
 
Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
BurrKing_Mfg
Member
**


Computer repair can
not be done with a
hammer!

Posts: 66
Gender: male
Re: Inventory Items IN-B
Reply #2 - 06/12/15 at 12:28:18  
That is what I do here.    
bkicmstr and mticmstr are the two files you need to look at.   It has always been the second one that I need to delete.   Which would make sense.  The program is just looking for the first number and never finds the duplicate when inventory values change ect.
Back to top
 
 
12 User Evo-ERP
Pervasive 11
2012r2 Server (needs upgrades)
Evo is fully patched and ready to go
Email WWW   IP Logged
MrMagic
Browser
*


Hello Dum-Dumbs!

Posts: 4
Gender: male
Re: Inventory Items IN-B
Reply #3 - 07/29/15 at 10:16:35  
I've been dealing with this problem manually for quite a while.  I'll remove duplicates, but within a few weeks I've got a whole new set of them from seemingly random items.  Anyone know what causes this or how to stop it?
 
Thanks
Back to top
 
 
Larry Musich - MIS - Concept Laboratories Inc.
Email WWW   IP Logged
BurrKing_Mfg
Member
**


Computer repair can
not be done with a
hammer!

Posts: 66
Gender: male
Re: Inventory Items IN-B
Reply #4 - 07/29/15 at 10:21:52  
If you can figure it out, I would love to know.  But I can never find the connection.  Thought I found it once but could not duplicate when it was happening.
 
When I find a problem that is repeatable, the programmers can fix the problem (and they fix it fast)
 
But random sucks!
 
james
Back to top
 
 
12 User Evo-ERP
Pervasive 11
2012r2 Server (needs upgrades)
Evo is fully patched and ready to go
Email WWW   IP Logged
Pages: 1
Send Topic Print
ISTech Support Forum › Evo-ERP and DBA Classic › Items ‹ Previous topic | Next topic ›

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.

Valid XHTML Valid CSS Powered by Perl Source Forge