Duplicate Items

Posted by Steve on September 6, 2006, 8:06 pm

Please log in for more thread options

Somehow in One (out of three) Store Ops 1.3, I have created duplicate items
for about 50 products. They have the same Item Number, Supplier, everything.
I know that it is unwise to delete products especially when they have some
movement history as some of these do. So I made the items inactive, cannot
be placed on PO, and blocked sales. But they still show up on my Physical
Inventory, and I am afraid counts are going to be misplaced.

Any suggestions how to correct this properly? Thanks.

Posted by Terrible Tom on September 7, 2006, 11:31 am

Please log in for more thread options

If you have access to CustomerSource, there's a KB article that includes a
set of queries that will merge the item histories, etc. so you can delete the
unwanted duplicate.

Tom

"Steve" wrote:

> Somehow in One (out of three) Store Ops 1.3, I have created duplicate items

> for about 50 products. They have the same Item Number, Supplier, everything.

> I know that it is unwise to delete products especially when they have some

> movement history as some of these do. So I made the items inactive, cannot

> be placed on PO, and blocked sales. But they still show up on my Physical

> Inventory, and I am afraid counts are going to be misplaced.

> Any suggestions how to correct this properly? Thanks.

Posted by Jeff on September 19, 2006, 3:05 am

Please log in for more thread options

Steve,

Check to see if both items have the same internal ID number. If so, you may
have database corruption issues.

--
=

Get Secure! - www.microsoft.com/security

You must be using Outlook Express or some other type of newsgroup reader
to see and download the file attachment. If you are not using a reader,
follow the link below to setup Outlook Express. Click on "Open with
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz

==========

> Somehow in One (out of three) Store Ops 1.3, I have created duplicate

> items

> for about 50 products. They have the same Item Number, Supplier,

> everything.

> I know that it is unwise to delete products especially when they have some

> movement history as some of these do. So I made the items inactive,

> cannot

> be placed on PO, and blocked sales. But they still show up on my Physical

> Inventory, and I am afraid counts are going to be misplaced.

> Any suggestions how to correct this properly? Thanks.