DISC 4372 FINAL FALL 2000 Part 2

Name_______________________________________

SS#____________________________Database Name _______

e-mail address__________________________________________

2. (20 points) TO BE RETURNED BY 5PM TUESDAY NOV 29 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:

MajorMinorSub 1Sub 2Outcome
4000300030000000 
1000400000000000 
3000500000000000 
4000200000000000 

2.3 Add the following accounts to the general ledger:

MajorMinorSub 1Sub 2DescriptionOutcome
9200000000000000Texas Taxes Paid 
9300000000000000Federal Taxes Paid 
4000300030000000Catalog Revenues Fall 
4000300040000000Catalog Revenues Winter 
4000300050000000Catalog Revenues Spring 
4000300060000000Catalog Revenues Summer 
1000400000000000Cash AZ Office Pheonix B and T 2334-98676 

2.4 Modify the following account descriptions:

MajorMinorSub 1Sub 2New DescriptionOutcome
9000400000000000Insurance Expense 
1000100000000000Cash Operating Houston B and T AN 999-9999 
1000600000000000Cash Florida  

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

SRN: 4111Fiscal
Month		 8
MajorMinorSub 1Sub 2AmountDescriptionOutcome
1000100000000000-1723.22Texas Sales Tax 
92000000000000001723.22  
SRN: 4112Fiscal
Month		 8
MajorMinorSub 1Sub 2AmountDescriptionOutcome
1000100000000000-5432.20Federal Taxes 
93000000000000005432.20  
SRN: 4113Fiscal
Month		 8
MajorMinorSub 1Sub 2AmountDescriptionOutcome
1000100000000000-7.11  
91001000000000007.01  
SRN: 4114Fiscal
Month		 8
MajorMinorSub 1Sub 2AmountDescriptionOutcome
1000100000000000-975.00to fix suspense 
9999999900000000975.00  
SRN: 4115Fiscal
Month		 9
MajorMinorSub 1Sub 2AmountDescriptionOutcome
1000100000000000100.20record some sales 
100020000000000020.10  
100030000000000020.10  
4000300030000000-140.40  
SRN: 4119Fiscal
Month		 9
MajorMinorSub 1Sub 2AmountDescriptionOutcome
1000100000000000-100.00 
1000200000000000-20.00  
1000800000000000-20.00  
9999999800000000140.00  
SRN: 4116Fiscal
Month		 9
MajorMinorSub 1Sub 2AmountDescriptionOutcome
1000100000000000-100.04fix sales report 
500010001000000025.01  
600010001000000025.01  
700010001000000025.01  
800010001000000025.01  
SRN: 4117Fiscal
Month		 9
MajorMinorSub 1Sub 2AmountDescriptionOutcome
1000100000000000-37.20  
900050000000000037.20  
SRN: 4118Fiscal
Month		 9
MajorMinorSub 1Sub 2AmountDescriptionOutcome
9999999900000000-666.66fix suspense again 
4000100000000000666.66  

2.6 Print a copy of your a44.asp trial balance output after you have competed posting the transactions above.

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 TUESDAY NOV 29 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.
  3. Make a single quantity purchase of the first product in your catalog.
  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 TUES 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