MIS 4372 FINAL SUMMER 2012

Name_________________________________________________________

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

e-mail address___________________________________________________

EXAM TO BE RETURNED BY 5:30 PM FRI AUG 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
    2400 1000 0000 0000      
    1800 2000 0000 0000      
    9000 9000 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 Facebook Stock      
    9100 2000 0000 0000 Health Insurance      
    1000 5000 0000 0000 Cash San Jacinto Branch Bank      
    4000 3000 4000 0000 Capt. Webb Franchises      
    4000 3000 5000 0000 Capt. Webb Transaction Systems Sales      
    5000 1000 2000 0000 Contract Programming      
    1000 4000 0000 0000 Cash -- San Jacinto Main Bank      
    1100 0002 0000 0000 Sell CD      
    1700 4000 0000 0000 Firewall Bricks      
    4000 3000 5000 0000 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 5000 0000 0000 Cash San Jac Bank      
    4000 4000 0000 0000 Capt. Webb Door-to-door Sales      
    9000 1000 0000 0000 Condo for the Captain Lease      
    9999 9999 0000 0000 SUSPENSE ACCOUNT      
    4000 2000 0000 0000 Patent Law Suits Proceeds      
    1900 1000 0000 0000 Prepaid Jet Rental      
    9000 4000 0000 0000 Insurance Expenses      
    4000 3000 5000 0000 Door-to-Door Sales      
  5. Using your transaction system post the following journal vouchers to your general ledger system:

    SRN:  7211 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    9000 1000 0000 0000 5341.24 Condo Maintenance      
    1000 4000 0000 0000 -5341.24      
    SRN:  7212 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    2600 2000 0000 0000 327.11 Matching Contributions      
    1000 3000 0000 0000 -327.11        
    SRN:  7213 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -43818.12 Buy Facebook Stock      
    1100 0001 0000 0000 43818.12        
    SRN:  7214 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.01 Clear Suspense Account      
    9999 9999 0000 0000 975.01        
    SRN:  7215 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 3812.44 Sales for March 2012      
    4000 3000 4000 0000 -3002.11        
    4000 3000 3000 0000 -800.11        
    4000 3000 2000 0000 -10.11        
    4000 3000 1000 0000 -2.11        
    SRN:  7216 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    9000 9000 0000 0000 222.42 Shell Credit Card for Gasoline      
    1000 4000 0000 0000 -222.42        
    SRN:  7261 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 2000 0000 0000 -778.13 Verizon Mobile Phone Bill      
    9000 6000 0000 0000 718.13        
    SRN:  7217 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -556.13 Pay FICA      
    2400 4000 0000 0000 -556.13        
    SRN:  7218 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1100 0004 0000 0000 606.12 Buy Apple Stock      
    1000 5000 0000 0000 -606.12      
    SRN:  7219 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1700 2000 0000 0000 468.24 Buy New Vacuum Cleaner      
    1000 6000 0000 0000 -234.12        
    1000 2000 0000 0000 -234.12        
    SRN:  7220 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -90100.00 Move Cash to San Jac      
    1000 5000 0000 0000 90100.00        
    SRN:  7221 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    9000 2000 0000 0000 776.71 Buy new Ship Anchor      
    1000 1000 0000 0000 -776.71        
    SRN:  7222 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -500.00 Yacht Club Dues      
    1000 2000 0000 0000 -80.00      
    1000 3000 0000 0000 -5.00      
    1000 4000 0000 0000 -0.80      
    1000 5000 0000 0000 -0.05      
    9000 3000 0000 0000 585.85        
    SRN:  7261 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 7000 0000 0000 371.41 Paper Clips      
    9000 5000 0000 0000 -371.41        
    SRN:  7223 Fiscal
    Month
     11 Outcome
    using SRCGL
    Outcome
    using SRCGLV
    Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 6000 0000 0000 -3229.13 Yacht Fuel      
    9000 9000 0000 0000 3229.13        

  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 FRI AUG 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.