As in the embedded screenshot, the Achieved Rate column (using the "Average" method to calculate totals) does not reflect the correct value of Opportunity amount column / Budget column. In this case, the row of month 8 contains 2 records of opportunities, but its Achieved Rate column value 0.83 is not 249,600/306,798; instead, 0.83 is the average of the 2 ratios of Opportunity amount/Budget of those 2 opportunities.

How can I do to display the value of 249,600/306,798 ?

Like 0

Like

7 comments

Hello Andrew,

 

Hope you're doing well.

 

Could you please provide us with the setup of the "Month" column and "Achieved Rate" column as well (with a description from which object you add it)?

 

Thank you in advance.

 

Best regards,

Roman

Hello Andrew,

 

Thank you for your reply.

At first, you can try to change the type of calculation from the "Average" to others for the 'Achieved Rate' column (for example set "Amount" to see how the calculations will be changed). Also you can compare the accuracy of the formula you use if you check the report of the needed records in excel. For that you will need to find the needed section (Opportunity), open the needed records/details for the 8th month, and export those records to excel. After that you will be able to re-check the value you received in the pivot table with the value you got in the excel report for the same period.

 

Also in the article below you can find more information about the formulas that are being used in the system:

Best regards,

Roman

Roman Rak,

Hi Roman,

 

Thank you for your reply. But it didn't answer my question.

As the screenshot below, you can see there is obviously no appropriate item to calculate what I need, and of course I had tried every item and no result was right. 

 

On the other hand, I found that in the Forecast section, the (pivot) table shown there is correct! I added a new forecast "FORECAST BY OPPORTUNITY" as shown below, and you can see the three Achieved Rates of the last 3 rows are correct respectively under the 3rd quarter of 2021.

So, what do you think?

 

Hello Andrew,

 

