Re: Cost Manipulation

["Bailey, Dick" <Dick.Bailey@xxxxxxxx>]

	I'm not sure I follow all this - but since we are reviewing that
process here I thought I would point out that if you have outside
process shop orders and costs you need to be concerned with updating the
routings costs.

	Dick Bailey
	MCFA 

-----Original Message-----
From: bpcs-l-bounces+dick.bailey=mcfa.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+dick.bailey=mcfa.com@xxxxxxxxxxxx] On Behalf Of
Bill
Sent: Tuesday, November 27, 2007 10:11 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: Re: [BPCS-L] Cost Manipulation

Al Mac Wheel wrote:
> My tentative approach plan:
> * create logical file join-CJ1
> ** CMF cost master, only cost set-1 actual, joined to IIM item master,

> only items of those raw classes that he wants to have actual used in 
> the new cost set
> * create logical file join-CJ2
> ** CMF only cost set-2 standard with IIM all other items (than those 
> in join CJ1)
> * in theory all items should be in join CJ1 or CJ2 except any that 
> lack standard or actual cost

Al,

I'm having a bit of time trying to determine what you say up there, but
I think I have the basics.  You should be able to run something similar
to the following SQL:

Insert into newlib/cmf
   (Select * from oldlib/cmfl01 c
     Where cffac='xx' and cfcset=99 and exists (Select * from IIML01
Where iprod=c.cfprod and iityp='X')


If you were changing the cost set identifier say from 99 to 98, then you

have to mention every field in the statement, like this:

Insert into newlib/cmf
   (Select cfid, cfprod, cffac, 98, cfcbkt, cftlvl, cfplvl   from 
oldlib/cmfl01 c
     Where cffac='xx' and cfcset=99 and exists (Select * from IIML01
Where 
iprod=c.cfprod and iityp='X')


Bill