In my opinion you are better off creating a series of iSeries queries that build exactly what you need and the last step would be to output to a file that has all of the data elements that you are looking for, then use the tools in Client Access (If that's your emulator of choice) to load it into excel.

I have built reporting structures for many clients that create a file and the only thing that the client has to do is to use the client add-on in excel to download the report to them in excel.

Feel free to contact me off line for further assistance if you like.

Dan Sweeney - Sr Technical Consultant
PHOENIX Business Consulting, Inc.
Cell: 860.490.6712

-----Original Message-----
From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf Of Bunch, Wendy
Sent: Friday, October 09, 2009 1:33 PM
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

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.