Erpnext queries

Hi

I am trying few things for customizing ERPNext. I have following queries:

1) How to create custom reports fetching data from two or more doctypes?

2) We want to fetch some values from a doctype when certain action happens in another doctype. This was done earlier using client/server triggers for a particular field while defining it in a doctype. I am not able to find that now. Please suggest how to get that functionality.

3) After creation of an Item in Stock module, the Item name field was automatically hidden. Is it a known bug or am I doing something wrong?

Please let me know answers to these queries.

Thanks, 



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/msg/erpnext-developer-forum/-/aXLiazhCS1MJ.

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

 

 

Gangadhar,


Hi
I am trying few things for customizing ERPNext. I have following queries:

1) How to create custom reports fetching data from two or more doctypes?

Make a query report. To start go to #query-report in the address bar. See examples like Accounts > Delivered Items to be Billed.

2) We want to fetch some values from a doctype when certain action happens in another doctype. This was done earlier using client/server triggers for a particular field while defining it in a doctype. I am not able to find that now. Please suggest how to get that functionality.

You can make scripts Setup > Custom Script - can you explain what are you exactly trying to do?

3) After creation of an Item in Stock module, the Item name field was automatically hidden. Is it a known bug or am I doing something wrong?

Item Code is a one time use field hence it gets hidden. Item Name is not hidden please check.

Please let me know answers to these queries.

Thanks, 



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/msg/erpnext-developer-forum/-/aXLiazhCS1MJ.

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.

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

 

 

Hello Sir,
I have to add trigger on item code in delivery note such that after selecting item code i have to fetch and set quantity from stock entry table. Earlier this was done using field level client/server trigger when defining a doctype. In new system, I don't see any such option to define trigger.

Please suggest how this could be done without modifying core.

Regards,

On 22 February 2013 15:02, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,


Hi
I am trying few things for customizing ERPNext. I have following queries:

1) How to create custom reports fetching data from two or more doctypes?

Make a query report. To start go to #query-report in the address bar. See examples like Accounts > Delivered Items to be Billed.

2) We want to fetch some values from a doctype when certain action happens in another doctype. This was done earlier using client/server triggers for a particular field while defining it in a doctype. I am not able to find that now. Please suggest how to get that functionality.

You can make scripts Setup > Custom Script - can you explain what are you exactly trying to do?

3) After creation of an Item in Stock module, the Item name field was automatically hidden. Is it a known bug or am I doing something wrong?

Item Code is a one time use field hence it gets hidden. Item Name is not hidden please check.

Please let me know answers to these queries.

Thanks,



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/msg/erpnext-developer-forum/-/aXLiazhCS1MJ.

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.

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







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.

SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

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

 

 

Gangadhar,

You will have to write a client script for this. I can add a "get_value" standard method so you can query and fetch the value. Will do it Monday  -- If I forget, remind me :)

best,
Rushabh



W: https://erpnext.com
T: @rushabh_mehta

On 22-Feb-2013, at 8:19 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
    I have to add trigger on item code in delivery note such that after selecting item code i have to fetch and set quantity from stock entry table. Earlier this was done using field level client/server trigger when defining a doctype. In new system, I don't see any such option to define trigger.

Please suggest how this could be done without modifying core.

Regards,

On 22 February 2013 15:02, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,


Hi
I am trying few things for customizing ERPNext. I have following queries:

1) How to create custom reports fetching data from two or more doctypes?

Make a query report. To start go to #query-report in the address bar. See examples like Accounts > Delivered Items to be Billed.

2) We want to fetch some values from a doctype when certain action happens in another doctype. This was done earlier using client/server triggers for a particular field while defining it in a doctype. I am not able to find that now. Please suggest how to get that functionality.

You can make scripts Setup > Custom Script - can you explain what are you exactly trying to do?

3) After creation of an Item in Stock module, the Item name field was automatically hidden. Is it a known bug or am I doing something wrong?

Item Code is a one time use field hence it gets hidden. Item Name is not hidden please check.

Please let me know answers to these queries.

Thanks, 



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/msg/erpnext-developer-forum/-/aXLiazhCS1MJ.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune

SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 

Hello Sir,

Please let me know have you added the get_value method?.

Thank you.

Regards,
Gangadhar kadam

