Journal

Contents Show

The Journal screen is used to enter general journal information for budget, actual, and forecast values as well as to add journal transactions on each account.

The screen can be displayed in Add mode, Edit mode, or Details mode. In Details mode, the information displayed on the screen is read-only and cannot be updated.

Add Journal screen

Screen Access

Screen Access

To add a journal entry:

OR

Add Journal

To edit a journal entry:

To view the details of a journal entry:

Interface Initialization

Upon initial display of the screen, the following occurs:

In Add mode:

  • The title bar text is set to "Add Journal".

  • The Journal ID text box is enabled and blank.

  • The Status value label displays Suspended.

  • The Accounting Period drop-down list box is enabled and blank.

  • The Created By value label displays the user ID of the logged on user.

  • The Journal Type drop-down list box is enabled with General Journal selected.

  • The Value Type radio button group is enabled and the Actual radio button is selected.

  • The Journal Description text box is enabled and blank.

  • The Journal Transactions data grid is blank.

  • The Total Debits value label display $0.00.

  • The Total Credits value label displays $0.00.

  • The Add Trans button is visible and enabled.

  • The Post button is visible and enabled.

  • The Suspend button is visible and enabled.

  • The Import button is visible and enabled.

  • The Cancel button is visible and enabled as the default.

  • The Edit Trans button is visible and disabled.

  • The Delete Trans button is visible and disabled.

  • The Details button is visible and disabled.

  • The Delete Entry button is visible and disabled.

In Edit mode:

  • The title bar text is set to "Edit Journal".

  • All data controls are enabled and display the previously saved values.

In Details mode:

  • The title bar text is set to "Journal".

  • All data controls are disabled, read-only, and display the previously saved values.

Screen Elements

Unless otherwise stated below, all controls on the Journal screen are visible and enabled when:

Unless otherwise stated below, all controls on the Journal screen are visible and disabled when:

If one or more special conditions exist that affect a control on the Journal screen, the condition(s) are documented for that specific control below.

Journal ID text box

  Enter the unique journal ID generated by the system in the Journal ID text box.

The control is enabled when:

Status text and value label

  View the current status of the journal in the Status text and value label.

This control defaults to "Suspended" when the journal is created. It displays the current status for edit and view.

Information in this control is read-only and cannot be changed. The value label displays in the inverse color of the screen.

Accounting Period drop-down list box

  Select the accounting period for the journal entry in the Accounting Period drop-down list box.

Each journal transaction posted to the system is assigned an accounting period code (fiscal month and year).

It will be filled with all accounting periods "Open for Adjustment" in the accounting period table sorted in ascending chronological order by accounting period. This is displayed in MM/CCYY format. It is disabled when transactions are entered, since the transaction dates must be within the accounting period.

Created By text and value label

  View the name of the user signed on in the Created By text and value label.

This is the user who initially created the entry. This control defaults to the name of the signed on user when the journal is created. It displays the name of the user who created the journal for edit and view.

Information in this control is read-only and cannot be changed. The value label displays in the inverse color of the screen.

Journal Type drop-down list box

  Select the type or classification for the journal entry in the Journal Type drop-down list box.

It will be filled with all the types in the journal type table in alphabetical order. This control defaults to General Journal.

Value Type radio button group

  Select an option in the Value Type radio button group.

This radio button group includes controls that allow you to indicate whether this is an actual, budget, or forecast journal entry. The title text of the radio button group is set to "Value Type". The following radio buttons are included in the group:

Actual radio button

Click this option to identify the journal entry as an actual entry. This radio button is initially selected as the default.

Budget radio button

Click this option to identify the journal entry as a budget entry.

Forecast radio button

Click this option to identify the journal entry as a forecast entry.

Journal Description text box

  Enter the description of the journal entry in the Journal Description text box.

