Name_______________________________________
SS#____________________________Database Name _______
e-mail address__________________________________________
1. (50 points) TO BE RETURNED BY 5PM MON DEC 3 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 | 3000 | 0000 | 0000 | |
1300 | 3000 | 0000 | 0000 | |
4000 | 3000 | 3000 | 0000 |
2.3 Add the following accounts to the general ledger:
Major | Minor | Sub 1 | Sub 2 | Description | Outcome |
4000 | 3000 | 3000 | 0000 | New account | |
7100 | 1000 | 1000 | 0000 | Direct Labor Supervisory | |
9100 | 2000 | 0000 | 0000 | Other Interest | |
4000 | 3000 | 4000 | 0000 | Software Revenue | /TR> |
4000 | 3000 | 5000 | 0000 | Server Sale Sale Revenue | |
1000 | 5000 | 0000 | 0000 | Cash -- Payroll Account -- Denver Bank |
2.4 Modify the following account descriptions:
Major | Minor | Sub 1 | Sub 2 | New Description | Outcome |
9000 | 4000 | 0000 | 0000 | Insurance Expense | |
1000 | 5000 | 0000 | 0000 | Cash -- Payroll Account -- Denver Bank | |
1700 | 2000 | 0000 | 0000 | Server Racks | |
5100 | 1000 | 2000 | 0000 | Direct Labor -- Galleria Store Operations | |
3000 | 7000 | 0000 | 0000 | Investments in Mozambique | |
1000 | 6000 | 0000 | 0000 | Cash East Fort Collins Trust |
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 DEC 3 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:
3211
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9600
1000
0000
0000
2248.32
1000
5000
0000
0000
-2248.32
Robert Half Recruiting Charges
SRN:
3212
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9100
2000
0000
0000
278.91
Interest
1000
5000
0000
0000
-278.91
SRN:
3213
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
4000
3000
5000
0000
1234.57
Backup battery rental
1000
2000
0000
0000
-1234.57
SRN:
3214
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
3000
6000
0000
0000
-975.07
Clear Suspense
9999
9999
0000
0000
975.07
SRN:
3215
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
904.52
Revenues
4000
3000
4000
0000
-700.08
4000
3000
2000
0000
-100.18
4000
3000
3000
0000
-104.26
SRN:
3216
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9000
7000
0000
0000
-456.53
Fort Collins Power
1000
1000
0000
0000
456.53
SRN:
3216
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9100
2000
0000
0000
37.38
Telephony Charges
1000
5000
0000
0000
-37.38
SRN:
3217
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
4000
0000
0000
-9200.98
Colorado Taxes
2400
1000
0000
0000
4600.01
2400
6000
0000
0000
4600.98
SRN:
3218
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1100
0003
0000
0000
2000.01
Investment in Apple
1000
1000
0000
0000
-2000.01
SRN:
3219
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9999
9999
0000
0000
-0.07
suspense fix
1000
3000
0000
0000
0.07
In summary, turn in by 5PM MON DEC 3 to 280E MH: