MIS 4372 FINAL FALL 2011

Name_________________________________________________________

Last 4 Digits of your PSID___________

disc-nt Server Account___________________ (glxxxx)

e-mail address__________________________________________

1. (50 points) TO BE RETURNED BY 5:30 PM MON DEC 5 TO 280E MH

1.1 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, write the outcome of the transaction (i.e., "ok" or "failed") with an explanation of why -- if it failed.

1.2 Delete the following accounts from the general ledger:

Major Minor Sub 1 Sub 2 Outcome
2000 2000 0000 0000  
2400 4000 0000 0000  
9000 9000 0000 0000  
4000 3000 4000 0000  
9999 9999 0000 0000  

1.3 Add the following accounts to the general ledger:

Major Minor Sub 1 Sub 2 Description Outcome
9000 9000 0000 0000 Automobile Gas  
1100 0003 0000 0000 Exxon Stock  
9100 2000 0000 0000 Hurricane Insurance  
1000 5000 0000 0000 Cash Rough and Ready Bank  
4000 3000 4000 0000 Consulting Services  
5000 1000 3000 0000 Direct Labor Catalog Operations  
1000 3000 0000 0000 Cash -- Rough and Ready Bank, East Point GA  
1100 0004 0000 0000 Amazon Stock  
1700 3000 0000 0000 HP Server Farm  
4000 3000 4000 0000 Capt. Webb Consulting Service  

1.4 Modify the following account descriptions:

Major Minor Sub 1 Sub 2 New Description Outcome
3000 6000 0000 0000 Retained Earnings (Cumulative Profits or Losses)  
1000 5000 0000 0000 Cash Rough and Ready Bank, East Point Georgia  
4000 4000 0000 0000 Capt. Webb DNS Name Resale  
9300 1000 0000 0000 Computer World Ad Expenses  
9999 9999 0000 0000 Suspense Account  
4000 2000 0000 0000 Annual Capt. Webb Conference Revenue  
1900 1000 0000 0000 Prepaid Office Rental  
9000 4000 0000 0000 Insurance Expense  
4000 3000 2000 0000 Splendora Walk-in Store Revenues  

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

SRN:  2311 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
9000 1000 0000 0000 144.13 Pay More Office Rent  
1000 5000 0000 0000 -144.13  
SRN:  2312 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
2600 2000 0000 0000 1217.52 Pay Credit Union Matching Contributions  
1000 2000 0000 0000 -1217.52    
SRN:  2313 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 1000 0000 0000 -73487.04 Buy Exxon Stock  
1100 0003 0000 0000 73487.04    
SRN:  2314 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
3000 6000 0000 0000 -975.00 Clear Suspense  
9999 9999 0000 0000 975.00    
SRN:  2315 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 1000 0000 0000 82478.11 Sales for September 2011  
4000 3000 4000 0000 -82000.00    
4000 3000 3000 0000 -400.00    
4000 3000 2000 0000 -70.00    
4000 3000 1000 0000 -8.11    
SRN:  2316 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
9000 9000 0000 0000 2433.81 Exxon Credit Card for Gasoline  
1000 4000 0000 0000 -2433.81    
SRN:  2361 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 2000 0000 0000 -6578.13 Verizon Mobile Phone Bill  
9000 6000 0000 0000 6587.13    
SRN:  2317 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 1000 0000 0000 -3326.33 Pay FICA  
2400 4000 0000 0000 -3326.33    
SRN:  2318 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1100 4000 0000 0000 1836.36 Buy Amazon Stock  
1000 1000 0000 0000 -1836.36  
SRN:  2319 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1700 1000 0000 0000 2814.34 Buy New Barcelona Chairs  
1000 5000 0000 0000 -1407.17    
1000 2000 0000 0000 -1407.14    
SRN:  2320 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 1000 0000 0000 -5100.00 Move Cash to GA  
1000 5000 0000 0000 5100.00    
SRN:  2321 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
9000 2000 0000 0000 345.63 Pay Travel Expense for the Captain Vacation  
1000 1000 0000 0000 -345.63    
SRN:  2322 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 1000 0000 0000 -600.00 Tennis Club Dues  
1000 2000 0000 0000 -20.00  
1000 3000 0000 0000 -5.00  
1000 4000 0000 0000 -0.20  
1000 5000 0000 0000 -0.01  
9000 3000 0000 0000 625.21    
SRN:  2361 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 1000 0000 0000 671.41 Paper Clip Supplies  
9000 3000 0000 0000 -671.41    
SRN:  2323 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 6000 0000 0000 -229.13 Airplane Fuel  
9000 9000 0000 0000 229.13    

1.6 Fill in the answers to the following questions (after completing sections 1.1, 1.2, 1.3, 1.4, and 1.5 above):

  1. The glmaster balance is $______________.
  2. The number of accounts in the glmaster table _______________.
  3. The number of rows in the je table is _________________.
  4. Are any Cash accounts overdrawn? If so, which ones:__________________________________ .

1.7 Print a copy of your a44.asp trial balance output 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

1.8 Print and hand in:

  1. a3.htm (the source code for the client side program that gathers the journal voucher data)
  2. a3.asp (the posting active server page that processes transactions)

These two items may be in one asp. If so, please note this on your printout.

1.9 Print and hand in:

A copy of the je table after posting. Sort the table by sourceref ASC, srseq ASC. Show the number of journal entries AND the number of journal vouchers.

Put your name, Student Number, Database Acct # on each page.

2. (50 points)TO BE RETURNED BY 5:30 PM MON DEC 5 TO 280E MH

Using your electronic web store program:

  1. Run your equivalent of glrestore program on your store's inventory master to restore it to its original state.
  2. Print a copy of the output of the program that shows the detailed contents of the inventory-master immediately after restoration.
    Include in the report a grand total of the inventory on hand.
  3. Make 6 purchases of a different product, size, color in your catalog. Buy 2 units each time.
  4. Print another copy of the inventory master detail report after the seven orders have been processed.
    Include in the report a grand total of the inventory on hand.
  5. Print a copy of the asp program that posts the order to the inventory master.
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

Put your name, Student Number, Database Acct # on each page.

IN SUMMARY: Turn in by 5:30 PM MON DEC 5 to 280E MH:
  1. All exam pages with Name, Student Number, gl account, and email and outcomes of the posting entries.
  2. output of a44.asp trial balance after posting
  3. dump of the je table after posting
  4. a3.htm (the html/vbscript code to gather the journal voucher data)
  5. a3.asp (asp code to post journal vouchers to the glmaster)

    Note (4) and (5) may be one program

  6. output of the contents of the inventory master table contents before posting
  7. output of the contents of the inventory master table after posting
  8. copy of the asp program that posts orders to the inventory master
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

This applies to BOTH parts of the exam

Bind the pages so that they DO NOT fall apart.

email me at parks@uh.edu if you have issues.