Name__________________________Exam Number_____________
SS#____________________________
Database Name _______
Homepage URL_______________________________
Time of Exam Start__________________________
Run glrestor.htm on your database to restore it to its original status.
1.1 Add the following accounts to the general ledger:
Major | Minor | Sub 1 | Sub 2 | Description |
1000 | 4000 | 0000 | 0000 | Cash NY Office |
1000 | 5000 | 0000 | 0000 | Cash CA Office |
1000 | 6000 | 0000 | 0000 | Cash FL Office |
1000 | 7000 | 0000 | 0000 | Cash WV Office |
1.2 Delete the following accounts from the general ledger:
Major | Minor | Sub 1 | Sub 2 |
1800 | 2000 | 0000 | 0000 |
9100 | 1000 | 0000 | 0000 |
1000 | 7000 | 0000 | 0000 |
1.3 Modify the following account descriptions:
Major | Minor | Sub 1 | Sub 2 | New Description |
1000 | 4000 | 0000 | 0000 | Cash New York Office |
1000 | 5000 | 0000 | 0000 | Cash California Office |
1000 | 6000 | 0000 | 0000 | Cash Florida Office |
1.4 Using your transaction system post the following journal vouchers to your general ledger system:
When finished, bring up your trial balance (a44.asp) and notify Parks you are ready to have Part One graded.
SRN: 5611 Fiscal
Month 8 Major Minor Sub 1 Sub 2 Amount Description 1000 1000 0000 0000 -700.00 Texas Sales Tax 2500 1000 0000 0000 700.00 SRN: 5612 Fiscal
Month 8 Major Minor Sub 1 Sub 2 Amount Description 1000 1000 0000 0000 -5432.00 Federal Taxes 2400 1000 0000 0000 5432.00 SRN: 5613 Fiscal
Month 8 Major Minor Sub 1 Sub 2 Amount Description 1000 1000 0000 0000 -7.00 9100 1000 0000 0000 7.00 SRN: 5614 Fiscal
Month 8 Major Minor Sub 1 Sub 2 Amount Description 1000 1000 0000 0000 -5.00 9999 9999 0000 0000 5.00 SRN: 5615 Fiscal
Month 9 Major Minor Sub 1 Sub 2 Amount Description 1000 1000 0000 0000 100.00 1000 2000 0000 0000 20.00 1000 3000 0000 0000 20.00 1000 5000 0000 0000 20.00 1000 6000 0000 0000 20.00 4000 3000 3000 0000 -180.00 SRN: 5619 Fiscal
Month 9 Major Minor Sub 1 Sub 2 Amount Description 1000 1000 0000 0000 -100.00 1000 2000 0000 0000 -20.00 1000 4000 0000 0000 -20.00 1000 5000 0000 0000 -20.00 1000 6000 0000 0000 -20.00 5000 1000 1000 0000 180.00 SRN: 5616 Fiscal
Month 9 Major Minor Sub 1 Sub 2 Amount Description 1000 1000 0000 0000 -100.00 5000 1000 1000 0000 25.00 6000 1000 1000 0000 25.00 7000 1000 1000 0000 25.00 8000 1000 1000 0000 25.00 SRN: 5617 Fiscal
Month 9 Major Minor Sub 1 Sub 2 Amount Description 1000 1000 0000 0000 -37.00 9000 5000 0000 0000 37.00 SRN: 5618 Fiscal
Month 9 Major Minor Sub 1 Sub 2 Amount Description 9999 9999 0000 0000 -72.00 4000 4000 0000 0000 72.00
( DO NOT RUN glrestor before performing this part )
Produced the following cash account activity report. There should be six cash accounts in your general ledger after you complete Part 1. The report should contain FOR EACH CASH ACCOUNT:
.
. show the cash account balance as of Jan 1
. (this is available from the SRCGL that is used by the glrestor.asp program.
. It is referenced by:
.
. set old = Server.CreateObject("ADODB.Recordset")
. old.Open "SELECT * FROM glmaster","DSN=SRCGL;UID=;PWD=;"
.
. Note that this account balance is not available in SRCGL for new cash accounts added in Part 1 above
.
.
SOURCES:
.
.
show all positive cash activity for the cash account. (i.e., from the je table, show each row where the cash account has a debit balance. These are like deposits into your checking account)
.
.
TOTAL SOURCES x---------x (sum of all debit cash transactions above)
USES:
.
.
show all negative cash activity for the cash account. (i.e., from the je table.
, show each row where a cash account has a credit balance. These are like checks you wrote on your checking account)
.
.
TOTAL USES x---------x (sum of all credit cash transactions above)
NET CASH FLOW FOR CASH ACCOUNT (xxxx-xxxx-xxxx-xxxx) x-------x (THIS IS = BEGINNING CASH BALANCE + TOTAL SOURCES - TOTAL USES)
Note that this report will repeat itself six times (once for each cash account in the general ledger).
Print:
Put your name, SSN, Database Acct # on each page.
Be ready to turn these in.
When finished contact Parks.