ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

Linking Sales Invoice to Sales Order after submitting and Sales Invoice


#1

Hi there,

How can I link a Sales Invoice with a Sales Order after the Sales Invoice has been submitted and paid?


#2

Hi,

For now, this is not possible without cancel and amend the submitted transaction.

As a work around, you can create a Custom Field on Sales Invoice form to keep the Sales Order log.

Best,
Prakash


#3

Thanks for the custom field hack.

Is it possible to make this change directly in the database? In other words how is the link between sales order and sales invoice created in the database?


#4

In other words, can I just update the so_detail value in the sales invoice database table to link the sales invoice with the sales order?

Are there any unexpected consequences with doing this?


#5

Hi, I have linked my sales order with my invoice …How do I prevent making of two invoices from the same sale order?