Hi Team,
I wrote a sql query to extracting customer invoices data here I am facing issue unable to find the Invoice paid status like(Fully Paid, partially Paid or Unpaid) in the table ra_customer_trx_all directly.
Kindly help me the sql query to find the Invoice paid status.
Thank you in advance.
Best Regards,
Srinivas.
AR Invoice Paid Status.docx