How to create a procedure in my sql

[Stk Intl Trading IT Manager Mahr Haider]

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

[Nabin Hait]

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

--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer...@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.