Question: You have a file containing outstanding AR invoices. The fields include Customer _ No , Invoice _ Date, Region _ Code and Invoice _ Amt.

You have a file containing outstanding AR invoices. The fields include Customer_No, Invoice_Date, Region_Code and Invoice_Amt. If there are 10 different regions, what is the most efficient way to create a separate aging report for each region?
a.
Apply a filter for all invoices in the first region and run the Age command. Then repeat the steps for the remaining 9 regions.
b.
Extract all the invoices in the first region using a command filter and run the Age command on the result. Then repeat the steps for the remaining 9 regions.
c.
Sort or Index the file by Region_Code and run the Age command on the sorted file with the Region_Code selected on the Break parameter.
d.
Index the file by Region_Code and run the Age command on the indexed file with the Region_Code selected on the Group parameter.

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 Finance Questions!