Name_______________________________________
SS#____________________________Database Name _______
e-mail address__________________________________________
2. (20 points) TO BE RETURNED BY 5PM THU DEC 5 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 |
1900 | 2000 | 0000 | 0000 | |
1900 | 6000 | 0000 | 0000 | |
2000 | 1000 | 0000 | 0000 |
2.3 Add the following accounts to the general ledger:
Major | Minor | Sub 1 | Sub 2 | Description | Outcome |
9000 | 9000 | 1000 | 0000 | ISP Service Charges | |
9000 | 9000 | 0000 | 0000 | Oklahoma Gas Expense | |
4000 | 3000 | 3000 | 0000 | Misc. Internet Revenues | |
4000 | 3000 | 4000 | 0000 | Advertising Revenue | |
4000 | 3000 | 5000 | 0000 | Referral Revenue | |
4000 | 3000 | 6000 | 0000 | ISP Rebates | |
9000 | 9000 | 9000 | 0000 | Network Consultant Expense |
2.4 Modify the following account descriptions:
Major | Minor | Sub 1 | Sub 2 | New Description | Outcome |
9000 | 4000 | 0000 | 0000 | Insurance Expense | |
1000 | 1000 | 0000 | 0000 | Cash Operating Sunshine Bank 012-345-678-9 | |
1000 | 6000 | 0000 | 0000 | Cash Tulsa Oklahoma Payroll Account |
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. 3. (20 points)TO BE RETURNED BY 5PM THU DEC 5 TO 280E MH
Using your electronic web store program:
Put your name, SSN, Database Acct # on each page.
Note (3) and (4) may be one program
SRN:
6611
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
9000
1000
0000
16747.01
1000
1000
0000
0000
-16747.01
ISP Charges
SRN:
6612
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1900
6000
0000
0000
6178.00
Prepaid Computer Lease
1000
1000
0000
0000
-6178.00
SRN:
6613
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
9000
9000
0000
327.11
Consultant Expense
1000
2000
0000
0000
-327.11
SRN:
6614
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
3000
0000
0000
-975.00
suspense elimination
9999
9999
0000
0000
975.00
SRN:
6615
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
4000
0000
0000
704.32
record some sales
4000
3000
4000
0000
-500.08
4000
3000
2000
0000
-100.08
4000
3000
3000
0000
-104.16
SRN:
6615
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
2000
0000
0000
-1020.00
Office Lease Expense
9000
1000
0000
0000
1020.00
SRN:
6617
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
4000
0000
0000
-700.00
pay taxes
2400
1000
0000
0000
499.50
2400
5000
0000
0000
201.50
SRN:
6618
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1100
0003
0000
0000
200000.00
CD 3456-9866-1 12-0202002
1000
1000
0000
0000
-200000.00
Buy a CD
SRN:
6619
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9999
9999
0000
0000
-44444444.44
suspense again
1000
1000
0000
0000
44444444.44
In summary, turn in by 5PM WED to 280EMH: