Mail Merge Reports

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 8 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

Izertis Provider
8 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
reply
- rossella
  8 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
  
  reply
rossella
8 years ago

MMR version is 2.3.0, Sugar version is CE 6.5.17

reply
Izertis Provider
8 years ago

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

reply
- rossella
  8 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
  
  reply
Izertis Provider
8 years ago

Hi Rossella,

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

Regards

Anabel

reply
- rossella
  8 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
  
  reply
Izertis Provider
8 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

reply