Auto Create Sales Invoice Submited where Submit Delivery Note

ERPNext
1

Hi,
is there any experience about make auto create sales invoice submited where submit delivery note?

my code

from erpnext.stock.doctype.delivery_note.delivery_note import make_sales_invoice
def create_sales_invoice(doc,event):
new_doc_si.save()
new_doc_si.submit()

this function i create on Dellivery Note on submite, result is create sales invoice submited but status not save like this

32
321937×292 11.5 KB

is there missing steps?

thanks.

3

Sorry, this complete code

18
181243×270 31.7 KB

4

I have found a solution to this, in case anyone needs a working serverscript. This can be added after submit on Delivery Notes:

# Collect all Sales Orders from the current Delivery Note
sales_orders = set()
for item in doc.items:
    if item.against_sales_order:
        sales_orders.add(item.against_sales_order)

# Check every Sales Order
for so_name in sales_orders:
    so = frappe.get_doc("Sales Order", so_name)
    
    # frappe.msgprint(f"SO {so.name}: per_delivered={so.per_delivered}, per_billed={so.per_billed}")

    # Check if the sales order is fully delivered and not yet fully billed
    if so.per_delivered == 100 and so.per_billed < 100:
        try:
            # Create Sales Invoice from Sales Order with frappe.get_doc
            sales_invoice = frappe.get_mapped_doc(
                "Sales Order",
                so.name,
                {
                    "Sales Order": {
                        "doctype": "Sales Invoice"
                    },
                    "Sales Order Item": {
                        "doctype": "Sales Invoice Item",
                        "field_map": {
                            "parent": "sales_order",
                            "name": "so_detail"
                        }
                    }
                }
            )
            
            # Set Delivery Note references for every item
            for si_item in sales_invoice.items:
                # Find respective Delivery Note Item
                for dn_item in doc.items:
                    if dn_item.against_sales_order == so.name and dn_item.so_detail == si_item.so_detail:
                        si_item.delivery_note = doc.name
                        si_item.dn_detail = dn_item.name
                        break
            
            sales_invoice.insert()
            
            # Optional: submit invoice directly
            sales_invoice.submit()
            
            frappe.msgprint(f"Sales Invoice {sales_invoice.name} was automatically created for Sales Order {so.name}")
            
        except Exception as e:
            frappe.log_error(
                message=f"Error while creating Sales Inovices for Order {so.name}: {str(e)}",
                title="Auto Sales Invoice Creation Error"
            )
5

@Reivan

def create_auto_sales_invoice(self,method):
	from erpnext.stock.doctype.delivery_note.delivery_note import make_sales_invoice
	new_doc_si = make_sales_invoice(self.name)
	new_doc_si.save()
	new_doc_si.submit()

hook.py

doc_events = {
    "Delivery Note": {
		"on_submit": "module.app.doctype.doctype_name.doctype_name_py_file.create_auto_sales_invoice"
	}
}