Home Button  Buy Button 

Topic:   Inventory Valuation - Average Cost

By: GuestPosted on: Nov 11 2020 at 12:35:13 PM
Hello,

Has there been any progress implementing an average cost stock valuation?

Thanks

By: SupportPosted on: Nov 12 2020 at 09:12:43 AM
Sorry No. The stock valuation uses the default supplier's standard price.

All previous versions of MiniMRP expected you to manually key in the default cost or import costs from CSV.

But v5 has the option where, if enabled, the most recent purchase price is taken as the default.

But to answer your original question - it's unlikely that we'll ever do the calculation back through historic purchase orders to arrive at an Average. We think it's just too much for a 'Mini' mrp.

By: GuestPosted on: Nov 12 2020 at 09:55:27 AM
Ok - It's a shame, i was only asking based on your comments in July:--

There are some updates being done that change the way cost price of items is calculated (ie Average Cost vs most recent). This is mainly for calculating the build cost of assemblies. But taking that a step further it should then be possible to take that average cost into the stock valuation reports.

I'll put this into the ToDo pile so it gets looked at sooner rather tgan later. But, as usual, I'm not going to give any timescale.

Thanks anyway.

By: GuestPosted on: Nov 13 2020 at 01:54:23 AM
Would the average not just be calculated from each NEW order placed (or recieved)?

The problem is with taking the most recent price, and updating the standard price, is that you have just revalued your entire stock - maybe with a rogue price. If we buy a 1000 of soemthing for a £1, then buy 10 for £5, we will increase the value of any items left from the 1000.

So we leave this option turned off - But it would be turned on if the standard cost was not being used for the valuation.

I personally think this is a fundamental requirement. Inventory should be valued at the purchase cost, (or as close to it as possible).

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- Inventory Valuation - Average Cost


Enter the numbers.

Your name here is optional