How to fetch a field value in another doctype

[SonalD]

I have a doctype name seed license no. i want to fetch that no in sales invoice. the seed license no have a list in which i have given no according to the state . please help. as i am new to erpnext

[avc]

Create a custom field in sales invoice. Choose “Link” type. In Options, write “Seed License no” ( exact name of the doctype you created). This way you stablish a link between both doctypes.

If you need another field from Seed License, you can add new custom field on Sales Invoice and “call it” using “Fetch from”.

There is a lot of docs related to this. Search “link” or “fetch”. You will feel the breeze

Hope this helps.

[SonalD]

i tried it…it is not working

[avc]

Please, share screenshots of your doctypes, and the options of each field involved. Probably, there is something wrong on doctype name, or field name …

[SonalD]

this is my seed license no list

[SonalD]

i want that no in this field

[avc]

@SonaID . See this:

Seed License No Doctype definition …

Sales Invoice Doctype customization …

Custom field details …

Should work this way …

Hope this helps.

[SonalD]

Thanks AVC… I dont want to select it manually…can you help me with the custom script?

[avc]

Yes, i will try … So, the id (MH-01, MH-02 …) must be fetched from Seed License No. using Shipping Address State?

[avc]

Anyway, I think that you should use different approach. Create State as a Doctype, and Seed License No as a field into it, fetching as I wrote before … No custom script would be needed this way.

[SonalD]

Thanks AVC.

[SonalD]

if you got the solution let me know… as client requirement is not manually. they want it auto populate

[avc]

Hi:

Create a client script for Doctype Sales Invoice. (and enable it )

frappe.ui.form.on('Sales Invoice', {
	your_shipping_address_state: function(frm) {
	
	    frappe.call({
            method: 'frappe.client.get_value',
            args: {
                'doctype': 'Seed License No',
                'filters': {'your_state_field': frm.doc.your_shipping_address_state},
                'fieldname': ['name']
            },
            callback: function(r) {
                if (r.message) {
                    //console.log("---------->",r.message.state);
                    frm.set_value('your_seed_license_code', r.message.state);
                    frm.refresh_field("your_seed_license_code");
                }  
            }
        });
	}

    
});

Where …

your_state_field → The field in “Seed License No” that contains the state.
your_seed_license_code → The field in “Sales Invoice” that contains Seed License No
your_shipping_address_state → The field in “Sales Invoice” that contains the destination shipping state.
name → The name of the Seed License No

This script updates the field “your_seed_license_code” when “your_shipping_address_state” value changes.

Review the fields and doctype names, probably you need change something … i don’t know real names you used.

Hope this helps.

[SonalD]

Thank you so much!!!

[SonalD]

this is my code …it showing me some error

[SonalD]

this is the error

[SonalD]

this is my seed license no doctype

[avc]

Please, check the fields “realname”. Put your mouse pointer overthe field and you will see this.

I think that this name maybe is wrong …

'filters': {'**your_state_field**' ...

[SonalD]

it is same

[avc]

I mean the state field name on the other doctype.