I have been asked by a potential client to create a customized version of TIW's Costed Bill of Materials report that will allow them to export the results to an Excel spreadsheet.

I have not previously worked with TIW data, but after looking at the BMREV and BMSL tables I think I basically understand them - but I was wondering if anyone with more experience in this area might know of any "gochias" I should look out for.

One specific question is how the "as of date" for the report relates to the active, inactive and rev fields in BMREV?

Thanks ...