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_profitRegards,
Nabin Hait
–
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.