On 23 February 2013 22:48, Rushabh Mehta <rm…@gmail.com> wrote:
Gangadhar,

You will have to write a client script for this. I can add a "get_value" standard method so you can query and fetch the value. Will do it Monday -- If I forget, remind me :)

best,
Rushabh



W: https://erpnext.com
T: @rushabh_mehta

On 22-Feb-2013, at 8:19 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
I have to add trigger on item code in delivery note such that after selecting item code i have to fetch and set quantity from stock entry table. Earlier this was done using field level client/server trigger when defining a doctype. In new system, I don't see any such option to define trigger.

Please suggest how this could be done without modifying core.

Regards,

On 22 February 2013 15:02, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,


Hi
I am trying few things for customizing ERPNext. I have following queries:

1) How to create custom reports fetching data from two or more doctypes?

Make a query report. To start go to #query-report in the address bar. See examples like Accounts > Delivered Items to be Billed.

2) We want to fetch some values from a doctype when certain action happens in another doctype. This was done earlier using client/server triggers for a particular field while defining it in a doctype. I am not able to find that now. Please suggest how to get that functionality.

You can make scripts Setup > Custom Script - can you explain what are you exactly trying to do?


3) After creation of an Item in Stock module, the Item name field was automatically hidden. Is it a known bug or am I doing something wrong?

Item Code is a one time use field hence it gets hidden. Item Name is not hidden please check.

Please let me know answers to these queries.

Thanks,



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/msg/erpnext-developer-forum/-/aXLiazhCS1MJ.

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.

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







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.

SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

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

 

 

Gangadhar,

Please check first example:

https://github.com/webnotes/wnframework/wiki/Client-side-scripting

best,
Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 25-Feb-2013, at 4:14 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
    Please let me know have you added the get_value method?.   

Thank you.

Regards,
Gangadhar kadam

On 23 February 2013 22:48, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,

You will have to write a client script for this. I can add a "get_value" standard method so you can query and fetch the value. Will do it Monday  -- If I forget, remind me :)

best,
Rushabh



W: https://erpnext.com
T: @rushabh_mehta

On 22-Feb-2013, at 8:19 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
    I have to add trigger on item code in delivery note such that after selecting item code i have to fetch and set quantity from stock entry table. Earlier this was done using field level client/server trigger when defining a doctype. In new system, I don't see any such option to define trigger.

Please suggest how this could be done without modifying core.

Regards,

On 22 February 2013 15:02, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,


Hi
I am trying few things for customizing ERPNext. I have following queries:

1) How to create custom reports fetching data from two or more doctypes?

Make a query report. To start go to #query-report in the address bar. See examples like Accounts > Delivered Items to be Billed.

2) We want to fetch some values from a doctype when certain action happens in another doctype. This was done earlier using client/server triggers for a particular field while defining it in a doctype. I am not able to find that now. Please suggest how to get that functionality.

You can make scripts Setup > Custom Script - can you explain what are you exactly trying to do?


3) After creation of an Item in Stock module, the Item name field was automatically hidden. Is it a known bug or am I doing something wrong?

Item Code is a one time use field hence it gets hidden. Item Name is not hidden please check.

Please let me know answers to these queries.

Thanks, 



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/msg/erpnext-developer-forum/-/aXLiazhCS1MJ.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune

SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 

Thank you sir,

I have one more query, from child table can we pass multiple filters as follows ?

cur_frm.cscript.wash_type = function(doc,cdt,cdn) {
var d = locals[cdt][cdn];
if (d.wash_type) {
get_server_fields('get_itemqty',d.wash_type,d.item_code,'delivery_note_details',doc,cdt,cdn,1);
}
}

for single filter it works but if i pass multiple parameters id shows undefined parameter error.

Regards,
Gangadhar kadam

On 26 February 2013 11:52, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,

Please check first example:


best,
Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 25-Feb-2013, at 4:14 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
Please let me know have you added the get_value method?.

Thank you.

Regards,
Gangadhar kadam

On 23 February 2013 22:48, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,

You will have to write a client script for this. I can add a "get_value" standard method so you can query and fetch the value. Will do it Monday -- If I forget, remind me :)

best,
Rushabh



