How to create a procedure in my sql

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 In advance

Mahr



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

To post to this group, send email to er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/JxjZWGl1T8EJ.

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

 

 

Hi Mahr,

We have already created the same report named "Stock Balance" under Stock module. The report gives you Opening, Inflow, Outflow and Closing balance if any item on a specific date.

You can check the report in our Demo account.

Currently, inclusion of procedure is not possible in the report. 


Regards,
Nabin Hait

On 27-Dec-2012, at 10:41 AM, Stk Intl Trading IT Manager Mahr Haider 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 In advance

Mahr



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

To post to this group, send email to er…@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/JxjZWGl1T8EJ.

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

To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.

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