Could you please specify where is located the needed pivot table ('Quarter Achievement)?

 

Thank you in advance.

Hello.  I'm facing a similar issue.  Did you manage to solve it?

Show all comments

On the Creatio user contacts page, I would like to display statistics according to the selected contact.
Number of calls made, number of opportunities, etc...
Here is my question:
How to link the graphs to the selected contact ?

If i select "Current contact", it is the logged in user who is selected.

As I am on a contact page, I would like the graphics to be linked to the selected contact.

Like 0

Like

3 comments
Best reply

Hello Nicolas,

 

In order to see information for a particular contact in the dashboards you will need to associate the dashboard with section data like this:

It will only work for the records currently displayed in the list. So to see the data for one record only you will have to filter the records so that only one Contact is in the list.

 

Best regards,

Max.

Hello Nicolas,

 

In order to see information for a particular contact in the dashboards you will need to associate the dashboard with section data like this:

It will only work for the records currently displayed in the list. So to see the data for one record only you will have to filter the records so that only one Contact is in the list.

 

Best regards,

Max.

Hello Max,
On Freedom this feature is not available ?
I'm trying to put a classic graph on freedom but I can't find the "access section data" block ?
 

i find it sorry ! the parameter is on the series

Show all comments

Hello,

 

I downloaded the business card scanner from the marketplace.  The mobile app allows me to scan the business cards, but it will now allow me to save the lead.  Any suggestions?

 

It populates the fields correctly.  I am hoping there is an easy fix to this. 

Like 0

Like

4 comments

Hi Adam,

 

Please check the following and get back to us:

 

1. Can you create contacts successfully after scanning a business card?

2. Did you add additional required fields to the Leads section? If yes, this setting is blocking the lead creation.

 

Moreover, please specify your Creatio product and its version to help us to reproduce this issue.

Ivan Leontiev,

Hi Ivan,

 

we also have a problem with creating contacts with the business card scanner and it is related to required fields.

 

How can we add them to the Scan Results page?

 

Thanks and best regards,

Robert

Hello Robert,

 

Thank you for your question!

 

You can add new fields to the Scan Results page only by development. An alternative way is to create the required fields on the page level (not on the database one).

 

Kind regards,

Anastasiia

Anastasiia Lazurenko,

Thanks for the info! Is there a guide or at least some hints for adding the needed fields?

 

Thanks,

Robert

Show all comments

Hi, 

We noticed a bug relating to the add-on https://marketplace.creatio.com/template/creating-quotes-opportunities

on Creatio version 7.18.2 (can be reproduced on Demo Sales Entreprise 7.18.2, for ex).

 

When we add/update/delete a product in a Quote record, it creates an empty Opportunity record in Opportunity section.

 

I guess that it might be linked to the fact that the same object OpportunityProductInterest is used for the list of products in Opportunities and in Quotes sections. 

And there are the processes in OpportunityProductInterest object triggered upon add/update/delete .



Please note that the error didn't occure on version 7.17.1.

I can see that the object OpportunityProductInterest was modified on 2.2.2021 in Opportunity package so probably the error occures since this update.

Would it be possible for a support of DevLabs to check this issue?

 

Thank you,

Best regards,

Anna

Like 1

Like

4 comments

Hi Anna,

 

I managed to reproduce this issue and forwarded it to the relevant team for further review. We will contact you if we have feedback.

We are also experiencing this problem in CRM bundle 7.18 in .net core setup. Is there any solution or workaround present for this issue?

Hi Ivan Leontiev,

 

Are there any update from the team regarding the issue or  any workaround suggested from the team.

Hi, everyone!

We are working on this issue.

We will resolve it in the new version, however it will be incompatible with the current version. 

Also, we have a workaround for the old version:

1. Create a replacing object for OpportunityProductInterest.

 



 

2. Save it.

3. Click "Open Process"

4. Replace code in the "methods" section with this:

 





 

namespace Terrasoft.Configuration
{
 
                using DataContract = Terrasoft.Nui.ServiceModel.DataContract;
                using Newtonsoft.Json;
                using Newtonsoft.Json.Linq;
                using System;
                using System.Collections.Generic;
                using System.Collections.ObjectModel;
                using System.Data;
                using System.Drawing;
                using System.Globalization;
                using System.IO;
                using System.Linq;
                using Terrasoft.Common;
                using Terrasoft.Common.Json;
                using Terrasoft.Core;
                using Terrasoft.Core.Configuration;
                using Terrasoft.Core.DB;
                using Terrasoft.Core.DcmProcess;
                using Terrasoft.Core.Entities;
                using Terrasoft.Core.Factories;
                using Terrasoft.Core.Process;
                using Terrasoft.Core.Process.Configuration;
                using Terrasoft.GlobalSearch.Indexing;
                using Terrasoft.UI.WebControls.Controls;
                using Terrasoft.UI.WebControls.Utilities.Json.Converters;
 
                #region Class: OpportunityProductInterest_CustomEventsProcess
 
                public partial class OpportunityProductInterest_CustomEventsProcess<TEntity>
                {
 
                                #region Methods: Public
 
                                public override void CalckOpportunityAmount(Guid opportunityId) {
                                                if (opportunityId != Guid.Empty) {
                                                                var select = new Select(UserConnection)
                                                                                .Column(Func.Sum("Amount")).As("Amount")
                                                                                .From("OpportunityProductInterest")
                                                                               .Where("OpportunityId").IsEqual(Column.Parameter(opportunityId)) as Select;
                                                                double amount = 0;
                                                                select.ExecuteReader((reader => {
                                                                                amount = reader.GetColumnValue<double>("Amount");
                                                                }));
                                                                var opportunity = UserConnection.EntitySchemaManager.GetInstanceByName("Opportunity")
                                                                                .CreateEntity(UserConnection);
                                                                opportunity.FetchFromDB(opportunityId);
                                                                opportunity.SetColumnValue("Amount", amount);
                                                                opportunity.Save(false);
                                                }
 
                                }
 
                                #endregion
 
                }
 
                #endregion
}





5. Save and publish the process.

Note that this solution will take effect on basic logic for Opportunity

Show all comments

Hi Community,

 

I've this situation where I need to add a image to a specific section row column, based on the value of other column. Inside my ActivitySectionV2, I added a random dummy column to display the images. These images should appear if the Activity is expired or not. For example, if my activity due date is less than today's date the "Expired Image" should be visible.

 

How can I solve this situation?

 

Thanks in Advance.

 

Best Regards,

Pedro Pinheiro

Like 1

Like

1 comments

Hello Pedro,

 

Here is an article on the Academy that describes creating a field with an image.

I would suggest you create two fields and hide one or the other based on the due date using business rules.

 

Hope this helps!

 

Best regards,

Max.

Show all comments

Hi community !

 

Is there any way to do a switch-case with business processes?



I have a case that can reach different statuses. All the statuses are known. I have to do some things at each step of the case I currently do with a simple signal with "if status change AND status = specific_status, then ..." but I don't really like doing that. It's not readable. Is there an easier way to handle each step of a case, like a switch case or something?



Thanks in advance,



Julien Gunther

Like 0

Like

1 comments
Best reply

Hi Julien, 



If i understood your business task corectly, you need to call those processes from DCM panel. You can do so in DCM configuration. Add a step for the status, in which you want to call a process. You can refer to the screenshot below. 

Best regards,

Yurii. 

Hi Julien, 



If i understood your business task corectly, you need to call those processes from DCM panel. You can do so in DCM configuration. Add a step for the status, in which you want to call a process. You can refer to the screenshot below. 

Best regards,

Yurii. 

Show all comments

Hi Community,

 

I have built a Business Process that Triggers on "Record Added" for a Section.

My goal is that when I Create a Record in the section with OData using the "POST method", That custom business process should be triggered by System. But It is not getting triggered.

 

When I tried to create a new record from the system itself ( instead of OData ), the process got triggered. 

Can someone guide me on this? Is there any System Setting or specific configurations needed to be done?

 

I am using a cloud instance of 7.18.1.2800

Like 0

Like

5 comments
Best reply

Hi Pratik, 



This is the know issue of the version. 

Our R&D team is working on this to be fixed in the future releases. 

There's a workaround to this issue. To implement it please create following request to support team (since your instance is cloud) :

1) set "false" to following keys in  Terrasoft.WebApp\web.config 

