Extract Record data from the record Id

Question

All,

Quick question!

A custom Order object and Order lines are generated via a trigger from the Opportunity and Opportunity Products.

• Opportunity and Order have lookup relations between each other.
• Opportunity Product has a lookup relationship to the Order Line object.
• Order Line object does not have a lookup to the Opportunity Product. When I try to go to the Order Line, click new Lookup field the drop down does not list Opportunity Product/Line item option.
• Order Line object has the Opportunity Product's SFID stored in a text field.
• There is no parent-child relationship between Opportunity and Order .... and no parent-child between Opportunity Product and Order Line.

Ask is to use the above conditions to get Opportunity Product's fields on the Order Line object.(It can be formula field or text field on the Order Line level - Field Type does not matter) How can it be achieved?

Peace & Love

Answer 1

Opportunity Product cannot be the target of a lookup field.

As a result, you cannot follow the natural solution, which would be to create a lookup from Order Product to Opportunity Product. Instead, since you do have the Salesforce Id of the corresponding Opportunity Product populated on the Order Product, you'll have to use automation to copy the fields that are of interest to you.

That automation may be either a Process Builder launching a Flow to query the related record, or an Apex trigger. Either will work fine.

If you need to sync the data when the related Opportunity Product is updated (not just at the time the Order Product is created), you'd need to create a second Apex trigger or Process + Flow to propagate those updates.

N.b.: it really helps if you ask your question in a specific way rather than using placeholders, since there are inherent platform restrictions in play here.