Query On Stock

I want to create  report as mentioned below where first column will be
calculated on basis of database procedure and other three column will,
be on basis of query.procedure will me also on basis of multiple
queries.
can any one help me how to write a procedure in mysql.and how to call in a query.



Opening Balance(As 23-12-2012)        Stock Transfer          Stock Return       Current Stock Balance    



Thanks & Regards,
Jyothi Bhargavi



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 post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/7f81919a-da1e-4d34-ada7-019a19bd4951%40googlegroups.com.

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

 

 

Jyothi,

"Stock Balance" report under stock module just delivers the same outcome. Do you want to customize the report?

This type of reports can be made via "Script Reports", you can write logic in python scripts including connecting database. So, if are an procedure experts, then make a "Script Reports" to call the mysql procedure. Otherwise, write the same logic in python scripts.

To get an idea of "Script Report", check https://github.com/webnotes/erpnext/tree/master/accounts/report/gross_profit

Regards,
Nabin Hait

On 24-Jun-2013, at 3:26 PM, Jyoti Bhargavi wrote:

I want to create  report as mentioned below where first column will be calculated on basis of database procedure and other three column will, be on basis of query.procedure will me also on basis of multiple queries.
can any one help me how to write a procedure in mysql.and how to call in a query.



Opening Balance(As 23-12-2012)        Stock Transfer          Stock Return       Current Stock Balance    



Thanks & Regards,
Jyothi Bhargavi



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 post to this group, send email to er…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/7f81919a-da1e-4d34-ada7-019a19bd4951%40googlegroups.com.

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

 

 




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 post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/45BA68F8-6A0E-4F38-BB7C-880A12AAD395%40gmail.com.

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