[SOLVED]: Customize Form: without coding, using the GUI

Dhanush · July 25, 2016, 7:51am

Hi all,

I want the Supplier’s TIN no to be read and displayed when the customer selects the SUPPLIER in the Purchase Order.
I am not a programmer, thus would appreciate if you guys can guide me to make this happen without me having to write code.

Thanks a lot,
Dhanush

JoEz · July 25, 2016, 9:03am

Hi u should hide field in DocType.

Go to Setup → Customize Form …select the doc type then check hidden field in TIN field.

makarand_b · July 25, 2016, 9:30am

Hi,

you can use Depends On in the permission section, add eval: doc.supplier in the depends on.
The Supplier TIN will only show if the supplier is selected otherwise the field will be hidden.

Thanks, Makarand

Dhanush · July 25, 2016, 9:53am

Hi Makarand,

thank you for your response. I have added the piece of code you provided (pic attached).

But the issue is the TIN no is not being extracted, only the TIN selection box is being shown (pic-2 attached). I want the fetched TIN to be displayed in place of the supplier’s name.
What am I doing wrong here.

Also, I’m still in the early stages of using ERPNext. Please correct me in case the issue is silly or irrelevant.

thanks,
Dhanush

Dhanush · July 25, 2016, 9:57am

Hi JoEz,

it is not hidden. I am unable to fetch the “TIN” number from Supplier records and display when the Supplier is selected.

thanks,
Dhanush

JoEz · July 25, 2016, 9:58am

@Dhanush yeah i got it …marakand solution is the one u need …did u reload the page?

Dhanush · July 25, 2016, 10:03am

@JoEz Yes JoEz, but it isn’t working. Maybe I need to change the Custom Field type into something else, but i’m not sure which one.

This is what i’ve got after applying Marakand’s solution.

I need to again select the Supplier from the list. It has to be automatically displayed.

thanks,
Dhanush

JoEz · July 25, 2016, 10:05am

@Dhanush what’s the name of supplier field?

Dhanush · July 25, 2016, 10:06am

it is “TIN”.

JoEz · July 25, 2016, 10:09am

So u have 2 Supplier fields? Supplier and TIN?

Dhanush · July 25, 2016, 10:10am

Yes, and when the Supplier is selected the respective TIN has to be fetched and displayed next to it.
Is it possible?

JoEz · July 25, 2016, 10:12am

Cant understand what u need to have …what’s TIN? The TAX ID? or what?

Dhanush · July 25, 2016, 10:13am

Yes JoEz, it is Tax ID. A unique number for each supplier.

JoEz · July 25, 2016, 10:17am

Ok …so u have it it in Supplier Doc …right?

JoEz · July 25, 2016, 10:23am

You need to add a custom script in Purchase Order, and if u have TIN in Supplier DocType use

frappe.ui.form.on("Purchase Order", "onload", function (frm) {
    frm.add_fetch("Supplier", "tin-from-supplier", "tin-to-purchase-order");
});

and change:

tin-from-supplier with the TIN field name in Supplier DocType

tin-to-purchase-order with the TIN field name in Purchase Order DocType, make this as Data and Read Only

Dhanush · July 25, 2016, 11:01am

@JoEz

thanks JoEz. I did the following.

Added “custom Script” and changed the names as in the supplier and purchase order doctypes.

Pasted image1222×318 13.8 KB

Ref-1:

Ref-2:

But the TIN field isn’t visible when the Supplier is selected. (Pic attached)

Have I missed out linking anywhere ?

PS: thank you so much for your patience. Really appreciate your help in this regard.

JoEz · July 25, 2016, 11:13am

@Dhanush, you have to add script in Purchase Order instead of Supplier

Dhanush · July 25, 2016, 11:19am

@JoEz I did that, still not showing

JoEz · July 25, 2016, 3:26pm

@Dhanush it’s kind of strange

remove eval:doc.supplier

…did u reload after changes? see pic …

What’s the value of TIN in Supplier?

Dhanush · July 25, 2016, 3:32pm

I removed the “eval:” statement and I reload it every time I make any changes.
Here are a few things I noticed:

If I name that field as “test” and not link it to the supplier field via the custom script the test box is visible. But when I rename it as “TIN” it vanishes.
can you confirm if the format of “add_fetch” which you’ve mentioned above?
It isn’t working and also I saw a few others using single quotes ( ’ ) for the parameters within.