Valuation ratelocation in database


I wonder where erpnext keep valuation rate data ?
and how i can get the valuation rate of an item?


You can find valuation_rate for any date from tabStock Ledger Entry table .

To get latest valuation_rate you can also look into tabBin table.

Thanks, anyway when is the tabBin table updated ?

When any stock ledger entry is made, i.e. on Submission of a stock transaction.

1 Like