Populate custom lookup fields from Sales Order item details
Hello!
Hope you can help me out with this little issue.
I would like to achieve this via workflow.
Module: Sales Orders
I have 2 custom fields ("Proyecto" API: Proyecto and "Separa Lote" API:)
I would like to populate these 2 custom fields (lookups) from the product detail item included in the Sales Order.
1. The product item ID will be the same required to populate the "Separa Lote" field
2. Same product item ID will be help to find on the Products table the Proyecto field (also lookup) to populate the "Proyecto" field on Sales Order.
3. Sales Order Details includes 1 product only.
Please refer to the img above.
Thanks in advance!