Skip to main content

Hello,

 

I have created lookup field of my custom object on Quote line object to retrieve the information of custom object fields in Price rules.

I have one to many relationship with Quote to Custom object. where one quote can have multiple records of custom object.

Now my requirement is that I would like to map those custom object records on each quote line item records based on the name of the group (Basically name of the group on quote line item and "Type of record" on custom object is having the same values)

 

Here is the explanation with eg.

 

Lets say on Quote line editor I create 2 groups Group A and Group B, I have same values in Custom object  under its Type of records field which are Group A and Group B.

 

My requirement is I would like to update Group A quote line items look up field (each record under Group A) with Custom Object's record having Group A values under Type of records.

Same for Group B records on Quote line editor.

 

Now Custom object can have up to 10 records with a different Type of records and the same for Groups name on quote line editor.

What is the right way to update the lookup fields on Quote line editor with the right practice.

I have thought of 2 solutions 1. Price rules but I may need to create almost as many price rules as the type of job, because it can not behave Dynamically to check and match and update record Id on lookup field on Quote lines.

2.I may use Custom action on each group to update the lookup fields on each quote lines based on the Group name. But I am not sure If I can update he records with help of custom actions.

 

Let me know if you need more information on this

 

@Yogesh Bhange

3 answers
  1. Josh Priem (Freelance) Forum Ambassador
    Sep 19, 2024, 1:07 PM

    You have a highly customized process here so what the answer is will be very specific to you. That said PRs would be the go to for this. If you need them to be dynamic you can use the formula field in the price rule, couple it with a formula field or what I think is probably best here is using a lookup price rul.

     

    Cheers!

0/9000