Name_______________________________________
SS#____________________________Database Name _______
e-mail address__________________________________________
2. (20 points) TO BE RETURNED BY 5PM TUE DEC 2 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 result 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 | RESULT |
1900 | 1000 | 0000 | 0000 | |
1900 | 8000 | 0000 | 0000 | |
2600 | 3000 | 0000 | 0000 |
2.3 Add the following accounts to the general ledger:
Major | Minor | Sub 1 | Sub 2 | Description | RESULT |
9000 | 9500 | 0000 | 0000 | Network Consultant Charges | |
9000 | 9000 | 0000 | 0000 | Texas Gas Expense | |
4000 | 3000 | 3000 | 0000 | Misc. Revenues | |
4000 | 3000 | 5000 | 0000 | PopUp Ad Revenue | |
4000 | 3000 | 6000 | 0000 | Referral Revenue | |
9000 | 9000 | 1000 | 0000 | Misc. Expense |
2.4 Modify the following account descriptions:
Major | Minor | Sub 1 | Sub 2 | New Description | RESULT |
9000 | 5000 | 0000 | 0000 | Supplies and Replacement Parts | |
1000 | 1000 | 0000 | 0000 | Cash Operating -- Geneva Texas Bank 033-333-333-3 | |
1000 | 6000 | 0000 | 0000 | Cash New York Payroll Account |
2.5 Using your transaction system post the following journal vouchers to your general ledger system:
SRN: | 7701 | Fiscal Month |
8 | |||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | RESULT |
9000 | 9000 | 1000 | 0000 | 2743.01 | ||
1000 | 1000 | 0000 | 0000 | -2743.01 | Misc. Charges | |
SRN: | 7702 | Fiscal Month |
8 | |||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | RESULT |
1900 | 6000 | 0000 | 0000 | 178.00 | Prepaid Computer Lease | |
1000 | 1000 | 0000 | 0000 | -178.00 | ||
SRN: | 7703 | Fiscal Month |
8 | |||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | RESULT |
9000 | 9000 | 1000 | 0000 | 5327.11 | Sick Tree Consultant Expense | |
1000 | 2000 | 0000 | 0000 | -5327.11 | ||
SRN: | 7704 | Fiscal Month |
8 | |||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | RESULT |
1000 | 3000 | 0000 | 0000 | -975.00 | suspense correction | |
9999 | 9999 | 0000 | 0000 | 975.00 | ||
SRN: | 7705 | Fiscal Month |
9 | |||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | RESULT |
1000 | 4000 | 0000 | 0000 | 500.21 | Sept sales | |
4000 | 3000 | 5000 | 0000 | -300.07 | ||
4000 | 3000 | 6000 | 0000 | -100.07 | ||
4000 | 3000 | 3000 | 0000 | -100.07 | ||
SRN: | 7705 | Fiscal Month |
9 | |||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | RESULT |
1000 | 2000 | 0000 | 0000 | -1020.00 | Trash Expense | |
9000 | 8100 | 0000 | 0000 | 1020.00 | ||
SRN: | 7706 | Fiscal Month |
9 | |||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | RESULT |
1000 | 4000 | 0000 | 0000 | -700.00 | pay taxes | |
2400 | 1000 | 0000 | 0000 | 499.50 | ||
2400 | 5000 | 0000 | 0000 | 201.50 | ||
SRN: | 7708 | Fiscal Month |
9 | |||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | RESULT |
1100 | 0003 | 0000 | 0000 | 200000.00 | CD 3456-9866-1 12-0202002 | |
1000 | 1000 | 0000 | 0000 | -200000.00 | Buy a Trasury Bond | |
SRN: | 7709 | Fiscal Month |
9 | |||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | RESULT |
9999 | 9999 | 0000 | 0000 | -11111111.11 | suspense again | |
1000 | 1000 | 0000 | 0000 | 11111111.11 | ||
SRN: | 7709 | Fiscal Month |
9 | |||
Major | Minor | Sub 1 | Sub 2 | Amount | Description | RESULT |
1000 | 1000 | 0000 | 0000 | -211.11 | Pay the Piper | |
1000 | 1000 | 0000 | 0000 | 211.11 |
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 AND PROVIDE A GRAND TOTAL OF ALL ACCOUNT BALANCES.
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 TUE DEC 2 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