Wendy,
I have a set of programs that produce a costed, indented BOM for a chosen Part, Facility, Method Code & Cost Set.
Output is a choice of hard-copy report or Excel file e:mailed to the calling user.
It's old - I originally wrote it in 1999 when we were on BPCS V6.04 and have updated it to work with ERP Lx 8.3.2.
The code is really old-fashioned, but still works.
It's also written specifically for our company, so there are parts that you probably don't need. And choice of cost set is restricted to 02 or 03 (but that shouldn't be hard to expand).
The e:mailing of the Excel file is done by a piece of 3rd party software, RouteOne, that I believe is fairly inexpensive. But you could always just create the file and drop it into Excel via Client/Access data transfer. Depends how automated you want to go.
If you don't get any better offers, contact me off-line at address below and I'll explain further.
Cheers.
Tom Molyneux
NOV Mono
MIS Department
Tel. 0161 214 2142
Fax. 0161 214 2344
E:mail Tom.Molyneux@xxxxxxx
-----Original Message-----
From: bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+tom.molyneux=nov.com@xxxxxxxxxxxx] On Behalf Of Bunch, Wendy
Sent: 09 October 2009 18:33
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Costed Bill of Material
Bpcs v8.2.1
I'm trying to find a Fully Indented Costed bill of material report that
I can run. (really would like to get it to excel)
Like CST280 -- only lets me choose the Method code for the
Bom...currently CST280 does not give you a choice - it pulls the first
method code out there.... This causes problems when adding the costs
back up....
What I really want is a tool to compare my Frozen Standard Costed Bom
(FS method code Bom and FS method code Router with Cost set 03 Frz Std
Cost, with a cost roll I did for 2010 plan - (PS method code Bom, PS
Router, cost set 86) I'd also like to see what unit of 1 cost for the
raws then the extended cost... (currently shows only extended cost)
One step further - I then want to take forecast of Sales by Part number
and pull it down to raw materials for volumes.... Finding which raw
material costs are driving the most variance from Frz Std to New Plan
cost......
Also, why -- why do you get method codes for boms and router but not for
Workcenter rates? - you have to keep everyone out of transaction
processing - change the rates - roll "Plan" costs -- change the rates
back and let everyone back in....
Somebody has to already have a tool or program written that is similar
or know of an inexpensive product?
Wendy Bunch
Wabash Technologies
--
This is the 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: Tom.Molyneux@xxxxxxx
Mono Pumps Limited
Registered in England No. 300721.
Registered Office : Martin Street, Audenshaw, Manchester. M34 5JA
midrange.com
