How to Auto Fetch Values of Linked Fields in Script?

ERPNext
, ,
1

I am trying to create a new quotation via python script.

def add_to_quote():
    uom = "Nos"
    item_code = "CC1025"

    quotation_doc = frappe.get_doc({
        "doctype": "Quotation",
        "company": "ZARNIK HOTEL SUPPLIES PRIVATE LIMITED",
        "quotation_to": "Lead",
        "party_name": "LD22120011",
        "due_date": add_to_date(datetime.now(), months=1),
        "order_type": "Shopping Cart",
        "taxes_and_charges": frappe.db.get_value("Sales Taxes and Charges Template", {"name":"Interstate - ZHSPL"}) 
    })
    quotation_doc.append("items",{
        "item_code": item_code,
        "uom": uom,
        "conversion_factor": frappe.db.get_value("UOM Conversion Detail", {"parent":item_code, "uom":uom},["conversion_factor"]),
        "qty":10,
        "rate":1000
    })
    quotation_doc.validate()
    quotation_doc.insert()
    quotation_doc.reload()

In the above method, the document is getting created, but fields that get updated with Link fields are not updated.

For example, when UOM is passed, its conversion factor is not being fetched. When taxes and charges are passed, the taxes table from table is not being fetched.

Is there an easier way to auto fetch the related fields so that all the linked fields are updated automatically?

I saw there were similar questions, but could not find the right answer. Can someone help me with a solution or direct me the right thread?

2

Did you find a solution?

3

No I did’nt. I am passing all the values now.