e-mail address__________________________________________
1. (50 points) TO BE RETURNED BY 5PM FRI MAY 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 |
1900 | 3000 | 0000 | 0000 | |
2600 | 2000 | 0000 | 0000 | |
4000 | 3000 | 4000 | 0000 | |
1900 | 9000 | 0000 | 0000 | |
1000 | 4000 | 0000 | 0000 |
1.3 Add the following accounts to the general ledger:
Major | Minor | Sub 1 | Sub 2 | Description | Outcome |
1900 | 3000 | 0000 | 0000 | Prepaid backup site lease | |
4000 | 3000 | 4000 | 0000 | International Revenue | |
1000 | 5000 | 0000 | 0000 | Cash Wild Bill Bank of Jackson Hole WY | |
9200 | 1000 | 0000 | 0000 | Consulting Expense | /TR> |
4000 | 3000 | 5000 | 0000 | Mail-in Revenue | |
1000 | 6000 | 0000 | 0000 | Cash -- Dewey Cheatem Bank | |
1100 | 0003 | 0000 | 0000 | Chrysler Stock | |
3000 | 5000 | 0000 | 0000 | Paid In Capital |
1.4 Modify the following account descriptions:
Major | Minor | Sub 1 | Sub 2 | New Description | Outcome |
3000 | 5000 | 0000 | 0000 | Paid In Capital In Excess of Par | |
1000 | 5000 | 0000 | 0000 | Cash Wild William Bank of Jackson Hole WY | |
4000 | 1000 | 0000 | 0000 | Consulting Revenue | |
9100 | 2000 | 0000 | 0000 | Office Rent | |
9999 | 9999 | 0000 | 0000 | Suspense | |
4000 | 2000 | 0000 | 0000 | Software Sales | |
1900 | 8000 | 0000 | 0000 | Good Will | |
9000 | 4000 | 0000 | 0000 | Insurance Expense |
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 FRI MAY 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:
3811
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
4000
0000
0000
4448.16
1000
6000
0000
0000
-4448.16
Dewey Cheatem Insurance Expenses
SRN:
3812
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
4000
0000
0000
.91
Executive Life Insurance 2009
1000
5000
0000
0000
-.91
SRN:
3813
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
5000
1000
1000
0000
5432.07
Store Sales Staff
1000
8000
0000
0000
-5432.07
SRN:
3814
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
3000
6000
0000
0000
-975.00
Clear Suspense
9999
9999
0000
0000
975.00
SRN:
3815
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
5000
0000
0000
684.01
Sales Receipts May 2009
4000
3000
1000
0000
-300.00
4000
3000
2000
0000
-300.00
4000
3000
3000
0000
-84.01
SRN:
3816
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
7000
0000
0000
460.29
Reliant Wind Company
1000
4000
0000
0000
-460.28
SRN:
3816
Fiscal
Month 5
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:
3817
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
4000
0000
0000
-200.99
Federal Taxes
2400
1100
0000
0000
-200.99
SRN:
3818
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1100
3000
0000
0000
878787.00
Invest in Chrysler
1000
1000
0000
0000
-878788.00
SRN:
3819
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1700
3000
0000
0000
1100.54
Buy New Desks
1000
5000
0000
0000
-1100.54
SRN:
3820
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
4000
0000
0000
1630.00
Hurricane Insurance
1000
1000
0000
0000
-1630.00
SRN:
3821
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
5000
0000
0000
4343.12
Software License Fees
4000
1000
0000
0000
-4343.13
SRN:
3822
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
5000
0000
0000
-3418.43
Paper Expense
9000
5000
0000
0000
3418.43
SRN:
3823
Fiscal
Month 5
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
-184365.28
Executive Retreat Expenses
9000
2000
0000
0000
-184365.28
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 FRI MAY 8 to 280E MH: