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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!