DISC 4372 FINAL SPRING 2002 Part 2

Name_______________________________________

SS#____________________________Database Name _______

e-mail address__________________________________________

2. (20 points) TO BE RETURNED BY 5PM THU APR 25 TO 280E MH

2.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 update (i.e, "worked ok" or "failed").

2.2 Delete the following accounts from the general ledger:

Major Minor Sub 1 Sub 2 Outcome
9000 3000 0000 0000  
1900 3000 0000 0000  
1900 8000 0000 0000  

2.3 Add the following accounts to the general ledger:

Major Minor Sub 1 Sub 2 Description Outcome
9900 1111 0000 0000 Texas Franchise Taxes Paid  
9900 1111 0000 0000 Oklahoma Franchise Taxes Paid  
4000 3000 4000 1000 Internet Revenues Fall  
4000 3000 4000 2000 Internet Revenues Winter  
4000 3000 4000 3000 Internet Revenues Spring  
4000 3000 4000 4000 Internet Revenues Summer  
9000 9000 0000 0000 ISP Expenses  

2.4 Modify the following account descriptions:

Major Minor Sub 1 Sub 2 New Description Outcome
9000 4000 0000 0000 Insurance Expense  
1000 1000 0000 0000 Cash Operating Houston B and T AN 12345-6789  
1000 6000 0000 0000 Cash Tulsa Oklahoma Payroll Account  

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

SRN:  3111 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 1000 0000 0000 32047.00 Fall Internet Revenues  
4000 3000 4000 1000 -32047.00    
SRN:  3112 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 2000 0000 0000 -6178.00 Federal Taxes  
2500 1000 0000 0000 6178.00    
SRN:  3113 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 1000 0000 0000 -7.11    
9000 6600 0000 0000 7.01    
SRN:  4114 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 3000 0000 0000 -975.00 to fix suspense  
9999 9999 0000 0000 975.00    
SRN:  4115 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 4000 0000 0000 300.30 record some sales  
4000 3000 1000 0000 -100.10    
4000 3000 2000 0000 -100.10    
4000 3000 3000 0000 -100.20    
SRN:  4119 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description Outcome
4000 3000 4000 1000 -1020.00  
4000 3000 4000 2000 -1020.00    
4000 3000 4000 3000 -1020.00    
1000 4000 0000 0000 3060.00    
SRN:  4139 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 4000 0000 0000 -100.04 fix sales report  
5000 1000 1000 0000 25.01    
6000 1000 1000 0000 25.01    
7000 1000 1000 0000 25.01    
8000 1000 1000 0000 25.01    
SRN:  4117 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 4000 0000 0000 -37.20    
9500 5000 0000 0000 37.20    
SRN:  4139 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description Outcome
9999 9999 0000 0000 -666.66 fix suspense again  
4000 1000 0000 0000 666.66    

2.6 Print a copy of your a44.asp trial balance output after you have competed posting the transactions above. BE SURE TO ORDER THE REPORT IN ASCENDING ACCOUNT NUMBER ORDER.

2.7 Print:

  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.

Put your name, SSN, Database Acct # on each page.

3. (20 points)TO BE RETURNED BY 5PM THU APR 25 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 a purchase of the first product in your catalog of 3 units (any color or size).
  4. Make a purchase of the second product listed in your catalog. Buy 7 of this item.
  5. Make a purchase of the third product in your catalog. Buy 3 different versions of this third item on the same order (i.e., same product but three different variations of either size or color -- all three are quantity one)
  6. Print another copy of the inventory master detail report after the three orders have been processed.
  7. Print a copy of the asp program that posts the order to the inventory master.

Put your name, SSN, Database Acct # on each page.

In summary, turn in by 5PM THU to 280EMH:
  1. Exam page with name, ssn, glaccount, and email and outcomes of the posting entries.
  2. output of a44.asp trial balance after posting
  3. a3.html (the html/vbscript code to gather the journal voucher data)
  4. a3.asp (asp code to post journal vouchers to the glmaster)

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

  5. output of the contents of the inventory master table contents before posting
  6. output of the contents of the inventory master table after posting
  7. copy of the asp program that posts orders to the inventory master