Create an Activity Report
If you want an activity report that looks like this example, follow the steps listed below.
Note
Maximize your browser to display this example.
Report period mm/ccyy
Period ending mm/dd/ccyy
All amounts converted to U.S. Dollars
|
Org |
GL acct |
|
|
|
|
|
+--- Period-to-Date ---+ |
|
|
|
|
Date |
Lst no |
Srce |
Reference |
Description |
Beg bal |
Debits |
Credits |
End bal |
|
|
|
|
|
|
|
|
|
|
|
|
*0 |
101 |
Cash |
|
|
|
(414723.36) |
|
|
|
|
|
05/04/ccyy |
00108-F |
GJD |
70234870 |
40405A-101 |
|
|
2500.00 |
|
|
|
05/04/ccyy |
00109-F |
GJD |
10-WC10 |
4040610-WC10 |
|
|
500.00 |
|
|
|
05/04/ccyy |
00109-F |
GJD |
10-WC10 |
4040610-WC10 |
|
|
48500.00 |
|
|
|
05/11/ccyy |
00110-F |
GJD |
10-WC10 |
4040610-WC10 |
|
|
56153.00 |
|
|
|
05/18/ccyy |
00111-F |
GJD |
1QSD |
|
98755[***] |
|
24250.00 |
|
|
|
05/18/ccyy |
00111-F |
GJD |
2247 |
238028 |
|
|
250.00 |
|
|
|
05/18/ccyy |
00109-F |
GJD |
Ck 7023 |
V13 |
9997V13 |
|
24250.00 |
|
|
|
|
|
|
|
|||||
|
ACTIVITY FOR PERIOD ENDING: 05/31/yyyy |
(156413.00) |
|
|
(258310.36) |
|||||
|
|
|
|
ACTIVITY |
|
|
(156413.00) |
|
|
(258310.36) |
- - PAGE 2- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
|
Org |
GL acct |
|
|
|
|
|
+--- Period-to-Date ---+ |
|
|
|
|
Date |
Lst no |
Srce |
Reference |
Description |
Beg bal |
Debits |
Credits |
End bal |
|
|
|
|
|
|
|
|
|
|
|
|
*0 |
110 |
Accounts Receivable |
|
|
|
(713365.42) |
|
|
(713365.42) |
|
|
05/05/ccyy |
00128-C |
GJI |
100001198 |
C9 |
10/10000084 |
5690.96 |
.00 |
|
|
|
05/06/ccyy |
00138-C |
GJI |
100001199 |
|
/100000885 |
1500.00 |
.00 |
|
|
|
05/12/ccyy |
00129-C |
GJI |
100001219 |
A-100 |
100000887 |
4439.99 |
.00 |
|
|
ACTIVITY FOR PERIOD ENDING: 05/31/yyyy |
11630.95 |
|
|
18394667.40 |
|||||
|
|
|
|
ACTIVITY |
|
|
11630.95 |
|
|
18394667.40 |
|
|
|
|
|
|
|
|
|
|
|
|
Accounts Receivable |
|
|
|
|
18383036.45 |
11630.95 |
.00 |
18394667.40 |
|
|
|
|
|
|
|
17669671.03 |
11630.95 |
.00 |
17681301.98 |
|
-
Use the Financial Reports Format Maintenance (GFM) program to create a format like this, which is simple because the report contains most of the formatting you see. You need to supply the account numbers. You do not need to enter the first two Line descriptions; they default for the accounts you entered.
|
Seq |
|
Accts |
Total 1 |
Type |
Total to add to |
Line desc |
Spaces to indent |
Lines to space |
Under-line |
|
100 |
Y |
101 |
|
A |
10 |
Cash - Bank of America |
|
N |
|
|
200 |
Y |
110 |
|
A |
10 |
Accounts Receivable |
|
0 |
|
|
300 |
Y |
|
10 |
A |
|
Current Assets |
|
0 |
|
Note
The accounts in this example are from a sample database; yours will be different. You may have additional asset accounts.
-
Use the Financial Reports Header Maintenance (GHH) program to set these parameters:
|
Report type |
Round option |
Include commas? |
Credit sign |
|
F |
1 |
Cleared |
( |
-
Use the Financial Reports Print (GP) program to print the report, using these parameters:
|
Report type |
Enter heading for this range |
Beginning period |
|
F |
Period-to-Date |
Same |