Hi - not sure if this is the right place to ask, but I'm looking to get the standard cost for items via a database connection to Netsuite 2.0. I have the standard cost tables and I can generate the right values, but I don't have the effective date ranges that they are applied to the items. I also have the InvReval transactions, and can find the new value amount in the transactionlines, but I can't figure out how to choose the right value for the many lines for each Reval. How do I generate a table with the following format?

start_date, end_date, item, standard_cost_value

Using SuiteTalk? there's a #C2K2RJNAC channel for that maybe you'd have more luck there if so. (not that there's anything wrong posting here 😉 )