How does Request For Quotation connects with Supplier Quotation

Abhiraj_Tulsyan · December 7, 2023, 6:38am

I saw 2 DocTypes, Request For Quotation and Supplier Quotation.

When I create Request For Quotation, I can create Multiple Supplier Quotation.

My confusion was how are they connected in the database. I can’t find any field in the DocType settings which links them. I though find that in 'Connection" tab, they are getting shown. And when I click them, Supplier Quotation in the Connection Tab, I get redirected to the Supplier Quotation with the filler ‘Request For Quotation Equals {RFQ_ID}’ But where is this filter coming from since there is no Request For Quotation field in the DocType.

Am I missing something here?

HZY · December 9, 2023, 4:30am

github.com

frappe/erpnext/blob/8ddc26eb2e35d455a889f78b5f21be6392c469a8/erpnext/buying/doctype/request_for_quotation/request_for_quotation.py#L342


      
          		{
          			"show_sidebar": True,
          			"show_search": True,
          			"no_breadcrumbs": True,
          			"title": _("Request for Quotation"),
          		}
          	)
          	return list_context
          
          
          @frappe.whitelist()
          def make_supplier_quotation_from_rfq(source_name, target_doc=None, for_supplier=None):
          	def postprocess(source, target_doc):
          		if for_supplier:
          			target_doc.supplier = for_supplier
          			args = get_party_details(for_supplier, party_type="Supplier", ignore_permissions=True)
          			target_doc.currency = args.currency or get_party_account_currency(
          				"Supplier", for_supplier, source.company
          			)
          			target_doc.buying_price_list = args.buying_price_list or frappe.db.get_value(
          				"Buying Settings", None, "buying_price_list"


			"Request for Quotation Item": {
				"doctype": "Supplier Quotation Item",
				"field_map": {"name": "request_for_quotation_item", "parent": "request_for_quotation"},

[Request for Quotation Item].name → [Supplier Quotation Item].request_for_quotation_item
[Request for Quotation Item].parent → [Supplier Quotation Item].request_for_quotation