I am currently designing a Gifting CRM in Creatio, where many products require customization options.
For example: Product: Custom Print T-Shirt Customization options:
Size (S, M, L, XL)
Color (Red, Blue, Black)
Print Type (Screen print, Vinyl, Embroidery)
In the standard Creatio Product data model, products are stored as individual records (SKU-based). However, if I create a separate product for every combination, it will lead to a very large number of SKUs and difficult maintenance.
My Current Approach
I am planning to:
Keep a base product in the Product catalog (e.g., “Custom Print T-Shirt”)
Create a custom object/data model to store customization options (Option Groups and Option Values)
Link these options to the product
Store selected customization at the Order Product / Opportunity Product level
For a case record all the email activity is visible to the admin roles but not to the user of a particular role.What can be the possible reason for this and how to resolve this issue?
I have noticed that configuring a list to display Agent desktop queue element (QueueItem) always results in the default column displaying 'Colum removed'. It is pointing to Caption of QueueItem.
When you try to remove it (hide) and save you will be unable to open the page in no-code configuration. Console returns: Cannot read properties of null.
Essentially we have to display this default column or the page breaks in configuration. From UI perspective it opens regardless.
I have observed this in multiple environments with versions 8.2 and higher.
It is not a big issue but I am wondering if anyone has encountered this or has a solution for this.
We are importing data from an external ERP system and creating records (e.g., Orders / Invoices) via backend code. These objects have an auto-number column (“Number”) configured with a prefix such as ORD- or INV-.
We attempted to generate the next auto-number value by querying the database sequence directly using SQL like NEXT VALUE FOR based on the column UID. This approach works in some local environments but fails in Creatio Online. The query either throws an error or does not return the expected value.
Below is the code we have written for next sequence: EntitySchema entitySchema = userConnection.EntitySchemaManager.GetInstanceByName(objectName); var numberColumn = entitySchema.Columns.GetByName("Number"); string sequenceName = numberColumn.UId.ToString();
long nextValue=0;
try { string sql = $"SELECT NEXT VALUE FOR dbo.[{sequenceName}]";
using (var dbExecutor = userConnection.EnsureDBConnection()) { using (var reader = new CustomQuery(userConnection, sql).ExecuteReader(dbExecutor)) { if (reader.Read()) { nextValue = reader.GetInt64(0); } } } } catch(Exception ex) {
}
The trail online version of Creatio is "8.3.2.4199".
First of all, how are you loading the orders/invoices? It should be creating these numbers unless you're going directly to the database (or the numbers are being created using the older method on the client-side page only).
I assume that somewhere you're setting the nextValue in the Number field and that just isn't showing in the code?
However, in the online environment, the order number is not incrementing as expected. Instead, all orders are being created with the same number (ORD-0).