Just throwing out some ideas. Maybe there's some non-printable character that got posted in somewhere? I'd try pasting the contents to a text editor that can show non-printable chars (such as Notepad++).

Also, maybe look at the resource strings? Maybe there's a resource name with some weird char?

Thank you Ryan for your answer, i ve check what you advise me to check, but i did not find any problem.

We are having two OrderProductPageV2 in two separate package: Custom and Custom_transfert, we removed all business rules in the OrderProductPageV2 in Custom_transfert and surprisingly we can edit the orderProductDetail business rules...

Thank you again for your help !

Hello Andrew,

Here is an example of how to read OrderStatus Id inside the event process:

var order = Entity.GetTypedColumnValue<Guid>("OrderId");
			var orderESQ = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "Order");
			orderESQ.UseAdminRights = true;
			orderESQ.AddColumn("Id");
			orderESQ.AddColumn("Status");
			var entity = orderESQ.GetEntity(UserConnection, order);
    		var status = entity.GetColumnValue("StatusId").ToString();
    		if (status == "{Completed OrderStatus Id}"){
    			// DO Something
    		}

Hi Dmytro, appreciate very much for the help. It works!

Hello Markus,

First of all, we don't recommend adding the same details on the page more than once as they may not behave correctly.

The "Product in Order" detail is quite specific, and is meant to be used in one section only. You can make it visible it two different tabs. 

To add the same detail twice, you can create a new detail based on this object, and then add it to the page. So the detail should work correctly.

Regards,

Gleb.

Gleb,

Thanks for answering! If I create a detail based on the same object, unfortunately the selection page (in the screenshot above) is not transferred. Any idea how I could copy this functionality to the new detail?

Hello Markus,

honestly, it is quite difficult to understand where you have the issue without looking at it. You can try the following:



1. Open this detail's settings in "Order" section

2. Go to the second section where you need this detail, open Wizard, Add new detail

3. Than you can just copy the relation from the first one (like Object, columns etc.)

4. Give you detail another Name and Code, then Save.

5. Now you have the same detail as in "Orders" which is working correctly.

If you will still have some questions, I recommend creating a case for our support team so my colleagues will be able to help you resolve the problem as quick as possible.

Regards, 

Gleb.

Markus Kumpfmüller,

To begin with, you should create a new object and set  Parent Object: BaseProductEntry.



Please follow the below steps for Product Catalogue.

 The following dependency and code to the edit page where the detail is added. (Ex: OpportunityPageV2)

            Dependency: ProductSalesUtils

            /**Opens the catalogue page**/

            openCardInChain: function(config) {

                 if (config && !config.hasOwnProperty("OpenProductSelectionModule")) {

                     return this.callParent(arguments);

                 }

                 return ProductSalesUtils.openProductSelectionModuleInChain(config, this.sandbox);

            },

Inside the Detail Schema you need to subscribe the following messages.

                       /**

                   * @message ProductSelectionInfo

                   * ########### ######### ###### ####### ########

                   * @return {Object}

                   */

                  "ProductSelectionInfo": {

                        mode: Terrasoft.MessageMode.PTP,

                        direction: Terrasoft.MessageDirectionType.SUBSCRIBE

                  },

                  /**

                   * @message ProductSelectionSave

                   * ############ ####### ######## ###### ####### #########

                   */

                  "ProductSelectionSave": {

                        mode: Terrasoft.MessageMode.PTP,

                        direction: Terrasoft.MessageDirectionType.SUBSCRIBE

                  },

            init: function() {

                this.callParent(arguments);               

                this.subscribeOnProductSelectionInfo();

                           },

subscribeOnProductSelectionInfo: function() {

    this.sandbox.subscribe("ProductSelectionSave", this.onProductsSelected, this, [this.sandbox.id + "_ProductSelectionModule"]);

    this.sandbox.subscribe("ProductSelectionInfo", function() {

           return {

                masterRecordId: this.get("MasterRecordId"),

                masterEntitySchemaName: this.get("DetailColumnName"),

               masterProductEntitySchemaName: this.entitySchemaName

             };

      }, this, [this.sandbox.id + "_ProductSelectionModule"]);

},

Important Note: You need to change the schema detail parent to "Base detail - Products". And the schema detail page to "Base edit page - Products detail".

