How to create a report for invoices that have promotional credits applied?

Modified on: Mon, 31 Oct, 2022 at 4:35 PM


This article covers 

How to create a report for invoices that have promotional credits applied?

How to filter invoices that have promotional credits applied to them?


Summary 


There isn't a direct way to find the invoices that have been paid using promotional credits from the UI at present, however, we can certainly do this by exporting the invoices and using the Report Builder feature in RevenueStory. 


Solution


Export invoices - 


  1. Navigate to the Invoice index page > Bulk action > Export invoices CSV


  1. In the zip file, you should find a CSV called "lineitems.CSV"

  2. Here is how the invoices paid with promotional credits will look in the CSV


  1. You can filter the entity type as “Promotional Credits” for you to be able to see the invoice having promotional credits applied to them.


Report Builder 


You can actually accomplish the same in ReportBuilder using the Invoices and Invoice Line Item section of properties/columns.

You could use the entity type =Promotional Credits under the Invoice Line Items section to accomplish this.



Related articles and Documentation

Report Builder

Promotional credits


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.
×