How to add additional functionality based on custom fields on other forms?

[aditya2]

Hi,

I have added certain custom fields to the Customers like:

1. TIN Number (Data field)

2. Discount (Float) (Basically we are tracking discounts by customer
   so this would help in knowing what is the discount being offered to
   the customer and then we could add the discount manually in the item
   selection)

3. Credit Days (Int) (This would be shown in Invoices and would be
   added to the bill date to compute the payment due date for that
   particular invoice.

4. Credit Limit (Currency) (This field would actually freeze making of
   additional invoices if the Credit Limit is exceeded.

I would like to show this field on Quotation, Sales Order etc when a
particular customer is selected.

Is it possible to include some of these fields to the print formats as
well.

[nabin]

Hi,


Please see my comments below in red.

You do not require any of the fields. Those facilities are already there in the system.

On Thu, Oct 14, 2010 at 4:58 PM, Aditya Duggal <ad…@rigpl.com> wrote:

Hi,

I have added certain custom fields to the Customers like:

1. TIN Number (Data field) - TIN Number field is not required. You can put TIN No in the "Customer Details" field. We will fetch "Customer Details" field in all sales document.

2. Discount (Float) (Basically we are tracking discounts by customer
so this would help in knowing what is the discount being offered to
the customer and then we could add the discount manually in the item
selection) - It can be customized for you.

3. Credit Days (Int) (This would be shown in Invoices and would be
added to the bill date to compute the payment due date for that
particular invoice. - The facility is already there. You can enter Credit Days in Customer master (Customerwise) or Company master (Global). Due date will be automatically calculated based on credit days.

4. Credit Limit (Currency) (This field would actually freeze making of
additional invoices if the Credit Limit is exceeded. - You can enter Credit Limit in Customer master (Customerwise) or Company master (Global). It will block if outstanding amount exceeds credit limit in Sales Invoice.

I would like to show this field on Quotation, Sales Order etc when a
particular customer is selected.

Is it possible to include some of these fields to the print formats as
well. - You can show any fields in the print format.

Regards,
Nabin Hait
Web Notes Technologies

[nabin]

Hi,

Credit Days and Credit Limit fields are in account master of customer.

Regards,
Nabin Hait
Web Notes Technologies

On Thu, Oct 14, 2010 at 5:27 PM, Nabin Hait <na…@iwebnotes.com> wrote:

Hi,


Please see my comments below in red.

You do not require any of the fields. Those facilities are already there in the system.

On Thu, Oct 14, 2010 at 4:58 PM, Aditya Duggal <ad...@rigpl.com> wrote:

Hi,

I have added certain custom fields to the Customers like:

1. TIN Number (Data field) - TIN Number field is not required. You can put TIN No in the "Customer Details" field. We will fetch "Customer Details" field in all sales document.

2. Discount (Float) (Basically we are tracking discounts by customer
so this would help in knowing what is the discount being offered to
the customer and then we could add the discount manually in the item

selection) - It can be customized for you.

3. Credit Days (Int) (This would be shown in Invoices and would be
added to the bill date to compute the payment due date for that

particular invoice. - The facility is already there. You can enter Credit Days in Customer master (Customerwise) or Company master (Global). Due date will be automatically calculated based on credit days.

4. Credit Limit (Currency) (This field would actually freeze making of

additional invoices if the Credit Limit is exceeded. - You can enter Credit Limit in Customer master (Customerwise) or Company master (Global). It will block if outstanding amount exceeds credit limit in Sales Invoice.

I would like to show this field on Quotation, Sales Order etc when a
particular customer is selected.

Is it possible to include some of these fields to the print formats as

well. - You can show any fields in the print format.

Regards,
Nabin Hait
Web Notes Technologies

[aditya2]

Thanks a lot for the quick replies, but there are some things which
still remain unanswered like:

1. If I create a custom field in the customers then is there a way to
   show that field in the quotes etc that query is still unanswered as to
   how we could fetch it in those fields by changing the doc type.

It would be greatly appreciated if you could let us know how to do
that

On Oct 14, 5:14 pm, Nabin Hait na...@iwebnotes.com wrote:

Hi,

Credit Days and Credit Limit fields are in account master of customer.

Regards,
Nabin Hait
Web Notes Technologies

On Thu, Oct 14, 2010 at 5:27 PM, Nabin Hait na...@iwebnotes.com wrote:

Hi,

Please see my comments below in red.

You do not require any of the fields. Those facilities are already there in
the system.

On Thu, Oct 14, 2010 at 4:58 PM, Aditya Duggal ad...@rigpl.com wrote:

Hi,

I have added certain custom fields to the Customers like:

1. TIN Number (Data field) - TIN Number field is not required. You can
   put TIN No in the “Customer Details” field. We will fetch “Customer Details”
   field in all sales document.

2. Discount (Float) (Basically we are tracking discounts by customer
   so this would help in knowing what is the discount being offered to
   the customer and then we could add the discount manually in the item
   selection) - It can be customized for you.

3. Credit Days (Int) (This would be shown in Invoices and would be
   added to the bill date to compute the payment due date for that
   particular invoice. - The facility is already there. You can enter Credit
   Days in Customer master (Customerwise) or Company master (Global). Due date
   will be automatically calculated based on credit days.

4. Credit Limit (Currency) (This field would actually freeze making of
   additional invoices if the Credit Limit is exceeded. - You can enter
   Credit Limit in Customer master (Customerwise) or Company master (Global).
   It will block if outstanding amount exceeds credit limit in Sales Invoice.

I would like to show this field on Quotation, Sales Order etc when a
particular customer is selected.

Is it possible to include some of these fields to the print formats as
well. - You can show any fields in the print format.

Regards,
Nabin Hait
Web Notes Technologies

[rmehta]

Aditya,

At the moment, the way you can add them is as follows.

1. Open the DocType of Quotation,

2. In the Client Script add the following line if your customer field is called "customer", the field in the customer master is "tin_number" and the field in quotation is also "tin_number"

cur_frm.add_fetch('customer', 'tin_number', 'tin_number')

the format is:

cur_frm.add_fetch(fieldname, source_fieldname in the master, target_fieldname)

If you want to do things more complicated, you can open a service request by mailing to su...@iwebnotes.com and we can customize it for you. We will charge Rs 500 / $10 per half hour of customization!

- Rushabh

On Oct 14, 2010, at 7:08 PM, Aditya Duggal wrote:

Thanks a lot for the quick replies, but there are some things which

still remain unanswered like:

1. If I create a custom field in the customers then is there a way to

show that field in the quotes etc that query is still unanswered as to

how we could fetch it in those fields by changing the doc type.

It would be greatly appreciated if you could let us know how to do

that

On Oct 14, 5:14 pm, Nabin Hait <na...@iwebnotes.com> wrote:

Hi,

Credit Days and Credit Limit fields are in account master of customer.

Regards,

Nabin Hait

Web Notes Technologies

On Thu, Oct 14, 2010 at 5:27 PM, Nabin Hait <na...@iwebnotes.com> wrote:

Hi,

Please see my comments below in red.

You do not require any of the fields. Those facilities are already there in

the system.

On Thu, Oct 14, 2010 at 4:58 PM, Aditya Duggal <ad...@rigpl.com> wrote:

Hi,

I have added certain custom fields to the Customers like:

1. TIN Number (Data field) - TIN Number field is not required. You can

put TIN No in the "Customer Details" field. We will fetch "Customer Details"

field in all sales document.

2. Discount (Float) (Basically we are tracking discounts by customer

so this would help in knowing what is the discount being offered to

the customer and then we could add the discount manually in the item

selection) - It can be customized for you.

3. Credit Days (Int) (This would be shown in Invoices and would be

added to the bill date to compute the payment due date for that

particular invoice. - The facility is already there. You can enter Credit

Days in Customer master (Customerwise) or Company master (Global). Due date

will be automatically calculated based on credit days.

4. Credit Limit (Currency) (This field would actually freeze making of

additional invoices if the Credit Limit is exceeded. - You can enter

Credit Limit in Customer master (Customerwise) or Company master (Global).

It will block if outstanding amount exceeds credit limit in Sales Invoice.

I would like to show this field on Quotation, Sales Order etc when a

particular customer is selected.

Is it possible to include some of these fields to the print formats as

well. - You can show any fields in the print format.

Regards,

Nabin Hait

Web Notes Technologies

---------------------------------------------------------------------------------

erpnext

World's most affordable ERP - Rs 299/user/month

https://www.erpnext.com

[aditya2]

This is the error I get when I pasted the following code in the Client
Side Javascript:

cur_frm.add_fetch(‘customer’, ‘hss_discount’, ‘hss_discount’);
cur_frm.add_fetch(‘customer’, ‘carbide_discount’, ‘carbide_discount’);

Error I get if the fields are filled, if the fields are empty then
there is no error and code goes well,

Handler Exception:{‘message’: ‘Ok’, ‘exec’:", ‘fetch_values’:
[Decimal(“35.000000”),Decimal(“40.000000”)]}

What my analysis of the error message shows that it is fetching the
values ok from the customer but there seems to be some problem with
the pasting of the data.

Please note that both the fields HSS Discount and Carbide Discount
have same names in both the forms as hss_discount and carbide_discount
respectively.

On Oct 14, 7:18 pm, Rushabh Mehta rm...@gmail.com wrote:

Aditya,

At the moment, the way you can add them is as follows.

1. Open the DocType of Quotation,
2. In the Client Script add the following line if your customer field
   is called “customer”, the field in the customer master is
   “tin_number” and the field in quotation is also “tin_number”

cur_frm.add_fetch(‘customer’, ‘tin_number’, ‘tin_number’)

the format is:

cur_frm.add_fetch(fieldname, source_fieldname in the master,
target_fieldname)

If you want to do things more complicated, you can open a service
request by mailing to su...@iwebnotes.com and we can customize it
for you. We will charge Rs 500 / $10 per half hour of customization!

• Rushabh

On Oct 14, 2010, at 7:08 PM, Aditya Duggal wrote:

Thanks a lot for the quick replies, but there are some things which
still remain unanswered like:

1. If I create a custom field in the customers then is there a way to
   show that field in the quotes etc that query is still unanswered as to
   how we could fetch it in those fields by changing the doc type.

It would be greatly appreciated if you could let us know how to do
that

On Oct 14, 5:14 pm, Nabin Hait na...@iwebnotes.com wrote:

Hi,

Credit Days and Credit Limit fields are in account master of
customer.

Regards,
Nabin Hait
Web Notes Technologies

On Thu, Oct 14, 2010 at 5:27 PM, Nabin Hait na...@iwebnotes.com
wrote:

Hi,

Please see my comments below in red.

You do not require any of the fields. Those facilities are
already there in
the system.

On Thu, Oct 14, 2010 at 4:58 PM, Aditya Duggal ad...@rigpl.com
wrote:

Hi,

I have added certain custom fields to the Customers like:

1. TIN Number (Data field) - TIN Number field is not required.
   You can
   put TIN No in the “Customer Details” field. We will fetch
   “Customer Details”
   field in all sales document.

2. Discount (Float) (Basically we are tracking discounts by
   customer
   so this would help in knowing what is the discount being offered to
   the customer and then we could add the discount manually in the
   item
   selection) - It can be customized for you.

3. Credit Days (Int) (This would be shown in Invoices and would be
   added to the bill date to compute the payment due date for that
   particular invoice. - The facility is already there. You can
   enter Credit
   Days in Customer master (Customerwise) or Company master
   (Global). Due date
   will be automatically calculated based on credit days.

4. Credit Limit (Currency) (This field would actually freeze
   making of
   additional invoices if the Credit Limit is exceeded. - You can
   enter
   Credit Limit in Customer master (Customerwise) or Company master
   (Global).
   It will block if outstanding amount exceeds credit limit in
   Sales Invoice.

I would like to show this field on Quotation, Sales Order etc
when a
particular customer is selected.

Is it possible to include some of these fields to the print
formats as
well. - You can show any fields in the print format.

Regards,
Nabin Hait
Web Notes Technologies

---

---

erpnext

World’s most affordable ERP - Rs 299/user/month

https://www.erpnext.com

[rmehta]

Thanks Aditya for the bug! 

Will fix it asap and let you know

regards,

Rushabh

On Oct 15, 2010, at 10:00 AM, Aditya Duggal wrote:

This is the error I get when I pasted the following code in the Client

Side Javascript:

cur_frm.add_fetch('customer', 'hss_discount', 'hss_discount');

cur_frm.add_fetch('customer', 'carbide_discount', 'carbide_discount');

Error I get if the fields are filled, if the fields are empty then

there is no error and code goes well,

Handler Exception:{'message': 'Ok', 'exec':", 'fetch_values':

[Decimal("35.000000"),Decimal("40.000000")]}

What my analysis of the error message shows that it is fetching the

values ok from the customer but there seems to be some problem with

the pasting of the data.

Please note that both the fields HSS Discount and Carbide Discount

have same names in both the forms as hss_discount and carbide_discount

respectively.

On Oct 14, 7:18 pm, Rushabh Mehta <rm...@gmail.com> wrote:

Aditya,

At the moment, the way you can add them is as follows.

1. Open the DocType of Quotation,

2. In the Client Script add the following line if your customer field  

is called "customer", the field in the customer master is  

"tin_number" and the field in quotation is also "tin_number"

cur_frm.add_fetch('customer', 'tin_number', 'tin_number')

the format is:

cur_frm.add_fetch(fieldname, source_fieldname in the master,  

target_fieldname)

If you want to do things more complicated, you can open a service  

request by mailing to su...@iwebnotes.com and we can customize it  

for you. We will charge Rs 500 / $10 per half hour of customization!

- Rushabh

On Oct 14, 2010, at 7:08 PM, Aditya Duggal wrote:

Thanks a lot for the quick replies, but there are some things which

still remain unanswered like:

1. If I create a custom field in the customers then is there a way to

show that field in the quotes etc that query is still unanswered as to

how we could fetch it in those fields by changing the doc type.

It would be greatly appreciated if you could let us know how to do

that

On Oct 14, 5:14 pm, Nabin Hait <na...@iwebnotes.com> wrote:

Hi,

Credit Days and Credit Limit fields are in account master of  

customer.

Regards,

Nabin Hait

Web Notes Technologies

On Thu, Oct 14, 2010 at 5:27 PM, Nabin Hait <na...@iwebnotes.com>  

wrote:

Hi,

Please see my comments below in red.

You do not require any of the fields. Those facilities are  

already there in

the system.

On Thu, Oct 14, 2010 at 4:58 PM, Aditya Duggal <ad...@rigpl.com>  

wrote:

Hi,

I have added certain custom fields to the Customers like:

1. TIN Number (Data field) - TIN Number field is not required.  

You can

put TIN No in the "Customer Details" field. We will fetch  

"Customer Details"

field in all sales document.

2. Discount (Float) (Basically we are tracking discounts by  

customer

so this would help in knowing what is the discount being offered to

the customer and then we could add the discount manually in the  

item

selection) - It can be customized for you.

3. Credit Days (Int) (This would be shown in Invoices and would be

added to the bill date to compute the payment due date for that

particular invoice. - The facility is already there. You can  

enter Credit

Days in Customer master (Customerwise) or Company master  

(Global). Due date

will be automatically calculated based on credit days.

4. Credit Limit (Currency) (This field would actually freeze  

making of

additional invoices if the Credit Limit is exceeded. - You can  

enter

Credit Limit in Customer master (Customerwise) or Company master  

(Global).

It will block if outstanding amount exceeds credit limit in  

Sales Invoice.

I would like to show this field on Quotation, Sales Order etc  

when a

particular customer is selected.

Is it possible to include some of these fields to the print  

formats as

well. - You can show any fields in the print format.

Regards,

Nabin Hait

Web Notes Technologies

------------------------------------------------------------------------

---------

erpnext

World's most affordable ERP - Rs 299/user/month

https://www.erpnext.com

---------------------------------------------------------------------------------

erpnext

World's most affordable ERP - Rs 299/user/month

https://www.erpnext.com

[rmehta]

Hi Aditya,

The bug has been fixed, please check and let me know

- Rushabh

On Oct 15, 2010, at 10:00 AM, Aditya Duggal wrote:

This is the error I get when I pasted the following code in the Client

Side Javascript:

cur_frm.add_fetch('customer', 'hss_discount', 'hss_discount');

cur_frm.add_fetch('customer', 'carbide_discount', 'carbide_discount');

Error I get if the fields are filled, if the fields are empty then

there is no error and code goes well,

Handler Exception:{'message': 'Ok', 'exec':", 'fetch_values':

[Decimal("35.000000"),Decimal("40.000000")]}

What my analysis of the error message shows that it is fetching the

values ok from the customer but there seems to be some problem with

the pasting of the data.

Please note that both the fields HSS Discount and Carbide Discount

have same names in both the forms as hss_discount and carbide_discount

respectively.

On Oct 14, 7:18 pm, Rushabh Mehta <rm...@gmail.com> wrote:

Aditya,

At the moment, the way you can add them is as follows.

1. Open the DocType of Quotation,

2. In the Client Script add the following line if your customer field  

is called "customer", the field in the customer master is  

"tin_number" and the field in quotation is also "tin_number"

cur_frm.add_fetch('customer', 'tin_number', 'tin_number')

the format is:

cur_frm.add_fetch(fieldname, source_fieldname in the master,  

target_fieldname)

If you want to do things more complicated, you can open a service  

request by mailing to su...@iwebnotes.com and we can customize it  

for you. We will charge Rs 500 / $10 per half hour of customization!

- Rushabh

On Oct 14, 2010, at 7:08 PM, Aditya Duggal wrote:

Thanks a lot for the quick replies, but there are some things which

still remain unanswered like:

1. If I create a custom field in the customers then is there a way to

show that field in the quotes etc that query is still unanswered as to

how we could fetch it in those fields by changing the doc type.

It would be greatly appreciated if you could let us know how to do

that

On Oct 14, 5:14 pm, Nabin Hait <na...@iwebnotes.com> wrote:

Hi,

Credit Days and Credit Limit fields are in account master of  

customer.

Regards,

Nabin Hait

Web Notes Technologies

On Thu, Oct 14, 2010 at 5:27 PM, Nabin Hait <na...@iwebnotes.com>  

wrote:

Hi,

Please see my comments below in red.

You do not require any of the fields. Those facilities are  

already there in

the system.

On Thu, Oct 14, 2010 at 4:58 PM, Aditya Duggal <ad...@rigpl.com>  

wrote:

Hi,

I have added certain custom fields to the Customers like:

1. TIN Number (Data field) - TIN Number field is not required.  

You can

put TIN No in the "Customer Details" field. We will fetch  

"Customer Details"

field in all sales document.

2. Discount (Float) (Basically we are tracking discounts by  

customer

so this would help in knowing what is the discount being offered to

the customer and then we could add the discount manually in the  

item

selection) - It can be customized for you.

3. Credit Days (Int) (This would be shown in Invoices and would be

added to the bill date to compute the payment due date for that

particular invoice. - The facility is already there. You can  

enter Credit

Days in Customer master (Customerwise) or Company master  

(Global). Due date

will be automatically calculated based on credit days.

4. Credit Limit (Currency) (This field would actually freeze  

making of

additional invoices if the Credit Limit is exceeded. - You can  

enter

Credit Limit in Customer master (Customerwise) or Company master  

(Global).

It will block if outstanding amount exceeds credit limit in  

Sales Invoice.

I would like to show this field on Quotation, Sales Order etc  

when a

particular customer is selected.

Is it possible to include some of these fields to the print  

formats as

well. - You can show any fields in the print format.

Regards,

Nabin Hait

Web Notes Technologies

------------------------------------------------------------------------

---------

erpnext

World's most affordable ERP - Rs 299/user/month

https://www.erpnext.com

---------------------------------------------------------------------------------

erpnext

World's most affordable ERP - Rs 299/user/month

https://www.erpnext.com

[aditya2]

Hi Rushab,

Thanks for the quick reply and correction of the bug. The code is
working like a charm now.

Cheers

On Oct 15, 9:52 am, Rushabh Mehta rm...@gmail.com wrote:

Hi Aditya,

The bug has been fixed, please check and let me know

• Rushabh

On Oct 15, 2010, at 10:00 AM, Aditya Duggal wrote:

This is the error I get when I pasted the following code in the Client
Side Javascript:

cur_frm.add_fetch(‘customer’, ‘hss_discount’, ‘hss_discount’);
cur_frm.add_fetch(‘customer’, ‘carbide_discount’, ‘carbide_discount’);

Error I get if the fields are filled, if the fields are empty then
there is no error and code goes well,

Handler Exception:{‘message’: ‘Ok’, ‘exec’:", ‘fetch_values’:
[Decimal(“35.000000”),Decimal(“40.000000”)]}

What my analysis of the error message shows that it is fetching the
values ok from the customer but there seems to be some problem with
the pasting of the data.

Please note that both the fields HSS Discount and Carbide Discount
have same names in both the forms as hss_discount and carbide_discount
respectively.

On Oct 14, 7:18 pm, Rushabh Mehta rm...@gmail.com wrote:

Aditya,

At the moment, the way you can add them is as follows.

1. Open the DocType of Quotation,
2. In the Client Script add the following line if your customer field
   is called “customer”, the field in the customer master is
   “tin_number” and the field in quotation is also “tin_number”

cur_frm.add_fetch(‘customer’, ‘tin_number’, ‘tin_number’)

the format is:

cur_frm.add_fetch(fieldname, source_fieldname in the master,
target_fieldname)

If you want to do things more complicated, you can open a service
request by mailing to su...@iwebnotes.com and we can customize it
for you. We will charge Rs 500 / $10 per half hour of customization!

• Rushabh

On Oct 14, 2010, at 7:08 PM, Aditya Duggal wrote:

Thanks a lot for the quick replies, but there are some things which
still remain unanswered like:

1. If I create a custom field in the customers then is there a
   way to
   show that field in the quotes etc that query is still unanswered
   as to
   how we could fetch it in those fields by changing the doc type.

It would be greatly appreciated if you could let us know how to do
that

On Oct 14, 5:14 pm, Nabin Hait na...@iwebnotes.com wrote:

Hi,

Credit Days and Credit Limit fields are in account master of
customer.

Regards,
Nabin Hait
Web Notes Technologies

On Thu, Oct 14, 2010 at 5:27 PM, Nabin Hait na...@iwebnotes.com
wrote:

Hi,

Please see my comments below in red.

You do not require any of the fields. Those facilities are
already there in
the system.

On Thu, Oct 14, 2010 at 4:58 PM, Aditya Duggal ad...@rigpl.com
wrote:

Hi,

I have added certain custom fields to the Customers like:

1. TIN Number (Data field) - TIN Number field is not required.
   You can
   put TIN No in the “Customer Details” field. We will fetch
   “Customer Details”
   field in all sales document.

2. Discount (Float) (Basically we are tracking discounts by
   customer
   so this would help in knowing what is the discount being
   offered to
   the customer and then we could add the discount manually in the
   item
   selection) - It can be customized for you.

3. Credit Days (Int) (This would be shown in Invoices and
   would be
   added to the bill date to compute the payment due date for that
   particular invoice. - The facility is already there. You can
   enter Credit
   Days in Customer master (Customerwise) or Company master
   (Global). Due date
   will be automatically calculated based on credit days.

4. Credit Limit (Currency) (This field would actually freeze
   making of
   additional invoices if the Credit Limit is exceeded. - You can
   enter
   Credit Limit in Customer master (Customerwise) or Company master
   (Global).
   It will block if outstanding amount exceeds credit limit in
   Sales Invoice.

I would like to show this field on Quotation, Sales Order etc
when a
particular customer is selected.

Is it possible to include some of these fields to the print
formats as
well. - You can show any fields in the print format.

Regards,
Nabin Hait
Web Notes Technologies

---

---

---

erpnext

World’s most affordable ERP - Rs 299/user/month

https://www.erpnext.com

---

---

erpnext

World’s most affordable ERP - Rs 299/user/month

https://www.erpnext.com

[aditya2]

Hi,

I have just created a custom field in the Item Doctype but the problem is that I would like to call this field in the Sales Order Detail doctype when we  select an item code.

I have tried to follow the steps mentioned in this topic but I have not been able to call that new field in the Detail doctype on the basis of the itemcode.

The code I am using in the Client script of SO Details was:

cur_frm.add_fetch(‘item’,‘cetsh_number’,‘cetsh_number’);

But the above code did not fetch the required column but now the PROBLEM is that the reserved warehouse is also not getting fetched.

Please help!!!

[aditya2]

Well it seems that fetching of the Reserved warehouse was a mistake at my part only as it is coming good now.

But the initial question still remains, that how can I fetch a new data field from items in the Sales Order detail doctype.

[adityaduggal]

I am still waiting for a reply on this matter for the past 8 days

[system]

cur_frm.add_fetch() works if you want to fetch details of Item in Sales Order Details table.

syntax : cur_frm.add_fetch(link_field, src_field, tar_field)

Please check whether the field name matches with one in DocType.


cur_frm.add_fetch('item','cetsh_number','cetsh_number');

In this case it should be 'item_code'.

–
Thanks and Regards,
Saumil Dalal

Phone: 022 65265364
Web Notes Technologies Pvt. Ltd.

www.erpnext.com

On Tue, Dec 21, 2010 at 10:53 PM, Aditya Duggal <ad…@gmail.com> wrote:

I am still waiting for a reply on this matter for the past 8 days

[adityaduggal]

Thanks Saumil,

It is working perfectly now, I was making a mistake in the field name only.

[adityaduggal]

Sorry to bump up this topic again but I guess @anand did notify a new method of add_fetch which can be done by adding some code on the options field in customize form view or the doctype.

@anand please if you can share that method of pulling data.

[adityaduggal]

Nevermind: I found the new way of pulling data from another doctype. For the record:

In Options enter “doctype:field_name”

without quotes where doctype is the name of the doctype from where the data is to be pulled and field_name is the field_name of the field to be pulled from.