Zoho Books - Payments Made does not Connect to Invoices table?
Hello Zoho team,
We have set up a sync from Zoho Books for most modules including Invoices and Customer Payments. All our payments are always applied to an invoice. Using API we can always find the invoices that a payment has been applied to. However, using Zoho Analytics, I cannot find any way to connect the Customer Payments and Invoices tables. The Invoices table has no reference to the payment, and the Customer Payments table does not have any reference to the Invoice that it's applied to. How can I connect these two tables? Shouldn't the Customer Payments have a column for "Payment applied to Invoice"?