e-mail address__________________________________________
1. (50 points) TO BE RETURNED BY 5PM MON DEC 8 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 | 2000 | 0000 | 0000 | |
2600 | 3000 | 0000 | 0000 | |
4000 | 4000 | 5000 | 0000 | |
9100 | 1000 | 0000 | 0000 | |
1000 | 4000 | 0000 | 0000 |
1.3 Add the following accounts to the general ledger:
Major | Minor | Sub 1 | Sub 2 | Description | Outcome |
1000 | 5000 | 0000 | 0000 | Cash Dickenson Texas -- The South Texas Bank | |
4000 | 3000 | 4000 | 0000 | East Asia Revenue | |
1000 | 5000 | 0000 | 0000 | Cash Salt Lake City Office -- Unity Bank | |
9000 | 4000 | 0000 | 0000 | Insurance Expense | /TR> |
4000 | 3000 | 5000 | 0000 | European Operations Revenue | |
1000 | 6000 | 0000 | 0000 | Cash -- Payroll Account -- The South Texas Bank | |
1100 | 0003 | 0000 | 0000 | AIG Stock | |
3000 | 4000 | 0000 | 0000 | Capital Cash Contributions | |
9000 | 3000 | 1000 | 0000 | Gold's Gym Membership |
1.4 Modify the following account descriptions:
Major | Minor | Sub 1 | Sub 2 | New Description | Outcome |
3000 | 4000 | 0000 | 0000 | Paid In Capital | |
1000 | 5000 | 0000 | 0000 | Cash Salt Lake City Office -- Correction Bank | |
1700 | 1000 | 0000 | 0000 | Office Equipment | |
9100 | 1000 | 0000 | 0000 | Office Rent | |
9999 | 9999 | 0000 | 0000 | Suspense Account | |
4000 | 2000 | 0000 | 0000 | Capt. Webb Brand Name Royalties | |
2700 | 0000 | 0000 | 0000 | Extraordinary Expenses |
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.
Put your name, Student Number, Database Acct # on each page. 2. (50 points)TO BE RETURNED BY 5PM MON DEC 8 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:
2111
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
6000
0000
0000
1348.31
1000
5000
0000
0000
-1348.31
West Coast Communications Expenses
SRN:
2112
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
4000
0000
0000
238.91
Auto Insurance 2008
1000
5000
0000
0000
-238.91
SRN:
2113
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
5000
1000
1000
0000
2234.57
Part Time Sales Staff
1000
2000
0000
0000
-2234.57
SRN:
2114
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
3000
6000
0000
0000
-975.06
Clear Suspense Account
9999
9999
0000
0000
975.06
SRN:
2115
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
984.50
Sales Receipts December 2008
4000
3000
4000
0000
-900.10
4000
3000
5000
0000
-10.10
4000
3000
3000
0000
-74.40
SRN:
2116
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
7000
0000
0000
2560.28
Green Mountain Wind Power
1000
1000
0000
0000
-2560.28
SRN:
2116
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
5000
0000
0000
-3910.38
BMW Auto Lease
9000
2000
0000
0000
3910.38
SRN:
2117
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
4000
0000
0000
-3200.99
Taxes
2400
1000
0000
0000
1600.01
2400
5000
0000
0000
1600.98
SRN:
2118
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1100
0003
0000
0000
13335.04
Invest in AIG
1000
1000
0000
0000
-133365.04
SRN:
2119
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9999
9999
0000
0000
-0.01
Suspense fix AGAIN
3000
6000
0000
0000
0.01
SRN:
2120
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
2600
1000
0000
0000
600.00
Hurricane Insurance
1000
5000
0000
0000
-600.00
SRN:
2121
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
6000
0000
0000
6600.00
LOTTO Winnings
1000
5000
0000
0000
-6600.00
SRN:
2122
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
0600
0000
0000
643.00
Tsunami Insurance
900
4000
0000
0000
-643.00
SRN:
2123
Fiscal
Month 12
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
8643.28
AIG Spa Expenses
9000
6000
0000
0000
-8643.27
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 5PM MON DEC 8 to 280E MH: