DISC 4372 FINAL SPRING 1999

Name___________________________ Exam Number_____________

SS#____________________________

Database Name _______

Homepage URL_______________________________

Time of Exam Start__________________________

Part 1 of 2 (50 points)

Run glrestor.htm on your database to restore it to its original status.

On all the add/modify/delete's and journal vouchers below, write the outcome of the update (i.e, worked ok or failed).

1.1 Add the following accounts to the general ledger:

MajorMinorSub 1Sub 2Description
1000400000000000Cash NY Office
1000500000000000Cash CA Office
1000600000000000Cash FL Office
1000700000000000Cash WV Office
1000700000000000Cash AZ Office

1.2 Delete the following accounts from the general ledger:

MajorMinorSub 1Sub 2
1800200000000000
9000300000000000
1000700000000000

1.3 Modify the following account descriptions:

MajorMinorSub 1Sub 2New Description
1000400000000000Cash New York
1000500000000000Cash California
1000600000000000Cash Florida

1.4 Using your transaction system post the following journal vouchers to your general ledger system:

SRN: 4111Fiscal
Month		 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-700.22Texas Sales Tax
2500100000000000700.22 
SRN: 4112Fiscal
Month		 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-5432.20Federal Taxes
24001000000000005432.20 
SRN: 4113Fiscal
Month		 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-7.11 
91001000000000007.11 
SRN: 4114Fiscal
Month		 8
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-5.60 
99999999000000005.60 
SRN: 4115Fiscal
Month		 9
MajorMinorSub 1Sub 2AmountDescription
1000100000000000100.00 
100020000000000020.00 
100030000000000020.00 
100050000000000020.00 
100060000000000020.00 
4300300030000000-180.00 
SRN: 4119Fiscal
Month		 9
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-100.00 
1000200000000000-20.00 
1000400000000000-20.00 
1000500000000000-20.00 
1000600000000000-20.00 
5000100010000000180.00 
SRN: 4116Fiscal
Month		 9
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-100.04 
500010001000000025.01 
600010001000000025.01 
700010001000000025.01 
800010001000000025.01 
SRN: 4117Fiscal
Month		 9
MajorMinorSub 1Sub 2AmountDescription
1000100000000000-37.02 
900050000000000037.20 
SRN: 4118Fiscal
Month		 9
MajorMinorSub 1Sub 2AmountDescription
9999999900000000-72.03 
400040000000000072.03 

When finished, bring up your trial balance (a44.asp) and notify Parks you are ready to have Part One graded.

PART 2 of 2 (50 points)

( DO NOT RUN glrestor before performing this part )

Produce a report which verifies the integrity of your glmaster/je tables. The report should be in five columns. The five columns are titled: ACCOUNT NUMBER, BEGINNING BALANCE, TRANSACTION ACTIVITY, CALCULATED BALANCE, ACTUAL BALANCE. For each account in the general ledger produce the following multiple row report:

The first row contains: the full general ledger account number in the first column. The second column contains the initial account balance from SRCGL. The remaining columns are blank.

Then for each transaction stored in je for the account, show the transaction amount in the third column. All other columns are blank. One row per transaction.

Then write a row that contains in the fourth column the sum of the transaction amount from the step above. This row also contains in the fifth column the current glmaster balance for the account.

If the two values in the step above differ, write out the error message: "Calculated Balance not equal Actual Balance". Write this error message on a new row that is five columns wide. Run the report against your current glmaster and je tables.

Note, to access SRCGL use: .
. set old = Server.CreateObject("ADODB.Recordset")
. old.Open "SELECT * FROM glmaster","DSN=SRCGL;UID=;PWD=;"
.

Print:

  1. a3.htm
  2. a3.asp (the posting active server page that processes transactions), and
  3. your part two asp.

Put your name, SSN, Database Acct # on each page.
Be ready to turn these in.

When finished contact Parks.