Hi everyone! I'm trying to fix our Average Cost for some items. One Item in particular has the following: 1. Inventory Worksheet. New qty and Amount are both 0 2. Inv Adjustment. QTY 10. Rate $14.25 Amount $142.50 3. Inv Adjustment. QTY 50. Rate $14.25 Amount $712.50 4. Inv Adjustment. QTY 10. Rate $14.25 Amount $142.50 This makes the QTY 70 and the Amount $997.50 which makes our Average Cost $14.25 (makes sense since everything had a rate of $14.25). The problem is after this was an Inventory Transfer: 5. Inventory Transfer. QTY 1 inv transfers don't have rates or amounts so both $0. This adds 1 to our 70, so now 71 but the total amount is the same $997.50. So now our Average Cost is $14.049 and not the $14.25. How would I fix this problem?

Thank you for this knowledge