How to dynamically insert Parent and Child Doctype from server script?

Muhammad_Ibrahim1 · August 3, 2021, 1:09pm

I have 3 doctypes A, B and C (C has a child table). On the basis of a server script in doctype A I want to dynamically insert Doctype C and its child table. Can anyone help me out with this?

iRaySpace · August 3, 2021, 1:34pm

Hello,

Do you mean inserting with the use frappe.new_doc() and append to the child table?
You might want to take a look at this:

github.com

frappe/erpnext/blob/version-13/erpnext/accounts/doctype/sales_invoice/sales_invoice.py#L1841


      
          	if doc.party_account_currency != doc.currency:
          		total_fieldname = "base_" + total_fieldname
          
          
	return flt(doc.get(total_fieldname), doc.precision(total_fieldname))
          
          

          
def is_overdue(doc, total):
          	outstanding_amount = flt(doc.outstanding_amount, doc.precision("outstanding_amount"))
          	if outstanding_amount <= 0:
          		return
          
          
	today = getdate()
          	if doc.get("is_pos") or not doc.get("payment_schedule"):
          		return getdate(doc.due_date) < today
          
          
	# calculate payable amount till date
          	payment_amount_field = (
          		"base_payment_amount" if doc.party_account_currency != doc.currency else "payment_amount"
          	)
          
          
	payable_amount = sum(

Regards,

Ivan

Muhammad_Ibrahim1 · August 3, 2021, 2:00pm

if doc.second_parent_name:
doc = frappe.get_doc({
“doctype”: “Parent”,
“p_name”: doc.first_parent_name,
“p_num”: 42,
“status”: “Open”,
})
doc.insert()

parent = frappe.get_doc('Parent', doc.first_parent_name)
child = frappe._dict({
     'c_name': doc.child_name,

})
parent.c_name.append(child)

This the server script I wrote and its not working atm. So the three doctypes are Parent, Child(Child is a child of parent), Second Parent. I have written this script in Second Parent who’s fields are the same as the ones in Parent And Child.

iRaySpace · August 4, 2021, 7:26am

Hello,

Use parent.append("c_name", child) and then parent.save() to take effect.

Regards,

Ivan