PARKS DISC 4372 FINAL FALL 2005

Name_______________________________________

SS#____________________________Database Name _______

e-mail address__________________________________________

TO BE RETURNED BY 5PM MON DEC 5 TO 280E MH

1. (50 points)

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 result 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 RESULT              
1800 2000 0000 0000  
1900 4000 0000 0000  
9000 9000 0000 0000  

1.3 Add the following accounts to the general ledger:

Major Minor Sub 1 Sub 2 Description RESULT              
9000 9000 0000 0000 New Gas Compnay  
9000 3000 0000 0000 Texas Gas Expense  
4000 3000 3000 0000 Misc. Revenues  
4000 3000 5000 0000 Internet Advertising Revenue  
4000 3000 6000 0000 Cookie Revenue  
9000 9000 0000 0000 New Gas Company  

1.4 Modify the following account descriptions:

Major Minor Sub 1 Sub 2 New Description RESULT              
9000 8000 0000 0000 Waste Management Services Expense  
1000 1000 0000 0000 Cash Operating -- Splendora Texas Bank 123-123-123-1  
1000 6000 0000 0000 Cash Boston Proper Payroll Account  

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

SRN:  4201 Fiscal
Month		  11
Major Minor Sub 1 Sub 2 Amount Description RESULT              
9000 9000 0000 0000 2743.01  
1000 1000 0000 0000 -2743.01 Misc. Charges  
SRN:  4202 Fiscal
Month		  11
Major Minor Sub 1 Sub 2 Amount Description RESULT              
1900 6000 0000 0000 11174.00 Prepaid Computer Lease  
1000 1000 0000 0000 -11174.00    
SRN:  4203 Fiscal
Month		  11
Major Minor Sub 1 Sub 2 Amount Description RESULT              
9000 9000 0000 0000 5327.11 Gas Expense  
1000 2000 0000 0000 -5327.11    
SRN:  4204 Fiscal
Month		  11
Major Minor Sub 1 Sub 2 Amount Description RESULT              
1000 3000 0000 0000 -975.00 suspense correction  
9999 9999 0000 0000 975.00    
SRN:  4205 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description RESULT              
1000 4000 0000 0000 600.36 Sept sales  
4000 3000 5000 0000 -200.07    
4000 3000 6000 0000 -200.07    
4000 3000 3000 0000 -200.22    
SRN:  4205 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description RESULT              
1000 2000 0000 0000 -10090.00 Lighting Repair  
9000 7000 0000 0000 10090.00    
SRN:  4206 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description RESULT              
1000 4000 0000 0000 -7600.00 prepay rent  
1900 1000 0000 0000 7600.50    
SRN:  4208 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description RESULT              
1700 1000 0000 0000 11000.00  
1000 1000 0000 0000 -11100.00 Buy office furniture  
SRN:  4209 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description RESULT              
9999 9999 0000 0000 325.47 suspense correction  
1000 1000 0000 0000 -325.47    
SRN:  4209 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description RESULT              
1000 1000 0000 0000 -21100.00 Move Cash  
1000 3000 0000 0000 21100.00    

1.6 Print a copy of your a44.asp(x) trial balance output after you have competed posting the transactions above.

BE SURE TO ORDER THE REPORT IN ASCENDING ACCOUNT NUMBER ORDER AND PROVIDE A GRAND TOTAL OF ALL ACCOUNT BALANCES.

1.7 Print:

  1. a3.htm (the source code for the client side program that gathers the journal voucher data)
  2. a3.asp(x) (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.

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

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

In summary, turn in by 5PM MON DEC 5 to 280E MH:
  1. Exam page with name, ssn, glaccount, and email and outcomes of the posting entries.
  2. output of a44.asp(x) trial balance after posting
  3. a3.html (the html/vbscript code to gather the journal voucher data)
  4. a3.asp(x) (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(x) program that posts orders to the inventory master