Dear Adebola,

If you look at basic 'Opportunity summary' template you will see that a table is created in word and only then «Product in Opportunity.Product» coulmn is added. This way all connected products will be displayed. 

If you delete the table in word and just add «Product in Opportunity.Product» coulmn, only one product will be displayed. 

Best regards,

Diana

Thanks Diana, let me explian what i was trying to get. In opportunity we have products in differentlocations (e.g location 1, location 2, location 1, location 1). I want to be able to print all products in location 1 separately from location 2. Hope to hear from you soon.

thanks

Try to create views based on the opportunity product object with filtration for separate locations. Then use the views in printables as a table part. This way you'll be able to display only products from location 1 in one printable and only products from location 2 in another printable. 

thanks Mark

Dear Adebola,

Could you please specify what you mean by view that you want to display in the template. If it is possible, please attach a screenshot

Regards,

Lily

Hi Lily,

I meant I created  table view in the databases and i want to use it in template but could not find it.

Thanks

Dear Adebola,

It is possible to choose the view table in the printable but in case it doesn't appear in the list of objects, it only means that the object was not created in a proper way. Please use any system view object as an example to create your own after you created a view table in the database.

Regards,

Lily

thanks

Dear Adebola,

Unfortunately, at the moment there is no option to make any calculations within the printable itself. We have this suggestion in mind for the further releases, but now we suggest the following workaround. 

You can create a custom total field on the page and have the business process that would calculate the total of all the products listed there. This process should populate the field and then you'll be able to display the value on the printable. 

As for the function, make sure you use the first part of the suggested function as well as the last one:

Lisa

Hi Lisa,

Thanks for the tips, i just create a process and it runs correctly but not displaying any value.

Could you please check this code, just to be sure i did everything correctly

var userConnection = Get<UserConnection>("UserConnection");

var esq = new EntitySchemaQuery(userConnection.EntitySchemaManager,"Opportunity");

esq.PrimaryQueryColumn.IsAlwaysSelect=true;

esq.AddColumn("AtsTotalCostofProductInOpportunity");

var entities = esq.GetEntityCollection(userConnection);

foreach(var entity in entities){

    var productEsq = new EntitySchemaQuery(userConnection.EntitySchemaManager, "OpportunityProductInterest");

    var amountColumn = productEsq.AddColumn(productEsq.CreateAggregationFunction(AggregationTypeStrict.Sum,"AtsLineTotal"));

    var filter = productEsq.CreateFilterWithParameters(FilterComparisonType.Equal, "Opportunity.Id", entity.PrimaryColumnValue);

    productEsq.Filters.Add(filter);

    var totalAmount = productEsq.AddColumn("AtsLineTotal").Name;

    var productEntities = productEsq.GetEntityCollection(userConnection);

    if(productEntities.Count > 0){

        var accountAmount = productEntities[0].GetTypedColumnValue<decimal>(totalAmount);

        var update = new Update(userConnection, "Opportunity")

        .Set("AtsTotalCostofProductInOpportunity",Column.Parameter(accountAmount))

        .Where("Id").IsEqual(Column.Parameter(entity.PrimaryColumnValue)) as Update;

        update.Execute();

    }

    

}

return true; 

We have checked your code – you did everything correctly.

For further investigation on the issue I suggest you to create a ticket (write to support@bpmonline.com )

Lisa Brown,

Any update for the Math functionality in Printable?



BR,

Bhoobalan Palanivelu.

Bhoobalan Palanivelu,

As I can see this idea has been accepted by our R&D team but it has a rather low priority due to a low demand for this kind of functionality. However,  it may still appear in future.

Dear Adebola,

The same topic is discussed here: https://community.bpmonline.com/discussion/10818

Please follow the suggested instructions and let us know if it helps.

Best regards,

Lily

Hi Lily,

I just followed all the steps in the previous dicussion but still didn't show up. I check under Add-in in word but not there as well. Please advise

Hi Adebola,

We have registered your request from your email and sent you ticket number.

We will investigate your particular case via that ticket.

Best regards,

Diana