Because in the stock_move table, the procurement_id field is left blank if its part of an existing procurement.. This obstructs me from sending information from Sales Order Line to it's respective BoM product(s) in Manufacturing Order.

Example

Product A = B+C+D

In Sales Order Line select Product A, (with user input product A information)

Manufacturing Order for Product A has a procurement_id so product A information will appear

Manufacturing Order for Product B,C & D has no procurement_id  so no Product A information will appear

SO I plan to loop through stock_move table. & for each production_id value that is empty, it to be equal to the production_id in the previous row

Thanks a lot