Our advanced reports, inventory report, multiple price changer and cost plus changer requires the options to be correctly configured to give correct results. And all options will work better if you follow these rules.
1. Base product used in options should not have any price modifier or cost field entry. You can set them to 0. Base product is used in options to show up in the list of choices for customer.
2. You need to set the sort order on the left side of the product options page to greater than 2 when the product has options that are in addition to options for the product like size, color etc.
3. If the sort order is set to smaller than 3 and the option cost is 0, then it will use the product general tab cost otherwise it will use the cost that was set in the options cost field.
4. If the sort order is set to smaller than 3 and the price modifier is 0, then it will use the product general tab product price otherwise it will use the price modifier that was set in the options price modifier field.