Re: Cost Change Investigation

You might get lucky using one of the methods suggested by Dee Dee,
Roger or Al, but this kind of tracking is not kept by BPCS in an
organized manner, at least not in the release with which I am
familiar.

If your company needs such records, you probably want to buy a
utility.  Al mentioned one.   In the interest of fairness, linked
below is another utility that can changes, notify people, etc.  I have
used it, it works like a charm.  It is used by several pharmaceutical
companies that have BPCS for tracking related to FDA regulation.
--> http://www.innovatum.com/datathread.php

You could also turn on journaling of the CMF table (and probably a few
others), and parse the records if you need answers, or write a trigger
program that logs changes.  On one of the midrange.com lists someone
recently posted a way to setup a trigger via SQL that would only fire
if specific fields changed.

On Tue, 7 Dec 2004 12:14:56 -0600, Lopez, Eduardo   (Tijuana)
<lopeze@xxxxxxxxxxxxxxxxx> wrote:
> 
> Hi,
> 
> A manager came to me and asked me if there's a way to know who made a change
> to the costs and I told him let me see... so, the first thing I thought was,
<<snip>>

-- 
Tom Jedrzejewicz
tomjedrz@xxxxxxxxx