Query On Stock

[Jyoti Bhargavi]

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

[Nabin Hait]

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

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