Hi All,
I think this will be simple. I have a portal in a form with related tables client to accounts which allows users to apply payments to clients accounts (invoices). This related protal has an aggregate of total outstanding (total amount owing on all client invoices)
My problem is, that when a payment is applied, I cannot get the aggregate to update on the form. I have tried making the field a gloabl variable with this code:
globals.gtotalowing = clients_to_accounts_2.totaloutstanding
but this does not update. If I navigate to a different record (client) then back, the field updates obviously. How can I do this in my method so the user sees the total amount owing reduce as the fields update in the portal?? It appears to me that I need to ‘refresh’ the aggregate somehow as all other globals update in my method.
Dave