This column will be visible by default if you are selling inventory items, however if you don’t see it, you need to go to Edit Columns to activate Cost of sales column.
Clicking on the cost of sales figure will reveal individual inventory items sold on the invoice and their individual cost of sale amounts.
@lubos The recalculate button cant be found. Also i think FIFO is not working.
The old method is back?
Edit: Just checked for most of the Inventory Items Total costs are wrong.
Recalculate button will be on transaction level. Not on inventory item level.
Recalculate doesn’t work on inventory item level when we have production orders, divisions and negative inventory. The complexity explodes and then it gets challenging to explain how cost of goods sold is calculated in simple terms.
FIFO can be supported in the context of Recalculate button on transaction level. I’m working on this.
Can we get more granular? Total costs are now clickable and total cost is the sum of all transactions. Either purchases or cost of sales (which can be recalculated on individual transaction level).
They are back to normal but i had to delete all Unit Costs under settings, i dont know they are related or not but inventory value looks fine now. Also i think the Total Cost figures are based on Weighted Average.
I think that would create more mess. Those figures could be misleading as we would have to recalculate every day for each transaction and that looks too much work.
Also Unit Cost column under Inventory Tab is gone too.
In absence of inventory unit costs under Settings, for now Manager will fall back to previous on-demand cost calculations.
I know what you mean but we can have Recalculate button on screens which contain multiple transactions so you would be able to recalculate your cost of goods sold in bulk.
Currently, I want to make sure I have the right model for inventory costs that is easy to understand and troubleshoot. And at the same time have all the features that businesses require.
dear @lubos
good day, we use online version
all inventory items value increased and changed for all years,
please we need your assist.
i was think changes related to production orders and unite cost calculation
but when i see this post i search more and i found many invoice didn’t appear cost on the [Cost of sales] column that added in new update in Invoice tap
please help us ASAP
As couple of members asked, if the future changes can come with custom effective date where individual business can select the appropriatecut-off date themselves, it would be one of the opportunities to keep past data intact. Just my suggestion to keep away some of the difficulties users would face.
One thing i am confused about now these COGS transaction amounts are taken from the Qty (In transaction) x Unit Cost (defined under settings) which i previously thought you are doing it like this, but you stated that we don’t know the amounts under this new method and those cost are only used for valuation of BS.
Btw the absence of Recalculate button is making issues as i have deleted all Unit costs under settings (because my inventory figures were wrong) but now there is no way to bring those back at specific date. I think it was fine under Inventory Tab/BS/P&L.
I’m working on a worksheet that can recalculate all your unit costs for specific period.
Not at this time. But unit costs were not really hidden from users previously. Users could have viewed journal of the invoice which would reveal these unit costs anyway.
Does doing it like this solve performance issues? as there is still a relational factor in doing it like this and still not independent cogs transaction. Maybe creating a hidden line-item field (Like you did some time ago but it was not hidden) and automatically populating it with the amount equal to expense of goods when creating or updating the transaction.
And a report which will show COGS amount (Qty*Unit cost defined under settings) for items and incase its differently defined on transaction we can manually batch update those transaction. Like you have done for exchange rate
Yeah, it does solve performance issues. Having it as a field on line would provide only marginal performance boost that would be unnoticable.
Actually I don’t like how it’s done on exchange rates. I have improved some parts in Manager internally so transactions will be able to pull exchange rates from Settings directly just like it now works with inventory. And Batch Update feature in relation to exchange rates will be removed as it won’t be needed anymore.
I thought it was done because of requirement by tax authorities.
Anyway, its better like this as Exchange rate can vary from transaction to transaction on same day. It might happen with Inventory too as COGS can vary from transaction to transaction on a single day but there would be only single cost defined under settings. I don’t know how you are going to solve that maybe by References or by Timestamps?