On 22-Feb-2013, at 8:19 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
I have to add trigger on item code in delivery note such that after selecting item code i have to fetch and set quantity from stock entry table. Earlier this was done using field level client/server trigger when defining a doctype. In new system, I don't see any such option to define trigger.

Please suggest how this could be done without modifying core.

Regards,

On 22 February 2013 15:02, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,


Hi
I am trying few things for customizing ERPNext. I have following queries:

1) How to create custom reports fetching data from two or more doctypes?

Make a query report. To start go to #query-report in the address bar. See examples like Accounts > Delivered Items to be Billed.

2) We want to fetch some values from a doctype when certain action happens in another doctype. This was done earlier using client/server triggers for a particular field while defining it in a doctype. I am not able to find that now. Please suggest how to get that functionality.

You can make scripts Setup > Custom Script - can you explain what are you exactly trying to do?


3) After creation of an Item in Stock module, the Item name field was automatically hidden. Is it a known bug or am I doing something wrong?

Item Code is a one time use field hence it gets hidden. Item Name is not hidden please check.

Please let me know answers to these queries.

Thanks,



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/msg/erpnext-developer-forum/-/aXLiazhCS1MJ.

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.

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







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.

SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

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

 

 

Dear Gangadhar,

Have a look at the scripts page: 
https://github.com/webnotes/wnframework/wiki/Client-side-scripting

go to the heading: Fetching a table row's values in the form

Thanks,
Anand Doshi.

On 01-Mar-2013, at 11:09 AM, गंगाधर कदम <em...@gmail.com> wrote:

Thank you sir,
    I have one more query, from child table can we pass multiple filters as follows ?

cur_frm.cscript.wash_type = function(doc,cdt,cdn) {
    var d = locals[cdt][cdn];
    if (d.wash_type) {
    get_server_fields('get_itemqty',d.wash_type,d.item_code,'delivery_note_details',doc,cdt,cdn,1); 
  }
}

for single filter it works but if i pass multiple parameters id shows undefined parameter error.

Regards,
Gangadhar kadam

On 26 February 2013 11:52, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,

Please check first example:


best,
Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 25-Feb-2013, at 4:14 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
    Please let me know have you added the get_value method?.   

Thank you.

Regards,
Gangadhar kadam

On 23 February 2013 22:48, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,

You will have to write a client script for this. I can add a "get_value" standard method so you can query and fetch the value. Will do it Monday  -- If I forget, remind me :)

best,
Rushabh



On 22-Feb-2013, at 8:19 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
    I have to add trigger on item code in delivery note such that after selecting item code i have to fetch and set quantity from stock entry table. Earlier this was done using field level client/server trigger when defining a doctype. In new system, I don't see any such option to define trigger.

Please suggest how this could be done without modifying core.

Regards,

On 22 February 2013 15:02, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,


Hi
I am trying few things for customizing ERPNext. I have following queries:

1) How to create custom reports fetching data from two or more doctypes?

Make a query report. To start go to #query-report in the address bar. See examples like Accounts > Delivered Items to be Billed.

2) We want to fetch some values from a doctype when certain action happens in another doctype. This was done earlier using client/server triggers for a particular field while defining it in a doctype. I am not able to find that now. Please suggest how to get that functionality.

You can make scripts Setup > Custom Script - can you explain what are you exactly trying to do?


3) After creation of an Item in Stock module, the Item name field was automatically hidden. Is it a known bug or am I doing something wrong?

Item Code is a one time use field hence it gets hidden. Item Name is not hidden please check.

Please let me know answers to these queries.

Thanks, 



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/msg/erpnext-developer-forum/-/aXLiazhCS1MJ.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune

SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 

Hi Gangadhar,

If you want to simply fetch values from a particular table's row, you can use the get value call as described in:
https://github.com/webnotes/wnframework/wiki/Client-side-scripting
section: Get Values From Server

In the callback, you can update the returned values in r.message to the table's row like:
callback: function( r ) {
if(!r.exc) {
$.extend(d, r.message);  // where d is -- var d = locals[cdt][cdn];
}
}

If you want to use this, please do it tomorrow, as this update will be released by end of day.

Thanks,
Anand. 

On 01-Mar-2013, at 12:09 PM, Anand Doshi <an...@iwebnotes.com> wrote:

Dear Gangadhar,

Have a look at the scripts page: 

go to the heading: Fetching a table row's values in the form

