Hi Diane,
We’ve been able to do this without needing to copy the database, the standard cost changes don’t take effect until the cost group is posted.
You can use a BAQ to compare the values in the CostPart table (‘new’ costs) against the PartCost table (current standard cost). We do this for every part in a given cost group, then multiply by the qty on hand to give us an overall cost impact of the rollup prior to posting.
Many thanks,
Nathan