How Supplier VAT Number can be reflected in every supplier related document?

[revant_one]

Hi!
I love erpnext.
Beginner question here.

I was trying out custom fields.
I created a VAT “data” field under DocType Supplier where I store VAT Numbers.

Now I wish to see the VAT number in other DocTypes related to supplier, e.g
Supplier Quotation, Purchase Order, etc.

My problem is:
Our Supplier Quotation, PO, Receipts, need to reflect the VAT number of supplier.

When I try to create a field in Supplier Quotation and link it to Supplier-vat in options it says Invalid DocType.

PS. Anyplace where I can learn about custom form/fields/scripts and how to create & interlink data within doctypes

[sunilsrikumar]

Hello

Uncheck “print hide” for the custom field which you have created under supplier DocType.

Sunil
Nescode (http://nescode.com)
Partner for ERPNext

[revant_one]

“print hide” is already unchecked.

Nothing about custom field is shown in Supplier Quotation, PO, etc.

[nabinhait]

Custom Field for Supplier Quotation:

Fieldtype: Read Only
Options: supplier.vat_number

Assuming fieldname for VAT Number in Supplier form is “vat_number”

[revant_one]

Supplier Form:

• Label: VAT Number
• Fieldname: vat_number
• Fieldtype: Data
• Nothing is checked

Supplier Quotation Form:

• Label: VAT Number
• Fieldname: vat_number
• Fieldtype: Read Only
• Options: supplier.vat_number
• Nothing is checked

I’ve entered VAT Number for a Supplier, It shows in Supplier.
There is a new field for VAT Number shown in Supplier Quotation. However for the same supplier it is blank.

[rmehta]

It will only fetch in new forms. For the old forms you might have to write an update.

[revant_one]

How to write update for old forms? any links to refer?

I need Supplier’s VAT number reflected in supplier related documents.
any other solution for same?

[rmehta]

just write an SQL UPDATE query in your MySQL. You can login to your mysql via

bench frappe --mysql

[revant_one]

Thanks for reply.

I don’t know SQL commands.

I tried to read about MariaDB update statement and example but I can’t figure out that.

Can anyone help me with syntax?

vat_number from tabSupplier should be reflected in vat_number of tabSupplier Quotation

Thanks!

[nabinhait]

update `tabSupplier Quotation` sq set vat_number = (select vat_number from `tabSupplier` where name = sq.supplier);

[revant_one]

Thank you guys!

Answer in Brief: Applies to Showing VAT Number of Supplier in Purchase Order

Create Custom field in Document “Supplier” to input Supplier’s VAT Number,

• label: VAT Number
• fieldname: vat_number
• fieldtype: data

Create Custom field in Document “Purchase Order”,

• label: VAT Number
• fieldtype: read only
• options: supplier.vat_number

Log in to mysql/mariadb

bench frappe --mysql

and write update

update `tabPurchase Order` sq set vat_number = (select vat_number from tabSupplier where name = sq.supplier);

Supplier’s VAT Number input is shown in Purchase Order.

Also add Custom Script

• DocType “Purchase Order”
• Script: cur_frm.add_fetch(‘supplier’,‘vat_number’,‘vat_number’)