Happy Business Starts Here

Tutor

All Invoices Paid After Due Date

Hi folks,

 

I'm trying to find all invoices that were successfully paid after the due date, but I'm not sure how to go about it.

 

Any help would be appreciated

Tags (1)
2 REPLIES 2
Highlighted
Zuora Alumni

Re: All Invoices Paid After Due Date

Hi,

 

You might want to try going to "Datasource" and use the "Invoice Payment" object.   You will notice that this object is pre-joined to multiple other objects such as "Invoice", "Account" ..etc.

 

As I don't know your full parameters, the basic object you can use is below:

 

Invoice: To get the invoice # and due date information.

Account: To get the account information.

Payment: To get payment date and status(ie..processed, error) of payment.

 

 



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

Zuora Support Moderator

Re: All Invoices Paid After Due Date

@definedv -- what @Robert mentioned above is a great way to get the data you're looking for.

 

Alternatively, I wanted to mention that you can also build this report in the Zuora Reporting area and save it for use at a future date. The Datasource Export option is more of an "ad hoc" way to grab the data out.

 

Additionally, I wanted to point you to some resources in the Knowledge Center that talks about the reporting feature:

 



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