Happy Business Starts Here

Re: How to Get Payment by Invoice

Menelion
Advanced Tutor

How to Get Payment by Invoice

Hello,

I'd like to get payments by invoice. So I have all the invoice info and I need to connect it to payments somehow. There is InvoiceId and InvoiceNumber in the Payment object, but they are available for creating only. How do I query payments by invoice in real time?

Thanks!

Tags (2)
2 REPLIES 2
tatyana
Valued Scholar

Re: How to Get Payment by Invoice

Menelion
Advanced Tutor

Re: How to Get Payment by Invoice

Hi, thanks.

I tried `select PaymentId from InvoicePayment where InvoiceId=<id>`. InvoiceId is valid, no errors are thrown, but ZoQL returns no results. Any more ideas please? Thanks.