Question

How to display qualified quote price for a product in the opportunity-product detail (grid list).

How to display qualified quote price for a product in the opportunity-product detail (grid list).

This is required for scenario: A merchandiser will get multiple quotes from different supplier for a raw material. He will select one using a lookup. Selected price and supplier should get added to the respective raw material in the grid list in opportunity product detail to determine final price of the product

Please help

Like 0

Like

5 comments

Hi!

If a detail is on the same page as a  lookup you will need send a message to the detail using messaging mechanism. If you want to change data on other pages then you need use a client UpdateQuery class to update needed data and then send a message in order to refresh data in opened details. You may find many examples of using UpdateQuery in the configuration

Peter Vdovukhin,

Hi Peter, Thanks for the information.

We are looking for the 2nd scenario where we need to change data into different page. Can you provide us more information on the approach through an example.

Thanks...

I need more detailed explanation to create such example. All I do understand now is that you want to update opportunity product detail (by inserting a new record or updating an existing one?). Please describe in what object and what property is changed that fires detail updating and what relationship between that lookup and the detail (or how do you know what details to change?) . If you can add some screenshots it will help too

Peter Vdovukhin,

Merchandiser will add multiple products in Opportunity - Product details. For each product multiple suppliers will provide quote specific for the opportunity in Quote section. Merchandiser will select one of the quote for a product using a lookup (Yes/No). Once merchandiser selects yes for a Quote, price and supplier for the product should get updated against the product.

Hope above will provide you more clarity. We are still working on the opportunity-product grid view so the screen shots are not avalable

Not sure I understand the whole case. Let's provide you an abstract example of updating opportunity product detail:

// create update instance on OpportunityProductInterest detail schema

var update = this.Ext.create("Terrasoft.UpdateQuery", {

                    rootSchemaName: "OpportunityProductInterest"

                });

// add filter on product in the detail

                update.filters.add("Product", Terrasoft.createColumnFilterWithParameter(

                    Terrasoft.ComparisonType.EQUAL, "Product", "a802f388-59aa-4b69-88c3-ecc9078bf27d"));

// set value to a field that you need to update

                update.setParameterValue("OfferResult", "12d2c66b-7ae6-df11-971b-001d60e938c6", this.Terrasoft.DataValueType.GUID);

// launch update

                update.execute();

            },

This javascript code updates opportunity product details. It sets a value to OfferResult field ("Interest" caption in a grid) for all opportunity product details for specific product. You can change this code to meet your needs. If you have a full bundle as I do, this code already works because ids from the example above exist in this bundle. So you may check it

Show all comments