Thanks,
Anand Doshi.

On 01-Mar-2013, at 11:09 AM, गंगाधर कदम <em...@gmail.com> wrote:

Thank you sir,
    I have one more query, from child table can we pass multiple filters as follows ?

cur_frm.cscript.wash_type = function(doc,cdt,cdn) {
    var d = locals[cdt][cdn];
    if (d.wash_type) {
    get_server_fields('get_itemqty',d.wash_type,d.item_code,'delivery_note_details',doc,cdt,cdn,1); 
  }
}

for single filter it works but if i pass multiple parameters id shows undefined parameter error.

Regards,
Gangadhar kadam

On 26 February 2013 11:52, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,

Please check first example:


best,
Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 25-Feb-2013, at 4:14 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
    Please let me know have you added the get_value method?.   

Thank you.

Regards,
Gangadhar kadam

On 23 February 2013 22:48, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,

You will have to write a client script for this. I can add a "get_value" standard method so you can query and fetch the value. Will do it Monday  -- If I forget, remind me :)

best,
Rushabh



On 22-Feb-2013, at 8:19 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
    I have to add trigger on item code in delivery note such that after selecting item code i have to fetch and set quantity from stock entry table. Earlier this was done using field level client/server trigger when defining a doctype. In new system, I don't see any such option to define trigger.

Please suggest how this could be done without modifying core.

Regards,

On 22 February 2013 15:02, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,


Hi
I am trying few things for customizing ERPNext. I have following queries:

1) How to create custom reports fetching data from two or more doctypes?

Make a query report. To start go to #query-report in the address bar. See examples like Accounts > Delivered Items to be Billed.

2) We want to fetch some values from a doctype when certain action happens in another doctype. This was done earlier using client/server triggers for a particular field while defining it in a doctype. I am not able to find that now. Please suggest how to get that functionality.

You can make scripts Setup > Custom Script - can you explain what are you exactly trying to do?


3) After creation of an Item in Stock module, the Item name field was automatically hidden. Is it a known bug or am I doing something wrong?

Item Code is a one time use field hence it gets hidden. Item Name is not hidden please check.

Please let me know answers to these queries.

Thanks, 



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/msg/erpnext-developer-forum/-/aXLiazhCS1MJ.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune

SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 

Yes sir,

But as i understand the script are for only one doctype , I have to get value from sending filters for multiple doctype and multiple filters.

Thank you

Regards,
Gangadhar kadam

On 1 March 2013 12:30, Anand Doshi <an...@iwebnotes.com> wrote:
Hi Gangadhar,

If you want to simply fetch values from a particular table's row, you can use the get value call as described in:
section: Get Values From Server

In the callback, you can update the returned values in r.message to the table's row like:
callback: function( r ) {
if(!r.exc) {
$.extend(d, r.message); // where d is -- var d = locals[cdt][cdn];
}
}

If you want to use this, please do it tomorrow, as this update will be released by end of day.

Thanks,
Anand.

On 01-Mar-2013, at 12:09 PM, Anand Doshi <an...@iwebnotes.com> wrote:

Dear Gangadhar,

Have a look at the scripts page:

go to the heading: Fetching a table row's values in the form

Thanks,
Anand Doshi.

On 01-Mar-2013, at 11:09 AM, गंगाधर कदम <em...@gmail.com> wrote:

Thank you sir,
I have one more query, from child table can we pass multiple filters as follows ?

cur_frm.cscript.wash_type = function(doc,cdt,cdn) {
var d = locals[cdt][cdn];
if (d.wash_type) {
get_server_fields('get_itemqty',d.wash_type,d.item_code,'delivery_note_details',doc,cdt,cdn,1);
}
}

for single filter it works but if i pass multiple parameters id shows undefined parameter error.

Regards,
Gangadhar kadam

On 26 February 2013 11:52, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,

Please check first example:


best,
On 25-Feb-2013, at 4:14 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
Please let me know have you added the get_value method?.

Thank you.

Regards,
Gangadhar kadam

On 23 February 2013 22:48, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,

You will have to write a client script for this. I can add a "get_value" standard method so you can query and fetch the value. Will do it Monday -- If I forget, remind me :)

best,
Rushabh



