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

ERPNext
11

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 :wink:

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’)
3 Likes