Dear Appsheeters,
I'm making two modules: "Sales Quotation" and "Sales Order".
The Sales Quotation module, consists of three tables: [Sales Quotation], [Sales Quotation Details], and [Sales Quotation Payment Terms]
While the Sales Order module, reflecting similar tables, consists of three tables: [Sales Order], [Sales Order Details], and [Sales Order Payment Terms].
I want to create a button (Convert SQ to SO) in the Sales Quotation, which will do several actions:
I managed to do action no. 1, since it’s a direct copy between parent tables [Sales Quotation] to [Sales Order]. But I have problems that are confusing me to do a loop for copying data from [Sales Quotation Details] to [Sales Order Details], since doing so will need me to put the newly generated [Sales Order No.] from the [Sales Order] parent table.
The problems also occurred with the Payment Terms.
I need your advice.
Thank you.