MIS 4372 -- PARKS -- FINAL EXAM -- SPRING 2013

Name_________________________________________________________

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

e-mail address___________________________________________________

EXAM TO BE RETURNED BY 5:30 PM FRI MAY 3 TO 280E MH

  1. Write a new program that dumps the "je" table details (all columns) and counts the number of journal entries in the "je" table (name this program a47.asp). Sort the report in "sourceref ASC, srseq ASC" order. It will be used at the bottom of each of the three columns (See step 6, 3rd and 4th table row).
Steps 2 thru 6 below should be performed 3 times as follows:

  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 the first column the outcome of the transaction either "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 the second column the outcome of the transaction either "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 the third column the outcome of the transaction either "ok" or "failed" with an explanation of why -- if it failed.

  1. Delete the following accounts from the general ledger:

    Major Minor Sub 1 Sub 2 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    2400 4000 0000 0000      
    7000 1000 3000 0000      
    8000 1000 3000 0000      
    4000 3000 5000 0000      
    9000 9000 0000 0000      
    1000 5000 0000 0000      

  2. Add the following accounts to the general ledger:

    Major Minor Sub 1 Sub 2 Description Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    9000 9000 0000 0000 Automotive Expenses      
    2400 4000 0000 0000 FICA Payable      
    1100 0003 0000 0000 Groupon Stock      
    1100 0004 0000 0000 Netflicks Stock      
    9100 3000 0000 0000 Mortgage Interest Expense      
    1000 5000 0000 0000 Cash Appalachian Bank of Bledsoe Tennessee      
    4000 3000 4000 0000 Capt. Webb Baseball Cap Sales      
    4000 3000 5000 0000 Capt Web Boots of Spanish Leather Sales      
    5000 1000 4000 0000 Direct Labor - Mobile Apps Consultants      
    1000 4000 0000 0000 Cash -- Appalachian Bank of Plum Neely Tennessee      
    1100 0003 0000 0000 Bershire Hathaway Stock      
    1700 3000 0000 0000 Pre-Columbian Art Collection      

  3. 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 Appalacian Bank of Bledso Tennessee      
    4000 3000 0000 0000 Capt. Webb Consolidate Sales      
    1100 2000 0000 0000 Netflix Stock      
    9000 1000 0000 0000 Capt. Webb NYC Penthouse Lease      
    9999 9999 0000 0000 Suspense Account      
    4000 3000 5000 0000 Expert Witness Fees      
    1900 7000 0000 0000 Prepaid Air Taxi Contract      
    9000 4000 0000 0000 Executive Life Insurance Expenses      
    8000 1000 3000 0000 Direct Labor Part-Time Workers      

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

    SRN:  7111 Fiscal
    Month    		  11 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    7000 1000 3000 0000 4446.77 Supervisory Catalog Direct Labor for April      
    1000 5000 0000 0000 -4446.77      
    SRN:  7112 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 Parttime Catalog Labor Dec 2012      
    1000 3000 0000 0000 -34,550.21        
    SRN:  7113 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 Groupon Stock      
    1100 0003 0000 0000 13341.00        
    SRN:  7114 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.11 Partial Clear Suspense Account      
    9999 9999 0000 0000 975.11        
    SRN:  7115 Fiscal
    Month    		  11 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 84391.45 Sales for Dec 2012      
    4000 3000 1000 0000 -84000.00        
    4000 3000 2000 0000 -300.00        
    4000 3000 3000 0000 -90.00        
    4000 3000 4000 0000 -1.45        
    SRN:  7116 Fiscal
    Month    		  11 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    9000 9000 0000 0000 628.32 ExxonMobil Credit Card for Gasoline      
    1000 4000 0000 0000 -628.32        
    SRN:  7161 Fiscal
    Month    		  11 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 2000 0000 0000 -3441.44 FICA paid      
    2400 4000 0000 0000 3441.44        
    SRN:  7117 Fiscal
    Month    		  11 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 5000 0000 0000 -126.13 Pay Internet Store Maintenance      
    6000 1000 1000 0000 -126.13        
    SRN:  7118 Fiscal
    Month    		  11 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1100 0004 0000 0000 89984.33 Buy Apple Stock      
    1000 2000 0000 0000 -89984.33      
    SRN:  7119 Fiscal
    Month    		  11 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1700 2000 0000 0000 1788.88 Buy Copier Stapler Addon Device      
    1000 3000 0000 0000 -1744.44        
    1000 2000 0000 0000 -44.44        
    SRN:  7120 Fiscal
    Month    		  11 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -23552.11 Move Cash to Bledso      
    1000 5000 0000 0000 23552.11        
    SRN:  7121 Fiscal
    Month    		  11 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    9000 2000 0000 0000 2102.55 Buy new Luggage      
    1000 1000 0000 0000 -2102.55        
    SRN:  7122 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 Sea Captain 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:  7161 Fiscal
    Month    		  11 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 5000 0000 0000 -28.11 But New Sharpie Pens      
    9000 5000 0000 0000 28.11        
    SRN:  7123 Fiscal
    Month    		  11 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 5000 0000 0000 -34.55 Motorcycle Fuel      
    9900 9000 0000 0000 34.55        
    SRN:  7128 Fiscal
    Month    		  11 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 5000 0000 0000 -618.91 Motorcycle Brakes      
    9000 9000 0000 0000 618.91        
    SRN:  7129 Fiscal
    Month    		  11 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 -6000.00 Catalog Supervisors Christmas Bonuses      
    8000 1000 2000 0000 6000.00        
    SRN:  7130 Fiscal
    Month    		  11 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    1000 1000 0000 0000 900.00 Deposit Grandmother Check for Stock      
    3000 4000 0000 0000 -900.00        
    SRN:  7138 Fiscal
    Month    		  11 Outcome
    using SRCGL    		 Outcome
    using SRCGLV    		 Outcome
    using SRCGLC
    Major Minor Sub 1 Sub 2 Amount Description
    7000 1000 1000 0000 1850.00 XMAS Bonus for Internet Store Programmers      
    1000 1000 0000 0000 -1880.00        

  5. After all the add, modify, deletes and journal vouchers have been processed in a column, show:

    final gl account count in "glmaster"
    (using SRCGL as the initial glmaster)    		 final gl account count in "glmaster"
    (using SRCGLV as the initial glmaster)    		 final gl account count in "glmaster"
    (using SRCGLC as the initial glmaster)
     
    Count=__________________    		  
    Count=__________________    		  
    Count=__________________
    final journal entry count in "je"
    (using SRCGL as the initial glmaster)    		 final journal entry count in "je"
    (using SRCGLV as the initial glmaster)    		 final journal entry count in "je"
    (using SRCGLC as the initial glmaster)
     
    Count=__________________    		  
    Count=__________________    		  
    Count=__________________
    final total balance from a44.asp final total balance from a44v.aspx final total balance from a44c.aspx
     
    $___________________    		 
    $______________________    		 
    $_____________________
    Which Cash accounts are overdrawn?
     

     

    		  

     

    		  

     

  6. Print and hand in a copy of EACH your trial balance outputs after you have completed the column tasks (a44.asp, a44v.aspx, a44c.aspx).

    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 (I will not grade dead links)

  7. Print and hand in the a47.asp output created at the end of each column of tasks

    BE SURE TO: ORDER THE REPORT IN ASCENDING sourceref and ASCENDING srseq ORDER.
    BE SURE TO: SHOW THE NUMBER OF JOURNAL ENTRIES IN THE je TABLE.
    BE SURE TO: SHOW THE REPORT TIME AND DATE.

  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 )

SO, you will turn in 10 documents (in the following order, staple together the individual documents -- i.e, ten staples):

  1. this entire examination page (fill in the blanks at the top of the page AND all OUTCOMEs for parts 2 through 6)
  2. a44.asp output report (Full Trial Balance)
  3. a44v.aspx output report (Full Trial Balance)
  4. a44c.aspx output report (Full Trial Balance)
  5. a47.asp output je report (using the final results from using SRCGL to create glmaster)
  6. a47.asp output je report (using the final results from using SRCGLV to create glmaster)
  7. a47.asp output je report (using the final results from using SRCGLC to create glmaster)
  8. a3.asp (source code)
  9. a3v.aspx (source code)
  10. a3c.aspx (source code)

Put your name, Student Number, Database Acct # on the top page of each of the 10 documents.

IN SUMMARY: Turn in by 5:30 PM FRI MAY 3 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 (a47.asp)
  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 (include you database name and pwd).