I want to create sales invoice document automatically on the basis on other doctype

[Mohtashim_Shoaib]

I have a doctype clinic slip and i want when user save the voucher details will go to sales invoice doctype and create a new doctype and set the enter the same data and this operation will perform automatically.

[sagar]

@Mohtashim_Shoaib refer this Get Mapped doc documentation

[Mohtashim_Shoaib]

@sagar i dont to use bookmark or button i want when i save the custom doctype voucher automatically sales invoice will submit in background.

[NCP]

Hi @Mohtashim_Shoaib,

You can create this setup on both the server and client sides.

Here’s how it works: When a Sales Order is submitted, a client script is triggered to automatically submit the corresponding Delivery Note. You’ll need to write a script to make this happen, adjusting it according to your specific scenario and mapping the fields accordingly.

Create Delivery Note from Sales Order (maped document)

Hi @Omar_Mohammed, Please apply it. frappe.db.insert({ 'doctype': 'Delivery Note', 'customer': frm.doc.customer, 'set_warehouse': frm.doc.set_warehouse, 'selling_price_list': 'Standard Selling', 'docstatus':1, 'items': frm.doc.items.map((item) => { return { 'item_code' : item.item_code, 'item_name' : item.item_name, 'rate' : item.rate, 'qty':item.qty, 'against_sales_order': frm.doc.name, 'so_detail': item.name }; }) }).then(doc => { console.log(doc.name); f…

Also, check out this link for more details and an example of a server script:

Passing supplier quotation details to Item Price List

Hi @ramalyb, Please apply the server script in your custom app. Please add in hooks.py doc_events = { "Supplier Quotation": { "on_submit": "custom_app.custom_app.doc_events.insert_item_price", } } import frappe def insert_item_price(doc, method): # Iterate through items in the Supplier Quotation for item in doc.items: # Create a new Item Price record item_price = frappe.new_doc("Item Price") item_price.item_code = item.item_code item_price.price_l…

I hope this helps.

Thank You!

[Mohtashim_Shoaib]

yes it’s help me alot now i am facing a problem i think in map i am finding problem. can you guide me it because

[NCP]

Check each field individually before saving. If the Clinic OPD Slip includes a child table and an item, link it to the sales invoice. Please test it yourself. I have provided a comprehensive reference, so it should work for everyone.

[Mohtashim_Shoaib]

@NCP

h field individually

Actually, @NCP Clinic OPD Slip does not have any child table there is a item field which had to be set on on sales invoice item table as item will fetch item name i had hardcode the qty and rate will set according to amount of clinic opd slip. in short: no child table is available at clinic opd slip.