Login to client 803, Username demo password, eyesonly.
MENU PATH
Information systems> Accounting> Financial accounting> Accounts receivable> Select report> Customer information system> Account information
Double click balances in local currency.
| Data Field | Input Data |
| Customer account | 4000-00 to 4099-99 |
| Fiscal year | 1999 |
| Reporting periods | 01 to 16 |
| Accounts sorting | 1 |
| Summarization level | 0 |
| Normal balances | checked |
Select the EXECUTE icon.
MENU PATH
List> Save> File> Spreadsheet> Continue
Enter the destination for the file output.
Start Excel. Open the file you just saved, it is tab delimited.
Place your name in the top left corner of the spreadsheet.
Answer these questions on the spreadsheet. Which account has done the most business with us in 1999? Which account owes us the most money now?
Save the spreadsheet as XYZAR1 [XYZ=your initials]
OVERDUE ITEMS BALANCE
Now use your own ingenuity to produce a list of accounts 4000-00 to 4099-99 with the highest overdue balances first. Save this as XYZAR2, put your name on it. You will have to select the highest summarization levels, 6, and 2. to control the size of the report.