Student Number____________________________Database Name _______
e-mail address__________________________________________
1. (50 points) TO BE RETURNED BY 5:30 PM MON DEC 6 TO 280E MH
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 outcome 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 | Outcome |
1900 | 1000 | 0000 | 0000 | |
2600 | 1000 | 0000 | 0000 | |
9000 | 4000 | 0000 | 0000 | |
9000 | 8000 | 0000 | 0000 | |
2000 | 1000 | 0000 | 0000 |
1.3 Add the following accounts to the general ledger:
Major | Minor | Sub 1 | Sub 2 | Description | Outcome |
4000 | 1000 | 0000 | 0000 | Advertising Royalties | |
1100 | 0003 | 0000 | 0000 | Oracle Preferred Stock | |
2600 | 1000 | 0000 | 0000 | Medical Insurance Withholding | |
1000 | 5000 | 0000 | 0000 | Cash Buena Vista Bank, CL | |
8000 | 1000 | 4000 | 0000 | Direct Labor System Maintenance | /TR> |
4000 | 3000 | 4000 | 0000 | Capt. Webb Family Trust Royalty Revenue | |
1000 | 3000 | 0000 | 0000 | Cash -- Frostbite Falls Snow Bank | |
1100 | 0004 | 0000 | 0000 | Wikileak Stock | |
3000 | 4000 | 0000 | 0000 | Contributions to Capital | |
1700 | 3000 | 0000 | 0000 | Server Farm |
1.4 Modify the following account descriptions:
Major | Minor | Sub 1 | Sub 2 | New Description | Outcome |
3000 | 6000 | 0000 | 0000 | Retained Earnings | |
1000 | 5000 | 0000 | 0000 | Cash Buena Vista Bank CO | |
4000 | 1000 | 1000 | 0000 | Software Royalties | |
9300 | 1000 | 0000 | 0000 | Google Ad Expense | |
9999 | 9999 | 0000 | 0000 | Suspense Account | |
4000 | 2000 | 0000 | 0000 | Capt. Webb International Conference Revenue | |
1900 | 9000 | 0000 | 0000 | All Other Assets | |
1900 | 1000 | 0000 | 0000 | Prepaid Leases | |
9000 | 4000 | 0000 | 0000 | Insurance Expenses | |
4000 | 3000 | 2000 | 0000 | Houston Walk-in Store Revenues |
1.5 Using your transaction system post the following journal vouchers to your general ledger system:
1.6 Fill in the answers to the following questions (after completing sections 1.1, 1.2, 1.3, 1.4, and 1.5 above):
1.7 Print a copy of your a44.asp trial balance output after you have completed
posting the transactions above.
BE SURE TO: ORDER THE REPORT IN ASCENDING ACCOUNT NUMBER ORDER.
1.8 Print:
These two items may be in one asp. If so, please note this on your printout.
1.9 Print:
A copy of the je table after posting. 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. 2. (50 points)TO BE RETURNED BY 5:30 PM MON DEC 6 TO 280E MH
Using your electronic web store program:
Put your name, Student Number, Database Acct # on each page.
Note (4) and (5) may be one program
Bind the pages so that they DO NOT fall apart.
Email me at parks@uh.edu if you have issues.
SRN:
2311
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
1000
0000
0000
3427.66
Prepay Rent
1000
1000
0000
0000
-3427.66
SRN:
2312
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
2600
2000
0000
0000
4511.93
Pay Credit Union Matching Contributions
1000
2000
0000
0000
-4511.93
SRN:
2313
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
-40000.00
Buy a Oracle StockCD
1100
0003
0000
0000
40000.07
SRN:
2314
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
3000
6000
0000
0000
-975.00
Clear Suspense
9999
9999
0000
0000
975.00
SRN:
2315
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
5000
0000
0000
32180.01
Sales for August 2010
4000
3000
1000
0000
-32000.00
4000
3000
2000
0000
-180.00
4000
3000
3000
0000
-0.01
SRN:
2316
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
7000
0000
0000
9855.22
North Wind Power Company
1000
4000
0000
0000
-9855.22
SRN:
2361
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
2000
0000
0000
-814.62
ATT Mobile Phone Bill
9000
6000
0000
0000
814.62
SRN:
2317
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
-45.14
Pay Federal Taxes
2400
1000
0000
0000
-45.14
SRN:
2318
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1100
4000
0000
0000
61.60
Buy Wikileak Stock
1000
1000
0000
0000
-61.60
SRN:
2319
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1700
1000
0000
0000
456.83
Buy New Furniture
1000
1000
0000
0000
-250.41
1000
2000
0000
0000
-206.41
SRN:
2320
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
5000
0000
0000
400.00
Move Cash to CO
1000
1000
0000
0000
-400.00
SRN:
2321
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
8000
0000
0000
155.63
Pay Water Bill
1000
5000
0000
0000
-155.63
SRN:
2322
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
-100.00
Travel Expenses
1000
2000
0000
0000
-10.00
1000
3000
0000
0000
-1.00
1000
4000
0000
0000
-0.10
1000
5000
0000
0000
-0.01
9000
2000
0000
0000
111.11
SRN:
2361
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
3.33
Mickey Mouse Club Dues
9000
3000
0000
0000
-3.33
SRN:
2323
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
6000
0000
0000
-4339.31
Private Jet Fuel Expenses
9000
9000
0000
0000
4339.31
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.
Include in the report a grand total of the inventory on hand.
Include in the report a grand total of the inventory on hand.
IN SUMMARY: Turn in by 5:30 PM MON DEC 6 to 280E MH: