DISC 4372 FINAL SPRING 2005 KEY

2. (20 points) TO BE RETURNED BY 5PM MON May 2 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 transaction (i.e, "ok" or "failed") with an explanation of why if it failed.

2.2 Delete the following accounts from the general ledger:

Major Minor Sub 1 Sub 2 Outcome
1900 3000 0000 0000 OK
1900 8000 0000 0000 Failed doesn't exits
2000 2000 0000 0000 Failed non zero balance

2.3 Add the following accounts to the general ledger:

Major Minor Sub 1 Sub 2 Description Outcome
9000 5500 0000 0000 Service Provider Charges OK 
9000 9000 0000 0000 Houston Gas Expense Failed DUP 
4000 3000 3000 0000 Internet Storefront Revenues Failed DUP 
4000 3000 4000 0000 Web Advertising Revenue OK 
4000 3000 5000 0000 Click Referral Revenue OK 
4000 3000 6000 0000 User Refunds OK 
9000 9000 9000 0000 Consultant Expense OK 

2.4 Modify the following account descriptions:

Major Minor Sub 1 Sub 2 New Description Outcome
9000 4000 0000 0000 Great Western Insurance Expense OK 
1000 1000 0000 0000 Cash Operating Regents Bank 987-7-6-4321 OK 
1000 6000 0000 0000 Cash Dallas Payroll Account FAILED Doesn't exist 

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

SRN:  6611 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
9000 5500 1000 0000 16747.01  
1000 1000 0000 0000 -16747.01 ISP Charges Failed Doesn't Exist 
SRN:  1412 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1900 6000 0000 0000 6178.00 Prepaid Computer Lease Failed Doesn't Exist 
1000 1000 0000 0000 -6178.00    
SRN:  1413 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
9000 9000 9000 0000 327.11 Consultant Expense OK 
1000 2000 0000 0000 -327.11    
SRN:  1414 Fiscal
Month		  8
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 3000 0000 0000 -975.00 suspense elimination OK 
9999 9999 0000 0000 975.00    
SRN:  1415 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 4000 0000 0000 704.32 record some sales OK 
4000 3000 4000 0000 -500.08    
4000 3000 2000 0000 -100.08    
4000 3000 3000 0000 -104.16    
SRN:  1415 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 2000 0000 0000 -1020.00 Office Lease Expense Failed DUP SRN 
9000 1000 0000 0000 1020.00    
SRN:  1417 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description Outcome
1000 4000 0000 0000 -700.00 Taxes Failed JE sum not zero 
2400 1000 0000 0000 499.50    
2400 5000 0000 0000 201.50    
SRN:  1418 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description Outcome
1100 0003 0000 0000 22000.00 Money Market Purchase Merrill Lynch Failed Account doesn't exist 
1000 1000 0000 0000 -22000.00 Buy a CD  
SRN:  1419 Fiscal
Month		  9
Major Minor Sub 1 Sub 2 Amount Description Outcome
9999 9999 0000 0000 -66.66 suspense account again OK 
1000 1000 0000 0000 66.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 MON May 2 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 second product in your catalog of 6 units (any color or size).
  4. Make a purchase of the first product listed in your catalog. Buy 6 of this item.
  5. Make a purchase of the third product in your catalog. Buy 6 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 purchases are for a quantity of two)
  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 MON May 2 to 280E MH:
  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