I am new to using AS400 i series/applications and am becoming familiar with creating/working with existing qry reports. I am attempting to tweak an existing qry report so that it will also pull (from field needed) data to include a customer's "last payment date". I realize that this can be done in the Acct. Receivable application but it appears that this can only be done for one customer at a time.
Also, I've researched AS400 - scheduling application and did not find a way to flag future customer appts. if payment is past due (after 30 days).
I would greatly appreciate any advice offered regarding what I can do to search/locate necessary command/field (last payment date) for this qry report and how to flag future appointments.
Thank you in advance for your assistance.
Software/Hardware used: AS400 i series + applications for A/R and scheduling