It defaults to blank. The text box allows the entry of alphabetic, numeric, and special characters. Special characters are limited to the following: pound (#), ampersand (&), hyphen (-), comma (,), period (.), forward slash (/), and apostrophe (').

Journal Transactions data grid

  View the information in the Journal Transactions data grid.

Click a transaction record in this data grid to perform additional functions. This data grid displays journal transactions for this general journal entry and detail account transactions recorded against funds and accounts.

This is a single select read-only data grid. The control can be updated when the screen is active in Add or Edit mode (where applicable). The columns are sizable. Both scroll bars are visible.

The information on the data grid is presented in ascending order by journal transaction sequence. It is initially defaulted to blank.

The data grid consists of the following control(s):

Sequence column

This column displays the sequence for each record displayed within the data grid.

The title of the column is set to "Sequence". The information displayed within the column is read-only.

Transaction Date column

This column displays the date of the transaction for each record displayed within the data grid.

The title of the column is set to "Transaction Date". The information displayed within the column is read-only.

Fund column

This column displays the name of the fund for each record displayed within the data grid.

The title of the column is set to "Fund". The information displayed within the column is read-only.

Financial Account column

This column displays the financial account number for each record displayed within the data grid.

The title of the column is set to "Financial Account". The information displayed within the column is read-only.

Natural Account column

This column displays the natural account number for each record displayed within the data grid.

The title of the column is set to "Natural Account". The information displayed within the column is read-only.

Agency column

This column displays the name of the agency for each record displayed within the data grid.

The title of the column is set to "Agency". The information displayed within the column is read-only.

The column header and data are left aligned.

Debit column

This column displays the debit amount for each record displayed within the data grid.

The title of the column is set to "Debit". The information displayed within the column is read-only.

Credit column

This column displays the credit amount for each record displayed within the data grid.

The title of the column is set to "Credit". The information displayed within the column is read-only.

Transaction Description column

This column displays the description of the transaction for each record displayed within the data grid.

The title of the column is set to "Transaction Description". The information displayed within the column is read-only.

Post Period column

This column displays the post period for each record displayed within the data grid.

The title of the column is set to "Post Period". The information displayed within the column is read-only.

Total Debits text and value label

  View the sum total of the data grid's Debit column total in the Total Debits text and value label.

Information in this control is read-only and cannot be changed. The value label displays in the inverse color of the screen.

Total Credits text and value label

  View the displays the sum total of the data grid's credit column total in the Total Credits text and value label.

Information in this control is read-only and cannot be changed. The value label displays in the inverse color of the screen.

Add Trans button

  Click the Add Trans button to save general journal information in order to add a new transaction.

The control is disabled when:

It has a mnemonic of "A".

The Journal Transaction screen displays in Add mode when the button is clicked.

A selection must be entered for the Accounting Period and an entry must be added for the Journal Description before Add Trans is clicked.

Edit Trans button

  Click the Edit Trans button to edit a journal transaction.

The control is enabled when:

The control is disabled when:

It has a mnemonic of "E".

The Journal Transaction screen displays in Edit mode when the button is clicked.

Delete Trans button

  Click the Delete Trans button to delete a transaction.

The control is enabled when:

The control is disabled when:

It has a mnemonic of "D".

When the button is clicked, a standard confirmation message (C0004) displays. The options of Yes and No are available. When Yes is clicked, the system deletes the record from the database. The contents on the Journal screen are refreshed. When No is clicked, the system returns to the Journal screen (the current screen) without deleting the selected record.

When the Delete Trans button is clicked, if the journal is posted, the system displays the E0165 standard error message.

Details button

  Click the Details button to view the details of the record currently selected in the data grid.

The control is enabled when:

It has a mnemonic of "T".

The Journal Transaction screen displays when the button is clicked. This will be the default button if the journal entry is posted.

Post button

  Click the Post button to process the screen and post the journal entry and its associated transactions.

The system will validate and save the journal data, validate and save all of the journal transactions, validate the journal balances, update the account summary and then dismiss the screen.

The control is disabled when:

It has a mnemonic of "P".

The Financial Management [Journal] screen displays when the button is clicked.

When the Post button is clicked, if the sum of the debits and credits are not equal and are not greater than zero, the system displays the E0166 standard error message.

When the Post button is clicked, if the sum of the debits and credits net to zero (combine two separate journal entries into one journal entry with transactions on accounts that void each other), the system displays the E0166 standard error message.

If the Normal Balance is Debit, the Debit trans. amount is positive and Credit trans. amount is negative. If the Normal Balance is Credit, the Credit trans. amount is positive and Debit trans. amount is negative. The balance of accounts is: A = L + OE

The following tables are affected by the recording of a journal entry:

The following illustrates an example of journal entries resulting from when an authorized user selected to post the entries from the user interface:

Jrnl ID

Seq

Trans Date

Transaction Description

Fund

Account

Account Name

Agency

Amount

D/C

01

1

10/01/00

August

WICA

1000

Fund Admin. Account

·

$2,871.00

D

01

2

10/01/00

August

WICA

2000

Office Expense Acct

·

($2,871.00)

C

Note

NOTE: A posted journal entry can no longer be edited.

Suspend button

  Click the Suspend button to process the screen and suspend the journal entry and its associated transactions.

The system will validate the journal and save the journal and all of its journal transactions as suspended and then dismiss the Journal screen.

The control is disabled when:

It has a mnemonic of "S".

The Financial Management [Journal] screen displays when the button is clicked.

Upon suspend, the edit is bypassed to validate that the sum of debits is equal to the sum or credits. The journal cannot be posted until they are greater than zero and match. It will be the default button for the screen.

Note

NOTE: A suspended journal entry can later be edited.

Import button

  Click the Suspend  button to process the screen, validate and save the journal, and then import journal entries.

The control is disabled when:

It has a mnemonic of "I".

This control presents the Import Journal Entry allowing the user to choose a file and import a set of journal transactions into the data grid of the Journal displayed. The purpose of import is to reduce the manual labor by automating the entry of actual expenses exported from the Department of Accounting system. Control will return to the Journal screen.

Delete Entry button

  Click the Delete Entry button to delete the journal entry and its associated transactions if it is suspended.

The control is enabled when:

The control is disabled when:

When the button is clicked, a standard confirmation message (C0004) displays. The options of Yes and No are available. When Yes is clicked, the system deletes the record from the database. The contents on the Journal screen are refreshed. When No is clicked, the system returns to the Journal screen (the current screen) without deleting the selected record.

Cancel button

Click the Cancel button to close the screen without processing or saving data.

The control is visible and enabled when:

It does not have a mnemonic. Its keyboard shortcut is the Esc (escape) key.

The Financial Management [Journal] screen displays when the button is clicked.

Close button

Click the Close button to close the screen.

The control is visible and enabled when:

It does not have a mnemonic. Its keyboard shortcut is the Esc (escape) key.

The Financial Management [Journal] screen displays when the button is clicked.

Processing

If data can be validated and saved on the screen, the following processes occur when the screen is processed:

If no data can be validated and saved on the screen:

Data Map

The Data Map defines the values saved for all controls on the screen. If available, any additional notes or comments are displayed in the Notes column.

Control Label

Required

Table

Column

Notes

Journal ID

·

·

·

·

Status

·

·

·

·

Accounting Period

X

·

·

·

Created By

·

·

·

·

Journal Type

X

·

·

·

Value Type

X

·

·

·

Journal Description

X

·

·

·

Journal Transactions

X

·

·

·

Total Debits

·

·

·

·

Total Credits

·

·

·

·

|

Financial Management