Hi. I am creating a delinquent report - what would be the best way to retrieve a tenant's last receipt if they haven't paid towards the current invoice?
Pull up either a found set of these records or list them in a portal.
Either way, you should be able to sort either the found set or the portal to make the most recent record the first record listed.
The report I made is taken from the most current invoice (8/21) So if Tenant has made a payment since an invoice from 5/21 how do I show that receipt on a current report?
Darn, my crystal ball has been taken over by a Ransomware virus and thus I can't see your computer nor read your mind.
I can only work from what you tell me about your solution's design in this thread. Please describe your solution in more detail so that I or others can help you.
You'll need to tell or show us what tables and relationships you have set up for managing invoices, payments and reports. Showing us the layout from which you need to manage this might also be helpful.
Please note that there's a picture tool in the tool bar of the Jive Reply box where you can insert screen shot images from your computer into the text of your next reply.
Retrieving data ...