ADI - Customizing Worksheet Layout

...

Distribution

UVA GL Budget Specialist

GL Accountant

GL Accounting Manager

GL Administrator

Ownership

The Director of Accounting Services is responsible for ensuring that this document is necessary, reflects actual practice, and supports University policy.

Applications Desktop Integrator
B ® Ledger ® Enter Journals
Create Journal Worksheet
B ® Edit the Layouts
Define Worksheet Layout

1. Click the [Ledger] icon (open book; third icon from the left) on your toolbar and select Enter Journal from the list.

2. Select the Journal Type and Number of Journals.

Note: Most users will select "Functional Actuals." Only GL Budget users will select "Budgets." In most cases you will select "Single" for the Number of Journals.

3. Click the [Edit Layout] button (lower right corner of the preceding screen shot) to customize the journal worksheet.

Select your customizing options, as described below for the Worksheet, Header, and Lines tabs.
Choose OK to enable your customized options, or Cancel to abort.

Note: If you check the box labeled Sample (located at the bottom of the Define Worksheet Layout window), you can see a preview of your custom journal worksheet. The preview window is dynamic and reflects your changes immediately.

Note: When you click [OK] to enable your customized options, the system stores your options as default settings for future journal worksheets.

Customizing Journal Worksheets

Worksheet Tab

Shows the selected Journal Type and Number of Journals. You can select different options to change the journal type.

Header Tab

Customize the header information for a single-entry journal worksheet. For multiple-entry journal worksheets, the Header tab is disabled and its title changes to ”No Header” because the header information appears in the journal lines, but you can still change their settings on the Lines tab.

NOTE: If you check the box labeled Database Columns, located at the bottom of the Define Worksheet Layout window, the information in the required and optional fields will list the GL_INTERFACE column names, rather than the descriptions of what those columns represent. The column names display option is provided for technical users of General Ledger. Under most circumstances, leave this box unchecked.

You can customize the following header items:

Required Fields: Fields in the journal entry header that cannot be changed. However, you can rearrange their sequence.
Optional Fields: Fields that can be added in your journal entry header. To display one of the additional fields as a row in your header, check the box next to its name. As with required fields, you can change the display sequence.

Lines Tab

Customize the information displayed on each journal line. In a multiple-entry journal worksheet, the journal lines include the header information discussed earlier.

You can customize the following items:

Required Fields: Fields in the journal entry lines that cannot be changed. However, you can rearrange their sequence.
Optional Fields: Fields that can be added to your journal entry lines. To display one of the additional fields as a column in your journal lines, check the box next to its name. As with required fields, you can change the display sequence.
Effective: 08/13/04

Revision: 2

Oracle Tutor can be licensed to modify and add to this content, documenting all of your business process documentation in the Oracle Tutor format.

Oracle® Tutor Copyright © 1997, 2009, Oracle. All rights reserved.