# Average cost problem **URL:** \ **Category:** Uncategorized\ **Created:** [October 24, 2024, 9:02am UTC](https://forum.manager.io/t/average-cost-problem/57840 "2024-10-24T09:02:52Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Mian\_Waqas\_Azfar](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mian_waqas_azfar/32/13707_2.png) [@Mian\_Waqas\_Azfar](https://forum.manager.io/u/Mian_Waqas_Azfar)\ **Post date:** [October 24, 2024, 9:02am UTC](https://forum.manager.io/t/average-cost-problem/57840/1 "2024-10-24T09:02:52Z")
I am facing problem in total cost and average cost. i am on server edition, i created new business, added customer, supplier, product, bank etc. Purchased a product from suplier, paid that PI. now system is showing QT available but at zero cost. I dont want to put average cost manually, it should be calculated automatic based on purchase price and QT. Summary is showing " inventory on hand" value zero also. im unable to understand what happened as im using manager for few year and other business are fine, im having this issue only with new business. ![Screenshot 2024-10-24 at 1.59.54 PM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/8/e852491ade00bbd2c680ef3062b86c32df44a409.png) ![Screenshot 2024-10-24 at 2.00.12 PM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/d/9ddb5b3dc4dbee021203be1248489a33de7ca31e.png) ![Screenshot 2024-10-24 at 2.00.22 PM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/c/ac672212cebaeaf65c79f5a3a8ae26eb3268fbd2.png) server version is : 24.6.30.1707 ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [October 24, 2024, 11:30pm UTC](https://forum.manager.io/t/average-cost-problem/57840/2 "2024-10-24T23:30:17Z")
> [@Mian\_Waqas\_Azfar](#): > > I dont want to put average cost manually, it should be calculated automatic based on purchase price and QT. Please see: [https://www.manager.io/guides/inventory-revaluations](https://www.manager.io/guides/inventory-revaluations) Now, I know that periodic inventory revaluation is not popular with many users. I think there is something in terms of usability that I’m missing to make it good. Periodic inventory revaluation is solving all the edge-cases I was struggling with under perpetual inventory revaluation. So while I’m certain periodic inventory revaluation is the way to go, I didn’t quite nail down how to make it good. ---
**Author:** ![tony](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tony/32/17755_2.png) [@tony](https://forum.manager.io/u/tony)\ **Post date:** [October 25, 2024, 1:10am UTC](https://forum.manager.io/t/average-cost-problem/57840/3 "2024-10-25T01:10:55Z")
Perhaps the option of switching off the automated inventory revaluation function, if the main issue relates to processing performance. Otherwise a warning - the latest inventory valuation excludes certain transactions and needs to be updated. ---
**Author:** ![Mian\_Waqas\_Azfar](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mian_waqas_azfar/32/13707_2.png) [@Mian\_Waqas\_Azfar](https://forum.manager.io/u/Mian_Waqas_Azfar)\ **Post date:** [October 25, 2024, 9:00am UTC](https://forum.manager.io/t/average-cost-problem/57840/4 "2024-10-25T09:00:28Z")
I am very much confused and it was already automatic process and inventory in hand was showing as assets and that was perfectly fine as a accounting rules. Cost of total purchase invoices and total quantity for those purchase invoices can determine average cost of that product so why we had to do it manually? It looks like time taking process that we have to use some manual process while we are using the software. Also, there is no inventory revaluation option in setting for me. In using admin account ![IMG_5679](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/e/aea305fbee94134f7b9da9188b11a078acdde5e9.jpeg) ![IMG_5678](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/b/5bd5b63093ba07e225d9564760925c2072d5ca7a.jpeg) @lubos . Is it possible to use purchase invoice data to automatically determine value of “inventory in hand” as asset? I like that more. ---
**Author:** ![Mian\_Waqas\_Azfar](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mian_waqas_azfar/32/13707_2.png) [@Mian\_Waqas\_Azfar](https://forum.manager.io/u/Mian_Waqas_Azfar)\ **Post date:** [October 25, 2024, 9:13am UTC](https://forum.manager.io/t/average-cost-problem/57840/5 "2024-10-25T09:13:34Z")
> Periodic inventory revaluation is solving all the edge-cases I was struggling with under perpetual inventory revaluation. So while I’m certain periodic inventory revaluation is the way to go, I didn’t quite nail down how to make it good. Can you make process ( Using the Inventory Revaluation Worksheet) automatic ? With manual process and daily 10-15 PIs, specially when same product is being purchase from different vendors from different cities in different price , assets will show wrong data because no one will use “revaluation process” after every PI ---
**Author:** ![eko](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@eko](https://forum.manager.io/u/eko)\ **Post date:** [October 25, 2024, 9:38pm UTC](https://forum.manager.io/t/average-cost-problem/57840/6 "2024-10-25T21:38:08Z")
> [@lubos](#): > > So while I’m certain periodic inventory revaluation is the way to go It isn’t for a perpetual system as mentioned in another topic. It is a step backward and I hope that you figure it out. ---
**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\ **Post date:** [October 27, 2024, 9:36pm UTC](https://forum.manager.io/t/average-cost-problem/57840/7 "2024-10-27T21:36:45Z")
> [@Mian\_Waqas\_Azfar](#): > > Can you make process ( Using the Inventory Revaluation Worksheet) automatic ? > With manual process and daily 10-15 PIs, specially when same product is being purchase from different vendors from different cities in different price Have a look at this new approach. > [@Streamlined workflow for revaluating inventory items](https://forum.manager.io/t/streamlined-workflow-for-revaluating-inventory-items/57921): > > The latest version (24.10.28) is streamlining workflow when using periodic inventory revaluation. Going to Reports tab, creating a revaluation worksheet, then viewing it, then copying results to new Inventory Revaluation etc. It’s too many steps. In the latest version, the number of steps has been greatly reduced. If you have Average Cost column visible under Inventory Items tab, you will see new Recalculate button above the column name. Clicking on the button will recalculate aver… I think it should be much easier to recalculate your average costs now.