Hi, guys. Another question and as always any inputs will be appreciated.
I have a Contacts Table that is related to an Invoice Table. Basically the Company in the contacts table is = to Company in my Invoice Table.
On my layout Contact Details, I have put a portal that is filtered to display only invoices from that specific contact. I have duplicated that portal to show only a single row and have put a summary field for total amount.
What I would like to do is to have an option to display sum amounts only for a certain status. Let's say sum amount of overdue transactions with Company 1; or sum amount of paid transactions with Company 2, and so on.
I tried entering find mode and typing in "paid", or "overdue", or "pending" in the field in my portal but it doesn't give me what I want, instead I get brought to a completely different contact and all invoices for that certain contact.
Idk if my approach is at all correct. Can anybody help me resolve this issue? Thanks so much as usual!