Name_______________________________________
SS#____________________________Database Name _______
e-mail address__________________________________________
1. (50 points) TO BE RETURNED BY 5PM MON MAY 8 TO 280E MH
2.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.
2.2 Delete the following accounts from the general ledger:
Major | Minor | Sub 1 | Sub 2 | Outcome |
1700 | 3000 | 0000 | 0000 | |
2500 | 1000 | 0000 | 0000 | |
1900 | 3000 | 0000 | 0000 |
2.3 Add the following accounts to the general ledger:
Major | Minor | Sub 1 | Sub 2 | Description | Outcome |
9600 | 1000 | 0000 | 0000 | Football Ticket Expense -- HR Dept | |
9700 | 1000 | 0000 | 0000 | Extra Socks for the Winter Expense | |
2600 | 3000 | 0000 | 0000 | Batavian Army Veteran Withholding | |
4000 | 3000 | 4000 | 0000 | AJAX Software Revenue | /TR> |
4000 | 3000 | 5000 | 0000 | Garage Sale Revenue | |
1000 | 5000 | 0000 | 0000 | Cash -- Baltimore Stage Road Bank |
2.4 Modify the following account descriptions:
Major | Minor | Sub 1 | Sub 2 | New Description | Outcome |
9000 | 4000 | 0000 | 0000 | Bar Fly Innoculation Expense | |
1000 | 5000 | 0000 | 0000 | Cash -- Baltimore Stage Road Bank Hagerstown | |
1700 | 2000 | 0000 | 0000 | Stuffed Haorse Named Trigger Horse | |
1900 | 3000 | 0000 | 0000 | Prepaid Beer Tab Expense | |
1100 | 2000 | 0000 | 0000 | Investments in Batavia | |
1000 | 6000 | 0000 | 0000 | Cash First Somerset Bank Maryland |
2.5 Using your transaction system post the following journal vouchers to your general ledger system:
2.6 Print a copy of your a44.asp trial balance output after you have competed
posting the transactions above.
BE SURE TO ORDER THE REPORT IN ASCENDING ACCOUNT NUMBER ORDER.
2.7 Print:
These two items may be in one asp. If so, please note this on your printout.
Put your name, SSN, Database Acct # on each page. 2. (50 points)TO BE RETURNED BY 5PM MON MAY 8 TO 280E MH
Using your electronic web store program:
Include in the report a grand total of the inventory on hand.
Put your name, SSN, Database Acct # on each page.
Note (3) and (4) may be one program
SRN:
3611
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9600
1000
0000
0000
6747.02
1000
5000
0000
0000
-6747.02
College Hiring Recruiting Charges
SRN:
3612
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1900
6000
0000
0000
21178.99
Prepaid Lease
1000
1000
0000
0000
-21178.99
SRN:
3613
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
9000
9000
0000
12034.56
Consultant Expense
1000
2000
0000
0000
-12034.56
SRN:
3614
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
7000
0000
0000
-975.00
Clear Suspense Account
9999
9999
0000
0000
975.00
SRN:
3615
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
4000
0000
0000
4904.32
Sales
4000
3000
4000
0000
-4700.08
4000
3000
2000
0000
-100.08
4000
3000
3000
0000
-104.16
SRN:
3616
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
8000
0000
0000
-1720.00
Dewey Cheatam Water and Power
1000
1000
0000
0000
1720.00
SRN:
3616
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9200
1000
0000
0000
1881.55
Cellphone Charges
1000
5000
0000
0000
-1881.55
SRN:
3617
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
4000
0000
0000
-1800.99
Taxes
2400
1000
0000
0000
900.01
2400
6000
0000
0000
900.98
SRN:
3618
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1100
0003
0000
0000
33000.01
Invest in Apple
1000
1000
0000
0000
-33000.01
SRN:
3619
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9999
9999
0000
0000
-8.88
suspense fix
1000
3000
0000
0000
8.88
In summary, turn in by 5PM MON MAY 8 to 280E MH: