What is the query to be able to obtain the value of unpaid amount?
A report is being designed, and it is necessary to identify if the invoice is paid in full, the field payment_satu_flag is not working properly.
We have multiple invoices fully paid, but the payment_status_flag field is not syncing correctly
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
oracle fussion ERP 23D
Code Snippet (add any code snippets that support your topic, if applicable):