Quotation to Invoice Problem
I have a query regarding creating an invoice.
I have a 'Quotations 'table, with a portal populated from my 'line items' table which has all my items, quantities etc. Then when I want to create an invoice, I have a script that uses the Quote ID as a variable, and then copies the data to my invoices table, as was suggested on the forum on another thread. (screenshot of script attached)
However if someone then alters the original quote for whatever reason, the invoice changes which I don't want obviously. Just wondering how to make the invoice uneditable, so essentially a snapshot of when it was created at that time.
Thanks a million