Hello there, @amynhemani.

I can see a duplicate post for this exact query you posted. My colleague, JamaicaA, has already answered similar question you've posted. You can view her answer through this thread: Problem with average cost.

Don't hesitate to keep in touch if you need anything else about inventories. As always, the Community is always here to attend to your concerns. Have a great day.