On 22-Feb-2013, at 8:19 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
I have to add trigger on item code in delivery note such that after selecting item code i have to fetch and set quantity from stock entry table. Earlier this was done using field level client/server trigger when defining a doctype. In new system, I don't see any such option to define trigger.

Please suggest how this could be done without modifying core.

Regards,

On 22 February 2013 15:02, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,


Hi
I am trying few things for customizing ERPNext. I have following queries:

1) How to create custom reports fetching data from two or more doctypes?

Make a query report. To start go to #query-report in the address bar. See examples like Accounts > Delivered Items to be Billed.

2) We want to fetch some values from a doctype when certain action happens in another doctype. This was done earlier using client/server triggers for a particular field while defining it in a doctype. I am not able to find that now. Please suggest how to get that functionality.

You can make scripts Setup > Custom Script - can you explain what are you exactly trying to do?


3) After creation of an Item in Stock module, the Item name field was automatically hidden. Is it a known bug or am I doing something wrong?

Item Code is a one time use field hence it gets hidden. Item Name is not hidden please check.

Please let me know answers to these queries.

Thanks,



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/msg/erpnext-developer-forum/-/aXLiazhCS1MJ.

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.

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







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.

SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

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

 

 

Hi Gangadhar,

You should then use my previous recommendation: Fetching a table row's values in the form

In the server-side function, you can query multiple tables and send the resulting fields and values as a dictionary.

-Anand.


On 01-Mar-2013, at 12:37 PM, गंगाधर कदम <em...@gmail.com> wrote:

Yes sir,
   But as i understand the script are for only one doctype , I have to get value from sending filters for multiple doctype and multiple filters.

Thank you

Regards,
Gangadhar kadam

On 1 March 2013 12:30, Anand Doshi <an...@iwebnotes.com> wrote:
Hi Gangadhar,

If you want to simply fetch values from a particular table's row, you can use the get value call as described in:
section: Get Values From Server

In the callback, you can update the returned values in r.message to the table's row like:
callback: function( r ) {
if(!r.exc) {
$.extend(d, r.message);  // where d is -- var d = locals[cdt][cdn];
}
}

If you want to use this, please do it tomorrow, as this update will be released by end of day.

Thanks,
Anand. 

On 01-Mar-2013, at 12:09 PM, Anand Doshi <an...@iwebnotes.com> wrote:

Dear Gangadhar,

Have a look at the scripts page: 

go to the heading: Fetching a table row's values in the form

Thanks,
Anand Doshi.

On 01-Mar-2013, at 11:09 AM, गंगाधर कदम <em...@gmail.com> wrote:

Thank you sir,
    I have one more query, from child table can we pass multiple filters as follows ?

cur_frm.cscript.wash_type = function(doc,cdt,cdn) {
    var d = locals[cdt][cdn];
    if (d.wash_type) {
    get_server_fields('get_itemqty',d.wash_type,d.item_code,'delivery_note_details',doc,cdt,cdn,1); 
  }
}

for single filter it works but if i pass multiple parameters id shows undefined parameter error.

Regards,
Gangadhar kadam

On 26 February 2013 11:52, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,

Please check first example:


best,
On 25-Feb-2013, at 4:14 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
    Please let me know have you added the get_value method?.   

Thank you.

Regards,
Gangadhar kadam

On 23 February 2013 22:48, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,

You will have to write a client script for this. I can add a "get_value" standard method so you can query and fetch the value. Will do it Monday  -- If I forget, remind me :)

best,
Rushabh



On 22-Feb-2013, at 8:19 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
    I have to add trigger on item code in delivery note such that after selecting item code i have to fetch and set quantity from stock entry table. Earlier this was done using field level client/server trigger when defining a doctype. In new system, I don't see any such option to define trigger.

Please suggest how this could be done without modifying core.

Regards,

On 22 February 2013 15:02, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,


Hi
I am trying few things for customizing ERPNext. I have following queries:

1) How to create custom reports fetching data from two or more doctypes?

Make a query report. To start go to #query-report in the address bar. See examples like Accounts > Delivered Items to be Billed.

2) We want to fetch some values from a doctype when certain action happens in another doctype. This was done earlier using client/server triggers for a particular field while defining it in a doctype. I am not able to find that now. Please suggest how to get that functionality.

