Pipeline structure help needed
I'm probably missing something simple, but haven't been able to find the right sequence of events to make this pipeline work as needed. Hopefully someone can point me in the right direction.
There are three tables involved in this pipeline. We can call them Orders, Invoices and Invoice Data. The pipeline is triggered by a checkbox field, Generate Invoice. This will typically be checked in grid edit and can be a single order or 100s of orders that will be combined into a single invoice. Once the checkbox(es) is(are) checked, the pipeline will start and create a new invoice record, prepare a bulk upsert in the invoice data table, search the orders table for the orders, In the loop: add a row to the upsert, remove uncheck the checkbox for generate invoice, end of loop, commit the upsert.
The problems with that flow are it is creating a new invoice for each row in the invoice data upsert and I have not been able to find a way to pull the invoice number from the new invoice record into the upsert.
I welcome your suggestions.
------------------------------
Paul Peterson
------------------------------
There are three tables involved in this pipeline. We can call them Orders, Invoices and Invoice Data. The pipeline is triggered by a checkbox field, Generate Invoice. This will typically be checked in grid edit and can be a single order or 100s of orders that will be combined into a single invoice. Once the checkbox(es) is(are) checked, the pipeline will start and create a new invoice record, prepare a bulk upsert in the invoice data table, search the orders table for the orders, In the loop: add a row to the upsert, remove uncheck the checkbox for generate invoice, end of loop, commit the upsert.
The problems with that flow are it is creating a new invoice for each row in the invoice data upsert and I have not been able to find a way to pull the invoice number from the new invoice record into the upsert.
I welcome your suggestions.
------------------------------
Paul Peterson
------------------------------
