Last 4 Digits of your PSID___________
disc-nt Server Account___________________ (glxxxx)
e-mail address__________________________________________
1. (50 points) TO BE RETURNED BY 5:30 PM FRI MAY 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 |
1700 | 1000 | 0000 | 0000 | |
1900 | 1000 | 0000 | 0000 | |
9000 | 4000 | 0000 | 0000 | |
9000 | 8000 | 0000 | 0000 | |
1900 | 1900 | 0000 | 0000 |
1.3 Add the following accounts to the general ledger:
Major | Minor | Sub 1 | Sub 2 | Description | Outcome |
9000 | 4000 | 0000 | 0000 | Insurance Expenses | |
1100 | 0003 | 0000 | 0000 | Bershire Hathaway Stock | |
2600 | 1000 | 0000 | 0000 | Insurance Withholding | |
1000 | 5000 | 0000 | 0000 | Cash Dahlonega Bank, Battle Mine Branch | |
8000 | 1000 | 5000 | 0000 | Direct Labor Chimney Sweeping | /TR> |
4000 | 3000 | 4000 | 0000 | Capt. Webb Concert Tour Revenues | |
9100 | 2000 | 0000 | 0000 | Capt. Webb Concert Tour Expenses | |
1000 | 3000 | 0000 | 0000 | Cash -- Talking Rock Bank | |
1100 | 0004 | 0000 | 0000 | Gold Stocks | |
1700 | 3000 | 0000 | 0000 | Web Server Facility |
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 Dahlonega Bank, Battle Branch Mine Branch | |
4000 | 1000 | 1000 | 0000 | Capt. Webb Paraphernalia Royalties | |
9300 | 1000 | 0000 | 0000 | Wall Street Journal Ad Expenses | |
9999 | 9999 | 0000 | 0000 | Suspense Account | |
4000 | 2000 | 0000 | 0000 | Capt. Webb Conference USA Revenue | |
1900 | 1000 | 0000 | 0000 | Prepaid Dues | |
9000 | 4000 | 0000 | 0000 | Insurance Expense | |
4000 | 3000 | 2000 | 0000 | Chicago 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.
Make sure your index.htm file has working links to each assignment component
1.8 Print and hand in:
These two items may be in one asp. If so, please note this on your printout.
1.9 Print and hand in:
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 FRI MAY 6 TO 280E MH
Using your electronic web store program:
Make sure your index.htm file has working links to each assignment component Put your name, Student Number, Database Acct # on each page.
Note (4) and (5) may be one program
Make sure your index.htm file has working links to each assignment component
This applies to BOTH parts of the exam Bind the pages so that they DO NOT fall apart.
email me at parks@uh.edu if you have issues.
SRN:
4111
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
1000
0000
0000
2122.33
Pay Office Rent
1000
1000
0000
0000
-2122.33
SRN:
4112
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
2600
3000
0000
0000
211.32
Pay Union Dues Matching Contributions
1000
2000
0000
0000
-211.32
SRN:
4113
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
-122787.00
Buy Bershire Hathaway Stock 10 shares
1100
0003
0000
0000
122787.00
SRN:
4114
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
3000
6000
0000
0000
-974.00
Clear Suspense
9999
9999
0000
0000
974.00
SRN:
4115
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
5000
0000
0000
6578.92
Sales for August 2010
4000
3000
4000
0000
-6000.00
4000
3000
3000
0000
-500.00
4000
3000
2000
0000
-70.00
4000
3000
1000
0000
-8.92
SRN:
4116
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
8000
0000
0000
433.81
Waste Management
1000
4000
0000
0000
-433.81
SRN:
4161
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
2000
0000
0000
-334.12
Verizon Mobile Phone Bill
9000
6000
0000
0000
334.12
SRN:
4117
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
-321.11
Pay FICA
2400
4000
0000
0000
-321.11
SRN:
4118
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1100
4000
0000
0000
861.60
Buy Delta Airline Stock
1000
1000
0000
0000
-816.60
SRN:
4119
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1700
1000
0000
0000
1456.28
Buy New Captain Chairs
1000
5000
0000
0000
-728.14
1000
2000
0000
0000
-728.14
SRN:
4120
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
-6400.00
Move Cash to GA
1000
5000
0000
0000
6400.00
SRN:
4121
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
8000
0000
0000
345.63
Pay Auto Lease
1000
5000
0000
0000
-345.63
SRN:
4122
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
-900.00
Travel Expenses
1000
2000
0000
0000
-80.00
1000
3000
0000
0000
-4.00
1000
4000
0000
0000
-0.30
1000
5000
0000
0000
-0.01
9000
2000
0000
0000
984.31
SRN:
4161
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
4.44
Travel Club Dues
9000
3000
0000
0000
-4.44
SRN:
4123
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
6000
0000
0000
-229.13
Jelly Bean Expenses
9000
9200
0000
0000
229.13
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 FRI MAY 6 to 280E MH: