Re: Cost Manipulation

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