by Izertis

Create documents in docx, xlsx (MS Office Word and Excel), odt, ods (LibreOffice and OpenOffice) and pdf format without MS Office or others plugins installed from any module and subpanel using templates.

Includes a 30 day guarantee
Try it Now

By clicking you consent to share your profile with the developer

#2166 - Template for Quotes: order of products' lines in table and Groups of products

Closed General Question created by rossella 6 years ago

Dear support, I have two questions regarding templates for quotes: 1) I have noticed that the order of the products' lines in the table is not maintained. Is there a way to keep the same order in which they appear in Sugar? 2) A quote can be subdivided in one or more products' groups. Is there a way to reproduce those groups in the template? Many thanks, Regards Rossella

  1. dharma member avatar

    Izertis Provider

    6 years ago

    Hi Rossella,

    Sorry for the delay in answering you.

    1. You must use calculated fields to establish the order that you need. See examples in 'custom/modules/Opportunities/DHA_DocumentTemplatesCalculatedFields.php'”

    2. MMR module can only manage two levels of data, not more

    You can send us your template if you need more help. And tell us what is the Sugar version that you use and the MMR version also.

    Regards,

    Anabel

    • rossella member avatar

      rossella

      6 years ago

      Dear Anabel, I have uploaded the template here. I will look at the example you mentioned to see how to sort rows. Thanks, Rossella

  2. rossella member avatar

    rossella

    6 years ago

    MMR version is 2.3.0, Sugar version is CE 6.5.17

  3. dharma member avatar

    Izertis Provider

    6 years ago

    Hi Rossella, Did you find how to sort rows? Regards, Anabel

    • rossella member avatar

      rossella

      6 years ago

      Hi Anabel, yes I was able to sort rows using Calculated Fields. But I cannot figure out how to manage Groups of products. (what I'd like to achieve is reported here.) Do you have any suggestion? Best regards Rossella

  4. dharma member avatar

    Izertis Provider

    6 years ago

    Hi Rossella,

    Sorry very much for answering you so late. Do you have solved the problem already?

    Regards

    Anabel

    • rossella member avatar

      rossella

      6 years ago

      Hi Anabel, yes I was able to sort rows using Calculated Fields. But I cannot figure out how to manage Groups of products. (what I'd like to achieve is reported here.) Do you think is possible or not? Thanks Rossella

  5. dharma member avatar

    Izertis Provider

    5 years ago

    Hi Rossella,

    MMR does not permit to have three levels as you want: bugget, products group an lines of products.

    We are not sure about it.... It seems to be complicated but maybe possible.

    Maybe, you can use calculated fields to define the data of a group into the product lines, and then, to try to group them using a TinyButStrong property http://www.tinybutstrong.com/examples.php?e=grouping&m=template.

    Sorry, but this case is not included under normal support. If you want we can prepare a economic proposal.

    Regards,

    Anabel

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
  • "The single biggest downfall of the community edition of SugarCRM or SuiteCRM is the lack of creating a report form a custom module for a single event...." - ian

    Read More Reviews