You can make scripts Setup > Custom Script - can you explain what are you exactly trying to do?


3) After creation of an Item in Stock module, the Item name field was automatically hidden. Is it a known bug or am I doing something wrong?

Item Code is a one time use field hence it gets hidden. Item Name is not hidden please check.

Please let me know answers to these queries.

Thanks, 



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/msg/erpnext-developer-forum/-/aXLiazhCS1MJ.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune

SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 

Hello Sir,

i have written custom on_update function in stock_entry.py for auto creation of sales order on my local setup. How can i use this as custom functionality for project uploaded on erpnext account.


Regards,
Gangadhar kadam

On 1 March 2013 12:55, Anand Doshi <an…@iwebnotes.com> wrote:
Hi Gangadhar,

You should then use my previous recommendation: Fetching a table row's values in the form

In the server-side function, you can query multiple tables and send the resulting fields and values as a dictionary.

-Anand.


On 01-Mar-2013, at 12:37 PM, गंगाधर कदम <em...@gmail.com> wrote:

Yes sir,
But as i understand the script are for only one doctype , I have to get value from sending filters for multiple doctype and multiple filters.

Thank you

Regards,
Gangadhar kadam

On 1 March 2013 12:30, Anand Doshi <an...@iwebnotes.com> wrote:
Hi Gangadhar,

If you want to simply fetch values from a particular table's row, you can use the get value call as described in:
section: Get Values From Server

In the callback, you can update the returned values in r.message to the table's row like:
callback: function( r ) {
if(!r.exc) {
$.extend(d, r.message); // where d is -- var d = locals[cdt][cdn];
}
}

If you want to use this, please do it tomorrow, as this update will be released by end of day.

Thanks,
Anand.

On 01-Mar-2013, at 12:09 PM, Anand Doshi <an...@iwebnotes.com> wrote:

Dear Gangadhar,


Have a look at the scripts page:

go to the heading: Fetching a table row's values in the form

Thanks,
Anand Doshi.

On 01-Mar-2013, at 11:09 AM, गंगाधर कदम <em...@gmail.com> wrote:


Thank you sir,
I have one more query, from child table can we pass multiple filters as follows ?

cur_frm.cscript.wash_type = function(doc,cdt,cdn) {
var d = locals[cdt][cdn];
if (d.wash_type) {
get_server_fields('get_itemqty',d.wash_type,d.item_code,'delivery_note_details',doc,cdt,cdn,1);
}
}

for single filter it works but if i pass multiple parameters id shows undefined parameter error.

Regards,
Gangadhar kadam

On 26 February 2013 11:52, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,

Please check first example:


best,
On 25-Feb-2013, at 4:14 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
Please let me know have you added the get_value method?.

Thank you.

Regards,
Gangadhar kadam

On 23 February 2013 22:48, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,

You will have to write a client script for this. I can add a "get_value" standard method so you can query and fetch the value. Will do it Monday -- If I forget, remind me :)

best,
Rushabh



On 22-Feb-2013, at 8:19 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
I have to add trigger on item code in delivery note such that after selecting item code i have to fetch and set quantity from stock entry table. Earlier this was done using field level client/server trigger when defining a doctype. In new system, I don't see any such option to define trigger.

Please suggest how this could be done without modifying core.

Regards,

On 22 February 2013 15:02, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,


Hi
I am trying few things for customizing ERPNext. I have following queries:

1) How to create custom reports fetching data from two or more doctypes?

Make a query report. To start go to #query-report in the address bar. See examples like Accounts > Delivered Items to be Billed.

2) We want to fetch some values from a doctype when certain action happens in another doctype. This was done earlier using client/server triggers for a particular field while defining it in a doctype. I am not able to find that now. Please suggest how to get that functionality.

You can make scripts Setup > Custom Script - can you explain what are you exactly trying to do?


3) After creation of an Item in Stock module, the Item name field was automatically hidden. Is it a known bug or am I doing something wrong?

Item Code is a one time use field hence it gets hidden. Item Name is not hidden please check.

Please let me know answers to these queries.

Thanks,



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/msg/erpnext-developer-forum/-/aXLiazhCS1MJ.

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.

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







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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







--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune


P SAVE TREES - Please consider the environment before printing this email.

SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?



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.

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

 

 

Quick Answer: You can't - convince your customer to host on their own.

