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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: