Capt. Horatio T.P. Webb
DISC 4372 Transaction Processing II
ASSSIGNMENT #2 -- Fall 2000
Last Updated 12PM 8/21/2000

Assignments #2 requires you to develop a WEB based general ledger (GL) accounting application using HTML/VBScript as the front-end and a Microsoft SQL Server transaction processing engine.

The transaction processing application consists of three parts:

  1. The client environment which is composed of HTML page(s) -- perhaps some with VBScript segments to:

    • provide user navigation between functions
    • provides links to the user functions required

  2. Client-side data entry/validation (assignment #1) is composed of HTML and VBScript. These components will provide the user with the ability to:

    • Make client-side journals entries (the journal voucher)

  3. SQL Server Transaction Processing using Active Server Pages is the final integrated system which will:
    • generate a full trial balance query
    • generate an GL query with user-defined account
    • generate a user-defined journal voucher query from the journal entry year-to-date table
    • Add General Ledger Accounts
    • Modify General Ledger Account Decsriptions
    • Delete General Ledger Accounts
    • Apply (post or update) the journal entries to the general ledger in the SQL Database and append the journal entries to the Journal Entry Year-To-Date table

Assignment #2 Specifications:

The functions outlined above represent several types of client and server tasks. Assignment #2 is to develop a WEB environment that provides navigation between all the tasks listed above. This will consist of a user menu page (name this assignment homepage a5.htm. It should be stored in your /~your_user_id/public-html/ directory on the disc.cba.uh.edu server). On loading, this top-level menu page three area makes three options available to the user:

  1. Post Journal Vouchers (assignment #1)-- A single form (named a3.htm) to allow user to submit fully edited journal vouchers. The voucher contains:
    1. a four digit numeric source reference number
    2. a maximum of six journal entries per voucher. Each journal entry contains:
      1. four digit major account number
      2. four digit minor account number
      3. four digit sub1 account number
      4. four digit sub2 account number
      5. 50 character text description
      6. transaction amount (currency)
    3. a display of the sum of the journal entries (must be zero)

  2. General Ledger Maintenance (Add, Modify, Delete GL Accounts) which in turn contains three form pages:

    1. ADD (named a41.htm) -- User enters a major-minor-sub-1-sub2 account number and description. On submission, the new account will be inserted into the GL master table
    2. MODIFY (named a42.htm) -- Only account descriptions can be modified. User specifies the account number and new description
    3. DELETE (named a43.htm) -- User submits the account number to be deleted. Fails if account balance is not zero.

  3. Queries: the page should provide three page options for the three required queries

    1. a44.htm -- a request an ASP to generate a full trial balance query
    2. a45.htm -- a form to generate an GL query with user-defined account
    3. a46.htm -- a form to generate a user-defined journal voucher query from the journal entry year-to-date table

The seven pages you create (i.e, a new a3.htm and a41.htm through a46.htm) which are linked to a5.htm should have an corporate artistic theme. Name your company, create logos and color schemes that create a pleasant experience for the user. But navigation will be graded on functionality -- not art.

A link to the assignment homepage (a5.htm) should be placed on your homepage (i.e.,/~your_user_id/public-html/index.html). Graded will be done from this top level link to the assignments.

The SQL Server-Side Database

Each student will be assigned a unique database. Two tables will need to be created. The first table is the General Ledger Master Table (named glmaster). The table is organized:

The primary key is the composite of major-minor-sub1-sub2. Transaction amounts from the journal voucher are posted to this table.

The second table is the Journal Entry Year-to-Date table (named je). This table has:

The primary key of the table is the composite of sourceref and srseq fields.

The Server-Side Processes

  1. Journal Voucher Posting

    Using the form developed in assignment #1 (i.e., a modification of your original a3.htm) and create the ASP necessary for each journal entry on the journal voucher. You should:

    • update each GL account by adding the entry's transaction amount to the account balance field in the glmaster
    • add each journal entry to the JE-Year-To-Date table je

  2. GL Table Maintenance

    1. a41.htm ADD GL Accounts

      Required data entry fields:

      • GL Account number (i.e., major, minor, sub1, sub2)
      • GL Account Description

      Each new GL account's balance should be set to zero.

    2. a42.htm MODIFY GL Account Descriptions

      Users will enter:

      • a valid GL account
      • a new GL Account Description.

      This description field (i.e., acctdesc) is the only modifiable field in glmast.

    3. a43.htm DELETE GL Accounts

      Users will enter:

      • a valid GL account number for deletion

      NOTE: An account cannot be deleted if it has a non-zero balance

  3. Queries

    1. a44.htm Full Trial Balance Query

      Request an active server page that produces a report of all of the accounts in the general ledger (i.e., glmaster). The report should include the sum of all account balances. The report should indicate any out-of-balance condition that arises.

    2. a45.htm GL Account Query

      Provide for the user input of:

      • a valid general ledger account number

      The query returns all information in the glmaster table relavant to that account.

    3. a46.htm Journal Voucher Query

      Provide for the user input of:

      • a valid source reference number

      The query returns all information in the je table relavant to that journal voucher (i.e., all elements of the voucher should be returned). Show that the sum of all transaction amounts is zero

Return to Parks' DISC4372 homepage