Valuation ratelocation in database

bobzz_zone · January 23, 2015, 4:34pm

Hi,

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

Thanks

nabinhait · January 23, 2015, 7:33pm

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.

bobzz_zone · January 24, 2015, 5:23am

Thanks, anyway when is the tabBin table updated ?

rmehta · January 26, 2015, 3:06pm

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