Happy Business Starts Here

Support SME

Reporting on Split Invoices

I am wondering if I can build a report that lists any Invoices that were Split using the Split Invoices feature?






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

3 REPLIES 3
Support SME

Re: Reporting on Split Invoices

At this time, details on invoices involved in Invoice Split are not exposed on our reporting or data source exports. However, you can get these details via API.

 

Please check out our knowledge center articles on the InvoiceSplit and InvoiceSplitItem.






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

Honor Student

Re: Reporting on Split Invoices

@Rolando

 

How do we get InvoiceSplit Id or InvoiceSplititem Id because API's require respective Id's(SplitId's) to give us a response and i'm not able to find these Id's anywhere. Can you please help me out with this.

Support SME

Re: Reporting on Split Invoices

Currently, InvoiceSplit object is not available via Data Source export but you can still query it via SOAP, REST API call, and AQUA or Export ZOQL. 

If there are many Invoice Split records on your tenant, we would suggest you use Export ZOQL to query the data or you may add a filter in CreatedDate in Query API to seek better performance. 

1. SOAP API: 

<ns1:query>
    <ns1:queryString>Select Id, CreatedById, CreatedDate, InvoiceId, UpdatedById, UpdatedDate From InvoiceSplit</ns1:queryString>
</ns1:query>

2. REST API: POST https://rest.apisandbox.zuora.com/v1/action/query 

{
"queryString": "Select Id, CreatedById, CreatedDate, InvoiceId, UpdatedById, UpdatedDate From InvoiceSplit"
}

3. Export ZOQL: POST https://rest.apisandbox.zuora.com/v1/object/export

{
"Format": "csv",
"Name": "test_Export_InvoiceSplit",
"Query": "select * from InvoiceSplit",
"Status": "Processing",
"Zip": false
 

 






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