AS400 i series – command/field for qry report “last payment date” and during scheduling – how to flag appts

30 pts.
Tags:
AS/400 queries
AS400 iseries
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    First, you need to know what file(s) contains the date field that you need. The DSPFFD (Display File Field Descriptions) can list field names from a file and their descriptions. You can also simply use the RUNQRY command to list records in a file to see what the file holds. You don't need to have a query; you can simply supply the name of a file in the QRYFILE() parameter.   Either command can help narrow down what you're looking for.   Depending on a few other factors, you might query the system database catalog to find what you need; but you possibly should get some quick early experience with native commands first.   Post back for continued discussion. Tom
    125,585 pointsBadges:
    report
  • Splat
    What 'AS400 - scheduling application' did you research?
    7,305 pointsBadges:
    report
  • Newlearner2IT
    Tom, Thank you for your help.  I will try what you've suggested and will let you know how it worked.Newlearner2IT
    30 pointsBadges:
    report
  • Newlearner2IT
    Splat,AS400 - Business Operations/Scheduling -- used to set up provider schedules (daily timed slots).  Whenever scheduling appointments for customers ( accts - overdue payments), I'm trying to find a way to flag accts. Today, it was suggested that an update could be made within each customer's record by entering a comment.  Doing + monitoring this may also require extra time for support staff if they are having to open/view/update each customer listed on a provider's daily schedule.  Thank you again for your help Splat.
    30 pointsBadges:
    report
  • TomLiotta
    ...will let you know how it worked.   Well, not much will work yet. So far, it's just thoughts on finding fields you might use for whatever will happen next. If no appropriate field can be found (i.e., one that indicates "last payment date"), it might get tricky fast. We don't know anything about the database structure you have to use.   Tom
    125,585 pointsBadges:
    report
  • Splat
    Newlearner2IT, it is likely beyond the scope and capabilities of the scheduler but I would think that when you access the customer information to retrieve the date it would be a good time to update the necessary information (assuming it meets your criteria for selection).
    7,305 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following