Happy Business Starts Here

New Student

TableSort: InvoiceItem.ProductName

Hi:

 

Trying to setup an invoice with TableSort: InvoiceITem.ProductName ASC or DESC does not seem to work. The InvoiceItem.ProductNames shown in the column show up neither in ASC or DESC order. Could someone please assist on this? Perhaps the SORT function is not working?

5 REPLIES 5
Zuora Support

Re: TableSort: InvoiceItem.ProductName

Greeting - Please make sure that you add " " around the merge field.

 

{ MERGEFIELD "TableSort:InvoiceItem.ProductName ASC" \* MERGEFORMAT }


If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

New Student

Re: TableSort: InvoiceItem.ProductName

I do have quotes around the TableSort, but I still cannot get it to work. Here is the code below:

 

{ MERGEFIELD "TableFilter:GroupBy ProductName, Service_Area__c, Category__c" \* MERGEFORMAT}

{ MERGEFIELD "TableSort:InvoiceItem.ProductName ASC" \* MERGEFORMAT}

{ MERGEFIELD "InvoiceItem.ProductName" \* MERGEFORMAT}

 

 

No matter how I sort it, it does not make a difference. ASC or DESC.

 

New Student

Re: TableSort: InvoiceItem.ProductName

Any resolve around this? 

Zuora Support

Re: TableSort: InvoiceItem.ProductName

Please make sure that you regenerate the Invoice PDF every time a change is made to the Invoice Template.  If the problem persists, please open a ticket with Zuora Support and our team will look into the issue further.



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

Highlighted
Scholar

Re: TableSort: InvoiceItem.ProductName

It's a bit late but it looks like you can't GroupBy and TableSort together.

 

https://knowledgecenter.zuora.com/CB_Billing/IA_Invoices/Creating_a_Custom_Invoice_Template/CC_Summa...

 

SortAndGroup.png