Hi, André!
Yes, sure, I'll try to explain in more detail, thank you for your response!
There are multiple Sales orders, each with multiple lines, and each line with Reference number (SalesLine.InventRefId) to a Production order (in other words, Marking between sales order line and Production order).
So, there are multiple Production orders with same (Sales order) Reference number (ProdTable.InventRefId). Currently users are manually filtering (Created) Production orders based on the (Sales order) Reference number to estimate those Production orders together on one go. This is because each Production order has a BOM line with a (subcontracting) service item, and estimating the Production orders together groups all selected Production orders on one subcontracting Purchase order.
So, the goal is to have one corresponding subcontracting Purchase order against each Sales order. Users are looking for a way to automating this process of generating the subcontracting Purchase orders.
We can set up recurring batch job to estimate (Created) Production orders but each recurrence should include only Production orders with the same Reference number (ProdTable.InventRefId), and I am not sure if this is possible in standard system.