Bhoobalan Palanivelu,

Trying to create "Product in Lead" detail with product catalogue. Using your hints, I've created new object PrbProductInLead (parent: BaseProductEntity) with Lead lookup column, added PrbProductInLeadDetail schema (parent: Base detail - Products) and PrbProductInLead1Page schema (parent: Base edit page - Products detail). Changed LeadPageV2 so it contains:

define("LeadPageV2", ["ProductSalesUtils"], function(ProductSalesUtils) {
 
...
 
            openCardInChain: function(config) {
                if (config && !config.hasOwnProperty("OpenProductSelectionModule")) {
                    return this.callParent(arguments);
                }
                return ProductSalesUtils.openProductSelectionModuleInChain(config, this.sandbox);
            },

Also I added code to PrbProductInLeadDetail:

...
		messages: {
			"ProductSelectionInfo": {
				"mode": Terrasoft.MessageMode.PTP,
				"direction": Terrasoft.MessageDirectionType.SUBSCRIBE
			},
			"ProductSelectionSave": {
				"mode": Terrasoft.MessageMode.PTP,
				"direction": Terrasoft.MessageDirectionType.SUBSCRIBE
			},
		},
...
		methods: {
			init: function() {
				this.callParent(arguments);
				this.subscribeOnProductSelectionInfo();
			},
			subscribeOnProductSelectionInfo: function() {
				this.sandbox.subscribe("ProductSelectionSave", this.onProductsSelected, this, [this.sandbox.id + "_ProductSelectionModule"]);
				this.sandbox.subscribe("ProductSelectionInfo", function() {
					var answer = {
						masterRecordId: this.get("MasterRecordId"),
						masterEntitySchemaName: this.get("DetailColumnName"),
						masterProductEntitySchemaName: this.entitySchemaName
					};
					console.log("subscribeOnProductSelectionInfo");
					console.log(answer);
					return answer;
				}, this, [this.sandbox.id + "_ProductSelectionModule"]);
			},

But when I push the AddRecordButton on Lead page, I get loading mask that won't come off until I close the page. Browser console says:

Error while sending request - InvalidTypeCastException (Column must be lookup).

What am I doing wrong? Please, help.

Regards,

Oleg.

Bhoobalan Palanivelu,



Could you please clarify whether we should create a detail (which will result in Creatio adding an object, detail, and page to the configuration) or if we must add a custom section?

"To begin with, you should create a new object and set  Parent Object: BaseProductEntry."

Team,



Any insight on this?





Regards,

Bhoobalan Palanivelu.

One approach you can take is to add a subscriber to the detail. It is a function you can add to the detail definition to receive add/edit/delete updates from the detail. I believe that is possibly how it is working now out of the box. 

Locate the detail and add a subscriber like this: 

details: {
    ProductInProductsTab: {
        schemaName: "OrderProductDetailV2",
        entitySchemaName: "OrderProduct",
        filter: {
            masterColumn: "Id",
            detailColumn: "Order"
        },
        subscriber: { methodName: "refreshAmount" }
    }
}

Then add the function:

methods: {
  refreshAmount: function() {
    // refresh or do something since the detail has had something added/edited/deleted
  }
}

Ryan

Hi, 

This logic may be quite difficult to follow, and due to that I recommend you add breakpoints in the network to see it for yourself, but if you want a small step-by-step explanation then here it is:

When you are changing the product values the system triggers the method onBaseQuantityOrUnitChange in the schema BaseProductDetailPageV2? after it calcDiscountAmount, calcTaxAmount, and calcTotalAmount also start in this schema. Then the method saveRowChanges from the schema OrderProductDetailV2 and following the chain of methods we get to refreshAmount from BaseOrderPage and updateAmount/updateAmountFromDB from ProductEntryPageUtils. After that, triggers a modifyAmountESQ/updateAmountColumnValues from BaseOrderPage and in the end calls updateAmountColumnValues from ProductEntryPageUtils which is setting the "Amount" column.

I know I missed quite a lot of steps but it's really better to inspect this logic for yourself using breakpoints.

Hello Pedro!

Unfortunately, there is no way to achieve this with built-in instruments, as it is expected that there would be a different product record for each feature so that when adding them into orders you can determine exactly what feature set is required.

However, you can do this by creating a "Replacing view model" for the "SpecificationInProductPageV2" schema. There, you would only need to change the "validateSpecification" function by removing the following part:

After that, you will be able to add multiple features into products!

Best regards,

Max.

Hello Bhoobalan,

Maybe it's much easier to modify the logic of the onGridDataLoaded method in the ProductSelectionSchema module and modify the final gridData collection that will be displayed? When the grid data is loaded in the context of execution of this method you can check all records loaded to this selection page one by one and check whether they have the needed price list (and if so leave it in the grid data, othewise remove this record from grid data) and also you can apply modifications to such records (like setting the default unit of measure). Because creating custom ESQ that is asynchronous can result in inconsistent behavior and also to errors when loading the grid.

Oleg Drobina,

It would be of great help if you could assist with a simple sample for this case in the Product selection schema.



And how to set a default value for a Unit Of Measure field and make it locked?



BR,

BBhoobalan Palanivelu.

Bhoobalan Palanivelu,

to lock the "Unit Of Measure" column you need to override the getEditableColumns method in the ProductSelectionSchema module. For example like in the example below:

getEditableColumns: function() {
				let parentColumns = this.callParent(arguments);
				if (this.Terrasoft.isCurrentUserSsp()) {
					parentColumns = this.Terrasoft.without(parentColumns, "Price");
				}
				parentColumns = this.Terrasoft.without(parentColumns, "Unit");
				return parentColumns;
			},

As a result you won't be able to modify the Unit Of Measure" column.

As for settings the removing some results from the grid: for example I have two products in the selection window: one has the price of 900 and another one has the price of 100. I want to remove the product with the price that is less or equal 100. To do so we override the onGridDataLoaded method in the following manner:

onGridDataLoaded: function(response) {
				if (!response.success || response.queryResults.length === 0) {
					return;
				}
				var dataCollection = this.Ext.create("Terrasoft.Collection");
				this.prepareResponseCollection(dataCollection, response);
				var lastValue = null;
				var gridData = this.getGridData();
				var canLoadData = false;
				for (var i=0; i < dataCollection.getItems().length; i++) {
					var price = dataCollection.getItems()[i].values.Price;
					if (price <= 100) {
						dataCollection.removeByIndex(i);
					}
				}
				if (dataCollection.getCount()) {
					var lastItemIndex = dataCollection.getCount() - 1;
					var lastItem = dataCollection.getByIndex(lastItemIndex);
					var products = gridData.collection.filterBy(
						function(res) {
							var resId = res.get("RealRecordId");
							return resId === lastItem.get("RealRecordId");
						}
					);
					if ((products.length <= 0)) {
						lastValue = lastItem.get("Name");
						canLoadData = true;
					}
				}
				this.set("sortColumnLastValue", lastValue);
				if (canLoadData) {
					gridData.loadAll(dataCollection);
				}
				this._updateGridCaptionContainerVisibility();
				this.set("GridData", gridData);
			},

the main body of the method is a basic body and the customization here goes at:

for (var i=0; i < dataCollection.getItems().length; i++) {
					var price = dataCollection.getItems()[i].values.Price;
					if (price <= 100) {
						dataCollection.removeByIndex(i);
					}
				}

where we prepare received data collection for further basic processing. So you can test this approach on your side.

Oleg Drobina,

Appreciate the detailed response!

How shall we set some particular/specific value as the default value to this Unit Of Measure (UOM) lookup field?



We have locked it in getEditableColumns() and how does the logic go by to set a default value?



Best Regards,

Bhoobalan Palanivelu.

Bhoobalan Palanivelu,

this is the custmization inside the onGridDataLoaded method, but additionally to the previous removal of records we will need to set the value for the "Unit of measure" column for each record after the unnecessary records are removed from the dataCollection.

Oleg Drobina,

Thanks for the response!



Still, the filter remains not to work even with the logic of removing values from the collection in OnGridDataLoaded().

The code gets executed but still, the products with 0 prices are shown in the Grid. please find the below references.

Logic es executing:

All records are again loaded into the Grid 

BR,

Bhoobalan Palanivelu.

Bhoobalan Palanivelu,

I've checked and indeed it happens in case there are two records with the price = 0 that are located one after another in the dataCollection (for example the 0 item has 0 price and the 1st item has 0 price). It happens because the logic removes an item with the 0 index (i=0), as a result an item with the 1 index is moved to the 0 index (because the original item with 0 index was deleted) and since we are in a cycle the code goes to check the item with the 1 index and skips that item that moved to the 0 index.

Perhaps this dataCollection should be processed in terms of a separate collection and then this custom collection should be placed into the dataCollection.

Oleg Drobina,

Yes, Now we were able to remove all the products where "Price = 0".



Also, how to make a filter to the grid products?

Unable to set the Default Value for the UOM field.



BR,

Bhoobalan Palanivelu.

Hello Bhoobalan,

Regarding the first question, the add button is defined in the ProductDetailV2 schema from the ProductCatalogue package. In this part:

onProductSelectionButtonClick: function() {
					var isCardChanged = this.isCardChanged();
					if (isCardChanged) {
						var args = {
							isSilent: true,
							messageTags: [this.sandbox.id]
						};
						this.set("OpenProductSelectionModule", true);
						this.sandbox.publish("SaveRecord", args, [this.sandbox.id]);
					} else {
						this.loadProductSelectionModule();
					}
				},

Regarding the second part where you need custom filters, pleast contact us at support@creatio.com specifying each request and each question in detail in order to understand the business task and what is the current issue.

Best regards,

Dariy

Dariy Pavlyk,

Thanks for sharing this!

Is it possible to make the Product object in the Opportunity section (OpportunityProductInterest) to open the product catalogue?

What are the steps to be carried out to make this OpportunityProductInterest open the product catalogue list?

BR,

Bhoobalan Palanivelu.

Bhoobalan Palanivelu,

We're glad to see that you were able to achieve this functionality as mentioned in these articles

https://community.creatio.com/questions/enable-product-catalog-list-ord…

https://community.creatio.com/questions/enable-product-catalog-list-ord…

Unfortunately, as it's mentioned there, it wouldn't be possible to set up a product catalogue using our OOTB object, as it is already implemented for other functionalities. 

Best regards,

Dariy

That service is being called from BaseOrderPage. In that schema there is a function that calls it named "initializePredefinedPriceList" (the actual service being called is defined in "getPriceListServiceConfig")

Ryan

Ryan Farley,

Thanks, Ryan!



Hopefully, this Base Order page is allowed in Replacing View model. It can override the getPriceListServiceConfig calling method and define a custom web service to filter the products with custom parameters.





BR,

Bhoobalan Palanivelu.

Bhoobalan Palanivelu,

Yes, you should have no issue creating a replacing schema for BaseOrderPage and then override the methods as needed.

Ryan

Ryan Farley,



Thanks!

When the (+) is clicked in Product detail (in the order section) it opens a Product List page though the detail is editable. Where is the code for add record icon and it's not available in "OrderProductDetailV2" ? and how does this product list page is opened (ProductSelectionSchema).



Step 1: Which client schema page has this add event?

Step 2: How does the Account & Price List filter is applied to Product List page.





Insight on the Schema's name and the place where the code triggering the corresponding action will be helpful.





BR,

BHoobalan Palanivelu.

Bhoobalan Palanivelu,

Hello Bhoobalan

Please do you have a suggestion on how to implement the Product Catalog that appears in the order Section, for opportunity Products in Opportunity section. Your suggestions are much appreciated !

Hello Markus,



This feature is available in 8.x sections and pages OOTB in Application Hub. You should create an Application and add sections and pages based on existing objects. The "list" tool will help you to achieve the needed list view.

In the 7.x pages - there is no no-code solution, you would need development to add numeration to OrderPageV2 and InvoicePageV2 details.

I hope my answer was useful for you!

Best Regards,

Dan

Thank you very much! 

We will test it out :)

Hi Andrew, 

Thank you for the question, but it is quite hard to understand without an example or more details. Can you please provide some test examples (with orders and products) for us to see how you would like to use this functionality? 

Best Regards,

Igor

Ihor Skohariev,

For example, I have an account "Streamline Development" that placed an order (ORD-14) in 2019.

This year she wants to place a maintenance order whose products will include some items in ORD-14.

In this case, what would you do? (Ususally, the maintenance order will include hundreds of items that from the previous orders' products)