<add key="Feature-UseSeparatedOdataEntitiesDll" value="false" />

<add key="Feature-ODataEntitiesCompilationInSeparatedDll" value="false" />

if such keys don't exist, they can be added to  the block <appSettings>;

2) Generate source code for all schemas and compile all. 





Please note, that this fix is only applicable for 7.18.1. Please remove this tags from web.config when updating to newer versions of the application, as it will cause the Odata functionality to not work. 



You can also refer to this community post in your support request. 

Best regards,

Yurii

 

Hi Pratik, 



This is the know issue of the version. 

Our R&D team is working on this to be fixed in the future releases. 

There's a workaround to this issue. To implement it please create following request to support team (since your instance is cloud) :

1) set "false" to following keys in  Terrasoft.WebApp\web.config 

<add key="Feature-UseSeparatedOdataEntitiesDll" value="false" />

<add key="Feature-ODataEntitiesCompilationInSeparatedDll" value="false" />

if such keys don't exist, they can be added to  the block <appSettings>;

2) Generate source code for all schemas and compile all. 





Please note, that this fix is only applicable for 7.18.1. Please remove this tags from web.config when updating to newer versions of the application, as it will cause the Odata functionality to not work. 



You can also refer to this community post in your support request. 

Best regards,

Yurii

 

Hi Yurii,

It Worked, Thanks for the help. 

Hi. 

This solution is for version 7.18.1 only.

Hi,

 

I have the same issue as Patrik, but I am using version 8.1.2.3942. Could you please suggest a solution? 

P.S. This logic worked for me before the upgrade.

Aurora Leka,

Hello!

 

If you are expecting such an issue using version using version 8.1.2.3942. Please take the next steps:

  1. 1. Ensure that the update was successful (double-check Update extended logs).
  2. 2. Run full schema generation and compilation process.

 

If those recommendations do not help you to solve the issue please contact support@creatio.com with information about this issue.

 

Show all comments

Hi !

 

Is there any way to change the default value when someone makes a call from "incoming" to "outgoing"?

 

 

We almost always make outgoing calls and sometimes we forget to change that and we can't change it afterwards..

Like 0

Like

3 comments
Best reply

Hello Julien,

I have the steps to change this default to outgoing here: https://customerfx.com/article/setting-the-default-call-direction-to-ou…

Ryan

Hello Julien,

I have the steps to change this default to outgoing here: https://customerfx.com/article/setting-the-default-call-direction-to-ou…

Ryan

Hello Ryan, Thank you very much !

Dear Julien, 



It's also possible to change it in Creatio UI. 

In order to change, please follow to Advanced Settings, create a replacing module for Activity object and change the default value for Call Direction column in it to Incoming. 



Kind regards,

Roman

Show all comments



Hi !

 

Is there a way to launch a business process when a specific object is opened ?

 

I have an interview object (custom) and I'd like to update some element when the object is opened then aumatically reload the object so the view of this object will be updated but I didn't find anything to make that

Like 1

Like

1 comments

Dear Julien, 



It should be possible by means of development. 

We have an academy article describing how you can set the launch for processes directly from a Client Module. 



https://academy.creatio.com/docs/developer/integrations_and_api/process…



Thank you. 

Show all comments

Hi Devlabs,

 

I have a customer who is trying to use the Slack to Feed connector.

Sales Creatio Enterprise edition version 7.18.1.2800

 

Customer:

 

I looked at the Slack integration, but Slack states the following on the website (link of the installation gide step 2):

 

image.png

As it is not allowed anymore to create legacy tokens, I do not understand how I should progress after this.

Like 0

Like

1 comments

Hi Davey,

 

We have found out that the connector requires an update due to the changes in the Slack API. We have removed the connector from Creatio Marketplace temporarily. It will be back after the update is ready. 

Show all comments