TableSort: InvoiceItem.ProductName

[AnshumanT]

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?

[vu_phan]

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

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

[AnshumanT]

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.

[AnshumanT]

Any resolve around this? 

[vu_phan]

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.

[terrymalone]

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