Hello guys! Is there a way to link a Payment to its Installment using SuiteQL? I've been struggling for a while to find a way to do this query. I can get most of my needed fields from the table InvoiceInstallment, but the Payment Date doesn't belong to this table. The only thing I've accomplished so far is to return the date, but with an error that returns me as many rows as the square of the Installment Number.

Hi! I had the same issue and I could not find a way to do it in suiteql. I extract every day invoices with a due date that's 5 days old (to let the accountancy have the time to register payments). This way I overcome this problem. Netsuite somewhere has thta link because we see it in the front but I think it's not fully available in suiteql. I hope they will fix it soon. Sorry this was not really helpful

A few weeks ago I was able to overcome this issue creating a query with 2 subqueries and sorting payments based on their Payment Date. Then I force a correlation between the Payment Date and the Due Date.