home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware 1 2 the Maxx
/
sw_1.zip
/
sw_1
/
TEXT
/
PDX_ALL.ZIP
/
TI553.ASC
< prev
next >
Wrap
Text File
|
1991-09-11
|
6KB
|
199 lines
PRODUCT : PARADOX NUMBER : 553
VERSION : 3.x
OS : PC DOS
DATE : September 11, 1991 PAGE : 1/3
TITLE : AGING ACCOUNTS IN PARADOX
To begin with a table of accounts and payments that we wish to do
an account aging upon we will start with the following table:
AGING══╦══════Acct#═══╦═════Date═════╦═══════Amt════════╗
1 ║ 1234 ║ 2/12/85 ║ 750.00 ║
2 ║ 4288 ║ 3/01/85 ║ 2,500.00 ║
3 ║ 7885 ║ 6/12/85 ║ 3,590.00 ║
4 ║ 3695 ║ 3/03/85 ║ 895.00 ║
5 ║ 1234 ║ 3/15/85 ║ 350.00 ║
6 ║ 7885 ║ 3/15/85 ║ 235.00 ║
7 ║ 1234 ║ 3/18/85 ║ 350.00 ║
8 ║ 1234 ║ 3/30/85 ║ 100.00 ║
9 ║ 3695 ║ 2/12/85 ║ 325.00 ║
10 ║ 4288 ║ 3/29/85 ║ 650.00 ║
11 ║ 7885 ║ 4/03/85 ║ 340.00 ║
12 ║ 4288 ║ 3/29/85 ║ 1,250.00 ║
13 ║ 3695 ║ 2/21/85 ║ 990.00 ║
14 ║ 3695 ║ 4/01/85 ║ 2,100.00 ║
15 ║ 4288 ║ 2/28/85 ║ 21.00 ║
16 ║ 3695 ║ 4/12/85 ║ 2,350.00 ║
17 ║ 4288 ║ 2/01/85 ║ 666.00 ║
18 ║ 7885 ║ 2/04/85 ║ 1,000.00 ║
19 ║ 1234 ║ 4/12/85 ║ 235.00 ║
20 ║ 4288 ║ 5/01/85 ║ 5,000.00 ║
21 ║ 3695 ║ 5/02/85 ║ 23.00 ║
22 ║ 4288 ║ 5/13/85 ║ 1,253.00 ║
23 ║ 4288 ║ 6/06/85 ║ 560.00 ║
24 ║ 7885 ║ 3/13/85 ║ 475.00 ║
25 ║ 3695 ║ 6/23/85 ║ 100.00 ║
26 ║ 3695 ║ 6/19/85 ║ 247.00 ║
27 ║ 7885 ║ 2/01/85 ║ 950.00 ║
The following query will allow us to break down the payments by
month. In the date column, we are specifying conditions which
will determine the month and creating a field called "date", and
in the date column we are calculating the sum for that month
while creating a field called "amt".
AGING╦Acct#╦═══════════════Date═════════════════╦═════Amt═══════╗
║√ ║>1/31/85,<3/1/85, calc "Feb" as date║calc sum as amt║
║√ ║>2/28/85,<4/1/85, calc "Mar" as date║calc sum as amt║
║√ ║>3/31/85,<5/1/85, calc "Apr" as date║calc sum as amt║
PRODUCT : PARADOX NUMBER : 553
VERSION : 3.x
OS : PC DOS
DATE : September 11, 1991 PAGE : 2/3
TITLE : AGING ACCOUNTS IN PARADOX
║√ ║>4/30/85,<5/1/85, calc "May" as date║calc sum as amt║
║√ ║>5/31/85,<6/1/85, calc "Jun" as date║calc sum as amt║
Yields the following answer table:
ANSWER═╦═════Acct#═══╦════Amt════════╦═Date═╗
1 ║ 1234 ║ 235.00 ║ Apr ║
2 ║ 1234 ║ 750.00 ║ Feb ║
3 ║ 1234 ║ 800.00 ║ Mar ║
4 ║ 3695 ║ 895.00 ║ Mar ║
5 ║ 3695 ║ 1,315.00 ║ Feb ║
6 ║ 3695 ║ 4,450.00 ║ Apr ║
7 ║ 4288 ║ 687.00 ║ Feb ║
8 ║ 4288 ║ 4,400.00 ║ Mar ║
9 ║ 7885 ║ 340.00 ║ Apr ║
10 ║ 7885 ║ 710.00 ║ Mar ║
11 ║ 7885 ║ 1,950.00 ║ Feb ║
which makes more sense when rotated (Ctrl-R) as follows:
ROTATED╦═════Acct#═══╦═Date═╦════Amt════════╗
1 ║ 1234 ║ Apr ║ 235.00 ║
2 ║ 1234 ║ Feb ║ 750.00 ║
3 ║ 1234 ║ Mar ║ 800.00 ║
4 ║ 3695 ║ Mar ║ 895.00 ║
5 ║ 3695 ║ Feb ║ 1,315.00 ║
6 ║ 3695 ║ Apr ║ 4,450.00 ║
7 ║ 4288 ║ Feb ║ 687.00 ║
8 ║ 4288 ║ Mar ║ 4,400.00 ║
9 ║ 7885 ║ Apr ║ 340.00 ║
10 ║ 7885 ║ Mar ║ 710.00 ║
11 ║ 7885 ║ Feb ║ 1,950.00 ║
It also makes it easier to create a crosstab that we can use to
track the "aging" of each account. Press F10-Image-Graph-
Crosstab-Sum and then place the cursor in the CustAcct# field to
generate the row labels. Move the cursor right one field to the
Date field to set the column labels, and then move the cursor to
the right once more to generate the data to be calculated
(crosstabbed).
PRODUCT : PARADOX NUMBER : 553
VERSION : 3.x
OS : PC DOS
DATE : September 11, 1991 PAGE : 3/3
TITLE : AGING ACCOUNTS IN PARADOX
CROSSTAB╦══Acct#═╦═════Apr═════╦═════Feb═════╦═════Mar═════╗
1 ║ 1234 ║ 235.00 ║ 750.00 ║ 800.00 ║
2 ║ 3695 ║ 4,450.00 ║ 1,315.00 ║ 895.00 ║
3 ║ 4288 ║ 0.00 ║ 687.00 ║ 4,400.00 ║
4 ║ 7885 ║ 340.00 ║ 1,950.00 ║ 710.00 ║
Rotating the fields again using Ctrl-R will make more sense since
the crosstab will create the month (column) fields
alphabetically:
CROSSTAB╦══Acct#═╦═════Feb═════╦═════Mar═════╦═════Apr═════╗
1 ║ 1234 ║ 750.00 ║ 800.00 ║ 235.00 ║
2 ║ 3695 ║ 1,315.00 ║ 895.00 ║ 4,450.00 ║
3 ║ 4288 ║ 687.00 ║ 4,400.00 ║ 0.00 ║
4 ║ 7885 ║ 1,950.00 ║ 710.00 ║ 340.00 ║
This will show us the activity of each account by month.