Please see FAQ - Manager Forum as also in post 48 in this topic and note:
- Don’t post replies like “Bump”, “+1” or “Agreed." Use the Like button instead.
Please see FAQ - Manager Forum as also in post 48 in this topic and note:
- Don’t post replies like “Bump”, “+1” or “Agreed." Use the Like button instead.
Selling products does not directly affect the average cost of the products remaining in inventory. The average cost calculation is typically based on the cost of the items purchased or produced, not on the selling price. However, here’s how selling products can influence the overall financial picture:
Inventory Valuation: Selling products reduces the quantity of inventory on hand, but it does not change the cost basis of the remaining items. The average cost method still applies to the remaining inventory.
Cost of Goods Sold (COGS): When you sell products, the cost of those products is recorded as the Cost of Goods Sold (COGS) on your income statement. This impacts your gross profit, but the average cost per unit remains the same for inventory valuation purposes.
Replenishment: If you replenish inventory after selling products, the cost of new inventory purchased at different prices will impact the new average cost calculation.
Inventory Management: Effective inventory management ensures that costs are controlled, and the average cost method reflects the actual cost of purchasing or producing goods over time.
In summary, while selling products affects the quantity of inventory and the financial statements, it does not change the average cost of the products remaining in inventory unless new inventory is purchased at different prices.
No one said that it does. (I think you are using weighted average in manager while in FIFO it might change after selling)
And thats why i said you might have sold some qty in between of all those purchase transactions. Selling reduces the weight of current inventory and what you did on your manual calculations (which you have deleted now) was just plain adding purchase amounts and purchase qty and dividing amounts by qty and i said thats not how it works.
And btw your reply looks AI generated. It would be better if you avoid that.
Hi @lubos any solution with this matter ? My retained earning figures still not back to before your inventory update. Changed my historical financial report.
Just check inventory figures on historical reports. Qty figures are going to be okay only difference would be of Unit cost and total amount. Then adjust the unit cost accordingly.
I don’t have the details of the unit cost per items from the past. My inventory consists of thousands SKU.
If you have previously saved pdf inventory value and quantity report, then it could be easily done through Batch update process. All you need is to find the previous Avg cost from these reports and then Batch create inventory unit costs.
Even if that’s not possible i would suggest increase/decrease value of a single item to match overall inventory value to the previous one that’s what i think @lubos suggested a few days ago.
One of the greatest strengths of Manager has always been its ability to track item costs transaction by transaction. This feature was a game-changer, offering unmatched transparency and enabling us to pinpoint exactly how an item’s cost was calculated at any stage.
With the new costing module, this clarity is gone. We can no longer see the step-by-step breakdown of how costs were applied, making it nearly impossible to trace issues or validate financial data. This lack of visibility undermines trust in the system and complicates decision-making for businesses that rely on precise cost tracking.
The old module not only provided accurate costing but also empowered us with full visibility into every transaction. This was the hallmark feature that set Manager apart from other systems, and we strongly urge you to bring it back or allow users the option to toggle between the old and new systems.
Thank you for considering the needs of your users. We hope to see this critical feature restored soon.
Actually it doesn’t help.
We are facing same problem with a question mark sign appearing in unit cost.
So we need to recalculate using batch update. But then each time we need to do this for every new purchase and new production order?
Unfortunately, we cannot do it in the same previous way, a custom report might be a useful with this issue.
It seems that we lost the good old presentation of Cost of Goods Sold forever.
This change is a headache. Hope the developers recognize the customer needs.
@lubos, please can the unit cost be reverted to the previous average cost we are using, which calculates inventory automatically? the current inventory recalculate is really giving headache and it affecting profit margin report, take a look at the image below
in the screenshot above please take a look at cost of semo, the cost of semo is 7,477,690.42 and the total cost that is supposed to show the same figure but it was showing 5,368,794.42. Samething applicable to other cost of goods like cost of soap,cost of oil and cost of rice. Additionally how come a division profit is 677,767.84 and total profit is showing 2,767,396.70. This is uncalled for and it really affecting, the issue started after unit cost update
The year is 2 days to end, these issues be solved on time to have a proper financial record for the year? @lubos please look into this urgent matter!
For me seems to be resolved and back to original.
So from my perspective, many thanks indeed @lubos and team for fixing this, especially before year end.
And (whilst it may be a breach of the board rules) may I also take this opportunity to wish all the team at Manager.io a happy healthy prosperous and peaceful New Year, and thank you for all the great work you do on this, lets face it, excellent value for money accounting platform!
What did you notice was resolved on your end? I couldn’t see any difference in the changes on my side with the issues I explained above!
In my case, I did nothing, but the “?” that was appearing in the ‘Unit Cost’ column was updated and replaced and re-populated with the weighted average cost per unit. So it works ok for me.
Im using the Cloud version - dont know if that makes a difference?
I appreciate your position may be more complicated than mine.