Name_______________________________________
SS#____________________________Database Name _______
e-mail address__________________________________________
1. (50 points) TO BE RETURNED BY 5PM WED NOV 29 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 -- West Coast 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 -- Third Coast Bank | |
1700 | 2000 | 0000 | 0000 | Server Farm | |
5100 | 1000 | 2000 | 0000 | Direct Labor -- Walk-in Store Operations | |
3000 | 7000 | 0000 | 0000 | Investments in Moldovia | |
1000 | 6000 | 0000 | 0000 | Cash New Market Bank and 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 WED NOV 29 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
8748.32
1000
5000
0000
0000
-8748.32
UH Hiring Recruiting Charges
SRN:
3212
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9100
2000
0000
0000
23378.91
Interest
1000
5000
0000
0000
-23378.91
SRN:
3213
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
4000
3000
5000
0000
2734.57
server rental
1000
2000
0000
0000
-2734.57
SRN:
3214
Fiscal
Month 8
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
3000
6000
0000
0000
-975.01
Clear Suspense Account
9999
9999
0000
0000
975.01
SRN:
3215
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
1000
0000
0000
904.52
Sales
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
-220.23
Great Falls Water and Power
1000
1000
0000
0000
220.23
SRN:
3216
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9100
2000
0000
0000
9331.35
Remote Charges
1000
5000
0000
0000
-9331.35
SRN:
3217
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1000
4000
0000
0000
-1200.98
Taxes
2400
1000
0000
0000
600.01
2400
6000
0000
0000
600.98
SRN:
3218
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
1100
0003
0000
0000
33000.01
Invest in Microsoft
1000
1000
0000
0000
-33000.01
SRN:
3219
Fiscal
Month 9
Major
Minor
Sub 1
Sub 2
Amount
Description
Outcome
9999
9999
0000
0000
-0.01
suspense fix
1000
3000
0000
0000
0.01
In summary, turn in by 5PM WED NOV 29 to 280E MH: