MIS 4372 FINAL FALL 2012

Name_________________________________________________________

Last 4 Digits of your PSID_________________disc-nt Server Acct__________________ (glxxxx)

e-mail address___________________________________________________

EXAM TO BE RETURNED BY 5:30 PM MON DEC 10 TO 280E MH

  1. Steps 2 thru 6 below should be performed 3 times
    1. First, 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 (steps 2 thru 6), write in first column of the outcome of the transaction (i.e., "ok" or "failed") with an explanation of why -- if it failed.
    2. Second, modify your glrestor program by changing:
         this line: rsold.open oldsql,"DSN=SRCGL;UID=;PWD=;"
         to this: rsold.open oldsql,"DSN=SRCGLV;UID=;PWD=;"
      Run glrestor.asp again. On all the add/modify/delete's and journal vouchers below (steps 2 thru 6), write in second column of the outcome of the transaction (i.e., "ok" or "failed") with an explanation of why -- if it failed.
    3. Third, modify your glrestor program by changing:
         this line: rsold.open oldsql,"DSN=SRCGLV;UID=;PWD=;"
         to this: rsold.open oldsql,"DSN=SRCGLC;UID=;PWD=;"
      Run glrestor.asp again. On all the add/modify/delete's and journal vouchers below (steps 2 thru 6), write in third column of the outcome of the transaction (i.e., "ok" or "failed") with an explanation of why -- if it failed.
  2. Delete the following accounts from the general ledger:
    Major Minor Sub 1 Sub 2 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    2500 1000 0000 0000      
    1800 3000 0000 0000      
    9000 1000 0000 0000      
    4000 3000 4000 0000      
    9999 9999 0000 0000      
  3. Add the following accounts to the general ledger:
    Major Minor Sub 1 Sub 2 Description Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    2400 1000 0000 0000 Federal Income Tax Due      
    1100 0003 0000 0000 IBM Stock      
    9100 2000 0000 0000 Toner Expense      
    1000 5000 0000 0000 Cash Aspen Ski and Security Bank      
    4000 3000 4000 0000 Capt. Webb T-shirt Sales      
    4000 3000 5000 0000 Capt Web Mobile Apps Store Sales      
    5000 1000 4000 0000 Direct Labor - Mobile Apps Store      
    1000 4000 0000 0000 Cash -- Teluride Bank Houston Office      
    1100 0003 0000 0000 CD 4532-7122-6 12-5-2012      
    1700 3000 0000 0000 Capt. Web Art Collection      
    4000 3000 5000 0000 Capt. Web Door-to-Door Sales      
  4. Modify the following account descriptions:
    Major Minor Sub 1 Sub 2 New Description Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    3000 6000 0000 0000 Retained Earnings      
    1000 4000 0000 0000 Cash Petty Houston B & T Alvin Branch      
    4000 3000 0000 0000 Capt. Webb Duty Free Airport Sales      
    9000 1000 0000 0000 Capt. Webb Aspen Chalet Lease      
    9999 9999 0000 0000 Suspense Account      
    4000 2000 0000 0000 Litigation Proceeds      
    1900 4000 0000 0000 Prepaid Limo Rental      
    9000 4000 0000 0000 Executive Life Insurance Expenses      
    4000 3000 5000 0000 Capt. Webb Door-to-door Sales      
  5. Using your transaction system post the following journal vouchers to your general ledger system:

    SRN:  3411 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    7000 1000 3000 0000 9346.77 Supervisory Catalog Direct Labor for December      
    1000 5000 0000 0000 -9346.77      
    SRN:  3412 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    8000 1000 3000 0000 34,550.21 Part-Time Catalog Labor Dec 2012      
    1000 3000 0000 0000 -34,550.21        
    SRN:  3413 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -187345.00 Buy IBM Stock      
    1100 0003 0000 0000 187345.00        
    SRN:  3414 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    3000 6000 0000 0000 -975.99 Clear Suspense Account      
    9999 9999 0000 0000 975.99        
    SRN:  3415 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 54390.45 Sales for Dec 2012      
    4000 3000 1000 0000 -54000.00        
    4000 3000 2000 0000 -300.00        
    4000 3000 3000 0000 -90.00        
    4000 3000 4000 0000 -0.45        
    SRN:  3416 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    9000 9000 0000 0000 14328.32 Exxon Credit Card for Gasoline      
    1000 4000 0000 0000 -14328.32        
    SRN:  3461 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 2000 0000 0000 -34581.44 FICA paid      
    2400 4000 0000 0000 34581.44        
    SRN:  3417 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 5000 0000 0000 -556.13 Pay Internet Maintenance      
    6000 1000 1000 0000 -566.13        
    SRN:  3418 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1100 0004 0000 0000 240984.33 Buy Apple Stock      
    1000 2000 0000 0000 -240984.33      
    SRN:  3419 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1700 3000 0000 0000 88.88 Buy Foot Massage Device      
    1000 3000 0000 0000 -44.44        
    1000 2000 0000 0000 -44.44        
    SRN:  3420 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -303552.19 Move Cash to Aspen      
    1000 5000 0000 0000 303552.19        
    SRN:  3421 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    9000 2000 0000 0000 8602.55 Buy new Bilge Pump      
    1000 1000 0000 0000 -8602.55        
    SRN:  3422 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -600.00 Seafarers Union Dues      
    1000 2000 0000 0000 -30.00      
    1000 3000 0000 0000 -8.00      
    1000 4000 0000 0000 -0.20      
    1000 5000 0000 0000 -0.01      
    9000 3000 0000 0000 638.21        
    SRN:  3461 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 6000 0000 0000 -8.11 But New Name Tags      
    9000 5000 0000 0000 8.11        
    SRN:  3423 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 5000 0000 0000 -88.34 Motorcycle Fuel      
    9000 9900 0000 0000 88.34        

  6. Fill in the answers to the following questions (after completing sections 2, 3, 4, and 5 above):

    Using SRCGLUsing SRCGLVUsing SRCGLC
    The glmaster balance is$______________$______________$______________
    The number of accounts in the glmaster table_____________________________________________
    The number of rows in the je table is:
    (see 9 below)
    _____________________________________________
    Are any Cash accounts overdrawn?
    If so, which ones:
    _____________________________________________

  7. Print a copy of EACH your trial balance outputs (a44.asp, a44v.aspx, a44c.aspx) 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

  8. Print and hand in the source code for the server side programs that post the journal voucher data -- i.e., a3.asp, a3v.aspx, a3c.aspx )

  9. Print and hand in a copy of the EACH of the three je tables after posting. (THIS IS A NEW ASSIGNMENT)
    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.


IN SUMMARY: Turn in by 5:30 PM MON DEC 10 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, a44v.aspx, a44c.aspx trial balance after posting
  3. Dump of each of the three je tables after posting
  4. a3.asp, a3v.aspx, a3c.aspx (code to post journal vouchers to the glmaster)

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

Bind the pages so that they DO NOT fall apart.

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