How to get Stock Valuation Rate and Stock Value from SLE Table for a particular date?

Hi,

I am trying to make a custom script report where I could get the stock valuation rate on a particular date along with the stock value. I know that these values are stored in in the stock ledger entry table but pardon my coding skills I am unable to get the stock value and stock valuation for the particular date. I have already copied a lot of code from existing reports but I guess I am unable to find a way to get the following:

  1. Valuation Rate for Item code in a particular warehouse on a particular date
  2. Corresponding to the above rate the total value of the stock.
  3. Lowest Selling Price of an item (this price is the lowest price of the item from posting date - 100 days)
I have enclosed the code I am using here.

Now why I am making this report. This report is being made to check the postings of the valuation rates in the Stock ledger entry table since I have seen that there are some known small issues with valuation of items and I would like to check the same with the help of this report.

I would be highly obliged if someone could please let me know how to get my data in the line 38-39 and 41 of the code mentioned above.



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/734fbdb2-14d7-46b7-82d2-376c8368b63f%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.