Happy Business Starts Here

Report to show all invoice line items whenever 'Charge name' of the invoice contains 'specific name'

0 Kudos

Report to show all invoice line items whenever 'Charge name' of the invoice contains 'specific name'

Hi,

I am trying to create a report to show all invoices with all the charge line items, if the invoice contains a charge name 'Cancellation'. However, the report only pulls the invoices and displays only the details of the 'Cancellation' charge line.

 

For eg. Inv123 has 3 charge lines - Cancellation Charges, Subscription charges and Proration credit of Subscription charges. This invoice meets the criteria for the report, charge name contains 'Cancellation'. We need the end report to show all the line items of this inv123 in the report. But currently, the report only pulls inv123 with 1 charge line 'Cancellation' details.

 

Thank you.

Rosalyn