EXAM TO BE RETURNED BY 5:30 PM FRI MAY 4 TO 280E MH

1. Steps 2 thru 6 below should be performed 3 times
   1. First, run your glrestor program on your database to restore it to its original status. On all the add/modify/delete's and journal vouchers below (steps 2 thru 6), write in first column of the outcome of the transaction (i.e., "ok" or "failed") with an explanation of why -- if it failed.
   2. Second, modify your glrestor program by changing:
         this line: rsold.open oldsql,"DSN=SRCGL;UID=;PWD=;"
         to this: rsold.open oldsql,"DSN=SRCGLV;UID=;PWD=;"
      Run glrestor.asp again. On all the add/modify/delete's and journal vouchers below (steps 2 thru 6), write in second column of the outcome of the transaction (i.e., "ok" or "failed") with an explanation of why -- if it failed.
      
   3. Third, modify your glrestor program by changing:
         this line: rsold.open oldsql,"DSN=SRCGLV;UID=;PWD=;"
         to this: rsold.open oldsql,"DSN=SRCGLC;UID=;PWD=;"
      Run glrestor.asp again. On all the add/modify/delete's and journal vouchers below (steps 2 thru 6), write in third column of the outcome of the transaction (i.e., "ok" or "failed") with an explanation of why -- if it failed.
2. Delete the following accounts from the general ledger:

   Major	Minor	Sub 1	Sub 2	Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   2000	2000	0000	0000
   2400	4000	0000	0000
   9000	9000	0000	0000
   4000	3000	4000	0000
   9999	9999	0000	0000

3. Add the following accounts to the general ledger:

   Major	Minor	Sub 1	Sub 2	Description	Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   9000	9000	0000	0000	Local Gas
   1100	0003	0000	0000	Chevron Stock
   9100	2000	0000	0000	Flood Insurance
   1000	5000	0000	0000	Cash Piltdown Branch Bank
   4000	3000	4000	0000	IT Consulting Services
   4000	3000	5000	0000	Foreign Catalogue Sales
   5000	1000	3000	0000	Direct Labor On-line Store
   1000	3000	0000	0000	Cash -- Piltown Main Bank
   1100	0004	0000	0000	Cisco Stock
   1700	3000	0000	0000	Server Room UPC
   4000	3000	5000	0000	Foreign Catalogue Sales