best,
Rushabh


W: https://erpnext.com
T: @rushabh_mehta

On 01-Mar-2013, at 3:34 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
   i have written custom on_update function in stock_entry.py for auto creation of sales order on my local setup. How can i use this as custom functionality for project uploaded on erpnext account.

Regards,
Gangadhar kadam

On 1 March 2013 12:55, Anand Doshi <an...@iwebnotes.com> wrote:
Hi Gangadhar,

You should then use my previous recommendation: Fetching a table row's values in the form

In the server-side function, you can query multiple tables and send the resulting fields and values as a dictionary.

-Anand.


On 01-Mar-2013, at 12:37 PM, गंगाधर कदम <em...@gmail.com> wrote:

Yes sir,
   But as i understand the script are for only one doctype , I have to get value from sending filters for multiple doctype and multiple filters.

Thank you

Regards,
Gangadhar kadam

On 1 March 2013 12:30, Anand Doshi <an...@iwebnotes.com> wrote:
Hi Gangadhar,

If you want to simply fetch values from a particular table's row, you can use the get value call as described in:
section: Get Values From Server

In the callback, you can update the returned values in r.message to the table's row like:
callback: function( r ) {
if(!r.exc) {
$.extend(d, r.message);  // where d is -- var d = locals[cdt][cdn];
}
}

If you want to use this, please do it tomorrow, as this update will be released by end of day.

Thanks,
Anand. 

On 01-Mar-2013, at 12:09 PM, Anand Doshi <an...@iwebnotes.com> wrote:

Dear Gangadhar,


Have a look at the scripts page: 

go to the heading: Fetching a table row's values in the form

Thanks,
Anand Doshi.

On 01-Mar-2013, at 11:09 AM, गंगाधर कदम <em...@gmail.com> wrote:


Thank you sir,
    I have one more query, from child table can we pass multiple filters as follows ?

cur_frm.cscript.wash_type = function(doc,cdt,cdn) {
    var d = locals[cdt][cdn];
    if (d.wash_type) {
    get_server_fields('get_itemqty',d.wash_type,d.item_code,'delivery_note_details',doc,cdt,cdn,1); 
  }
}

for single filter it works but if i pass multiple parameters id shows undefined parameter error.

Regards,
Gangadhar kadam

On 26 February 2013 11:52, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,

Please check first example:


best,
On 25-Feb-2013, at 4:14 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
    Please let me know have you added the get_value method?.   

Thank you.

Regards,
Gangadhar kadam

On 23 February 2013 22:48, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,

You will have to write a client script for this. I can add a "get_value" standard method so you can query and fetch the value. Will do it Monday  -- If I forget, remind me :)

best,
Rushabh



On 22-Feb-2013, at 8:19 PM, गंगाधर कदम <em...@gmail.com> wrote:

Hello Sir,
    I have to add trigger on item code in delivery note such that after selecting item code i have to fetch and set quantity from stock entry table. Earlier this was done using field level client/server trigger when defining a doctype. In new system, I don't see any such option to define trigger.

Please suggest how this could be done without modifying core.

Regards,

On 22 February 2013 15:02, Rushabh Mehta <rm...@gmail.com> wrote:
Gangadhar,


Hi
I am trying few things for customizing ERPNext. I have following queries:

1) How to create custom reports fetching data from two or more doctypes?

Make a query report. To start go to #query-report in the address bar. See examples like Accounts > Delivered Items to be Billed.

2) We want to fetch some values from a doctype when certain action happens in another doctype. This was done earlier using client/server triggers for a particular field while defining it in a doctype. I am not able to find that now. Please suggest how to get that functionality.

You can make scripts Setup > Custom Script - can you explain what are you exactly trying to do?


3) After creation of an Item in Stock module, the Item name field was automatically hidden. Is it a known bug or am I doing something wrong?

Item Code is a one time use field hence it gets hidden. Item Name is not hidden please check.

Please let me know answers to these queries.

Thanks, 



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/msg/erpnext-developer-forum/-/aXLiazhCS1MJ.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,

New Indictrans Technologies Pvt. Ltd., Pune


SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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

 

 




--
Thanks & Regards,
Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune

SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping  prevent global warming by reducing consumption of power... ARE YOU?



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.

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.

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