Linking Sales Invoice to Sales Order after submitting and Sales Invoice

Hi there,

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


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.


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?

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?

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

Hi Parkash,
I created the custom field you said and make the edit in the invoice list one by one but the problem I’m facing is that the status of the Sales Order didn’t updated and I don’t see the invoices in the Sales Order