Re: CST280 to Excel

[MacWheel99@xxxxxxx]

> Has anyone had experience taking a Costed Bill of Material and sending it 
to 
>  an Excel spreadsheet.   We are looking to do this on a quarterly basis and 
>  then comparing the last quarter costed bills to current. 

No but we have sent copies of our Standard Costs to Simulated Costs before 
making changes in our Overhead rates & other stuff & Cost Rollups then 
afterwards done a comparison of what all changed using combination of vanilla 
BPCS reports & Query/400.

You might check Midrange_L archives on 400 to PC in general ... there are 
some gotchas with respect to Excel properly processing the data - the one I 
remember was garbage in BPCS dates if you did not tell Excel that this was a 
date field.

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax 
interactive & batch) @ http://www.cen-elec.com Central Industries of 
Indiana--->Quality manufacturer of wire harnesses and electrical 
sub-assemblies - fax # 812-424-6838

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---