Question
4. For this problem, use the Metaphor_Trans_All file in ACL Demo, which is the file of outstanding sales invoices (each row represents an invoice transaction).
4. For this problem, use the Metaphor_Trans_All file in ACL Demo, which is the file of outstanding sales invoices (each row represents an invoice transaction). The suggested command or other source of information needed to solve the problem requirement is included at the end of each question.
c. Determine and print accounts receivable outstanding from each customer and total the amount for comparison to part a (note: remove the filter from step b first).(Summarize and Total Field).
d. What is the largest and smallest account balance outstanding? ( Sort based on Summarize in c)
e. For the account with the largest balance, prepare and print an aging of the account from the transaction file using the statement date labeled STMTTDT. Use the aging date as of 4/30/2003 and NEWBAL as the subtotal field. (Filter and Age)
f. To better decide the customers to select for confirmation you decide to stratify customer balances into two intervals after excluding all balances less than $5,000. How many balances are greater than $5,000? Print the output. (Filter and Stratify)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started