RE: Re: Item Costs (Harold Swaanen)

Great Idea!


Roy Luce

Main:   847-540-9635
Cell:   847-910-0884
Fax:    847-620-2799 *new*
Email:  lwl@xxxxxxxxxxxxx

-----Original Message-----
From: bpcs-l-bounces+lwl=ix.netcom.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+lwl=ix.netcom.com@xxxxxxxxxxxx]On Behalf Of
Harold.Swaanen@xxxxxxxxxxxxx
Sent: Wednesday, October 12, 2005 12:55 PM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Re: Item Costs (Harold Swaanen)

In fact what you want to know is the cost in the facility where the Lot is
manufactured. So what you could do is look up the Transaction History (ITH)
file and find out the warehouse where the PR transaction for this Lot took
place. You can retrieve the facility of this warehouse from in the
Warehouse Master (IWM file) and check the Cost Master (CMF File) for the
cost in this facility. I realize this solution requires that you have to
look up the transaction history every time you want to know the cost of a
Lot. What we did to avoid this is enter the facility in the Manufacturer
field of the Lot Master every time you create a new Lot. With that your
logic of creating Lots remains flexible (no prefixes) and you can easily
look up the Lots that are created in a certain facility by running a querie
report that shows you all the Lots with a certain facility code in the
Manufacturer field of the Lot Master.




---------------------------------------------------------------------
Privileged/Confidential Information of BeldenCDT may be contained in
this message. If you are not the addressee of this message, you may
not copy, use or deliver this message to anyone.  In such event, you
should destroy the message and kindly notify the sender by reply
e-mail.

It is understood that opinions or conclusions that do not relate to
the official business of BeldenCDT are neither given nor endorsed by
BeldenCDT.

--
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: lwl@xxxxxxxxxxxxx