4. Modify the following account descriptions:

   Major	Minor	Sub 1	Sub 2	New Description	Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   3000	6000	0000	0000	Retained Earnings (Cumulative)
   1000	5000	0000	0000	Cash Pildown Bank
   4000	4000	0000	0000	Capt. Webb In-store Sales
   9300	1000	0000	0000	Gin and Tonic Expense
   9999	9999	0000	0000	Suspense Account
   4000	2000	0000	0000	Gift Card Revenue
   1900	1000	0000	0000	Prepaid Auto Rental
   9000	4000	0000	0000	Insurance Expense
   4000	3000	5000	0000	Foreign Catalog Sales

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

   SRN:	2311	Fiscal Month	8			Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   Major	Minor	Sub 1	Sub 2	Amount	Description
   9000	1000	0000	0000	347.14	Tulsa Office Rent
   1000	5000	0000	0000	-347.14
   SRN:	2312	Fiscal Month	8			Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   Major	Minor	Sub 1	Sub 2	Amount	Description
   2600	2000	0000	0000	3257.44	Credit Union Matching Contributions
   1000	3000	0000	0000	-3257.44
   SRN:	2313	Fiscal Month	8			Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   Major	Minor	Sub 1	Sub 2	Amount	Description
   1000	1000	0000	0000	-67487.04	Buy Chevron Stock
   1100	0003	0000	0000	67487.04
   SRN:	2314	Fiscal Month	8			Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   Major	Minor	Sub 1	Sub 2	Amount	Description
   3000	6000	0000	0000	-975.00	Clear Suspense
   9999	9999	0000	0000	975.00
   SRN:	2315	Fiscal Month	8			Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   Major	Minor	Sub 1	Sub 2	Amount	Description
   1000	1000	0000	0000	67812.33	Sales for March 2012
   4000	3000	4000	0000	-67000.00
   4000	3000	3000	0000	-800.00
   4000	3000	2000	0000	-10.00
   4000	3000	1000	0000	-2.33
   SRN:	2316	Fiscal Month	8			Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   Major	Minor	Sub 1	Sub 2	Amount	Description
   9000	9000	0000	0000	1422.45	Valero Credit Card for Gasoline
   1000	4000	0000	0000	-1422.45
   SRN:	2361	Fiscal Month	8			Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   Major	Minor	Sub 1	Sub 2	Amount	Description
   1000	2000	0000	0000	-778.13	ATT Mobile Phone Bill
   9000	6000	0000	0000	778.13
   SRN:	2317	Fiscal Month	8			Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   Major	Minor	Sub 1	Sub 2	Amount	Description
   1000	1000	0000	0000	-216.23	Pay FICA
   2400	4000	0000	0000	-216.23
   SRN:	2318	Fiscal Month	8			Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   Major	Minor	Sub 1	Sub 2	Amount	Description
   1100	0004	0000	0000	2336.12	Buy Cisco Stock
   1000	5000	0000	0000	-2336.12
   SRN:	2319	Fiscal Month	8			Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   Major	Minor	Sub 1	Sub 2	Amount	Description
   1700	2000	0000	0000	3468.24	Buy New Copier
   1000	3000	0000	0000	-1734.12
   1000	2000	0000	0000	-1734.12
   SRN:	2320	Fiscal Month	8			Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   Major	Minor	Sub 1	Sub 2	Amount	Description
   1000	1000	0000	0000	-5100.00	Move Cash to Pildown
   1000	5000	0000	0000	5100.00
   SRN:	2321	Fiscal Month	8			Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   Major	Minor	Sub 1	Sub 2	Amount	Description
   9000	2000	0000	0000	648.61	Pay new Ship Rudder
   1000	1000	0000	0000	-648.61
   SRN:	2322	Fiscal Month	8			Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   Major	Minor	Sub 1	Sub 2	Amount	Description
   1000	1000	0000	0000	-538.00	Tennis Club Dues
   1000	2000	0000	0000	-583.00
   1000	3000	0000	0000	-5.00
   1000	4000	0000	0000	-0.50
   1000	5000	0000	0000	-0.05
   9000	3000	0000	0000	555.55
   SRN:	2361	Fiscal Month	8			Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   Major	Minor	Sub 1	Sub 2	Amount	Description
   1000	1000	0000	0000	71.41	Whiteboard Markers
   9000	5000	0000	0000	-71.41
   SRN:	2323	Fiscal Month	8			Outcome using SRCGL	Outcome using SRCGLV	Outcome using SRCGLC
   Major	Minor	Sub 1	Sub 2	Amount	Description
   1000	6000	0000	0000	-229.13	Airplane Fuel
   9000	9000	0000	0000	229.13

6. Fill in the answers to the following questions (after completing sections 2, 3, 4, and 5 above):

   	Using SRCGL	Using SRCGLV	Using SRCGLC
   The glmaster balance is	$______________	$______________	$______________
   The number of accounts in the glmaster table	_______________	_______________	_______________
   The number of rows in the je table is: (see 9 below)	_______________	_______________	_______________
   Are any Cash accounts overdrawn? If so, which ones:	_______________	_______________	_______________

7. Print a copy of EACH your trial balance outputs (a44.asp, a44v.aspx, a44c.aspx) after you have completed posting the transactions above.

   BE SURE TO: ORDER THE REPORT IN ASCENDING ACCOUNT NUMBER ORDER.
   BE SURE TO: SHOW THE OVERALL glmaster BALANCE.
   BE SURE TO: SHOW THE NUMBER OF ACCOUNTS IN THE glmaster TABLE.
   BE SURE TO: SHOW THE REPORT TIME AND DATE.

   Make sure ALL of your working code is uploaded and working on your server account.

   Make sure your index.htm file has working links to each assignment component

8. Print and hand in the source code for the server side programs that post the journal voucher data -- i.e., a3.asp, a3v.aspx, a3c.aspx )

9. Print and hand in a copy of the EACH of the three je tables after posting. (THIS IS A NEW ASSIGNMENT)
   Sort the table by sourceref ASC, srseq ASC. Show the number of journal entries AND the number of journal vouchers.