Re: Duplicate Items in Item Master

Years ago, before we had proper power protection, we have had weird stuff
happen to files, including item master, when our system had power outage
going down hard.

We don't have ordinary users uploading data for BPCS, but we have had
managers trying to do it, or ask consultants to do it, with me finding out
by accident, and speaking up about this risking loss of BPCS working right.

There are a handful of scenarios where I have shown people how to use DFU to
fix some BPCS scenario, such as in-use flag.

When we were on INFOR tech support, they taught a manager how to use
interactive SQL to fix problems in some BPCS files.

-
Al Mac
-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On
Behalf Of Larenzo Alexander
Sent: Monday, September 26, 2011 8:39 AM
To: BPCS Forum Post
Subject: [BPCS-L] Duplicate Items in Item Master

We're on BPCS v6.1 and MRP wasn't planning some items correctly and after
some research I found out that their were duplicate item numbers in the Item
Master & Facility Planning data and it caused a few issues even when the
user tried to delete one of the duplicates it consfused some programs. So to
reslove the issue I had to delete the duplicated items and items that had
duplicates and let the user re create items and then they had to recreate
the customer orders. So the issue is resloved but I was wondering has anyone
else had an issue with the Item Master allowing duplicate items to be
created. It normally checks for duplicates and prevents this so I'm not sure
how this was possible in this instance. This was a stranger one but I as
they say... Anything is possible. :-)
 
 
Thanks