I’m new to ERPNext so I apologize in advance if this is easy to find and I’m just managing to miss it. I’ve found a few forum threads referencing which database table the valuation rate is stored in, but none referencing where to find it in the UI.
This docs page mentions the following:
One of the major features of any inventory system is that you can find out the value of any item based on its historic or average price. You can also find the value of all your items for your balance sheet.
There is a “Valuation Rate” field for each item on the item page; however, this seems to be a manually inputted value that is used in stock entry situations. The only actual historical cost data I’ve been able to find on a per-item basis are in these locations:
- Under Item -> Purchase Rate, the last purchase price is shown.
- Both the Stock Ledger and Stock Balance reports show a “Valuation Rate”
Is there any easy way of seeing the average cost and historical average cost easily (preferably from the item page)?