Field Descriptions

Table Information

 

Create Leave Reconciliation Journal

What can I do in this screen?

Use this screen to systematically synchronize the General Ledger with the content in the Print Accrued Leave Balances screen (People\Transactions\Leave) in the event that an adjustment is required.

If the data in these two entities do not "balance" properly, you can view the leave reconciliation journal in order to view the discrepancies. Next, you can systematically create a journal entry in order to resolve the discrepancy.

This process creates a journal entry which resolves any balance discrepancies.

You can select the Preview Default Report icon to print the report output to your screen, or you can select the Print Default Report icon to send the report to a printer. You should review the report to ensure the validity of your selections.

If you are satisfied with the report output, you must select the Action icon to execute this process.

When should I use this screen?

You can print and/or process information in this screen to display General Ledger and Accrued Leave Balance discrepancies.

Printing the report allows you to view the data; processing the data creates an entry in the General Ledger.

Field Descriptions

Identification

Parameter ID *

Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters.  You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”  

When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.

Description *

Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Leave Cycle

Option

Use the drop-down box to make a selection.  Your choices include "All" or "One."  "All" is the system default.

Select "All" to include each leave cycle, and select "One" to designate a specific leave cycle.

Start

Enter, or use Lookup to select, the leave cycle that you want to include on the report or journal entry.

Reconciliation Leave Year *

Option

This option includes only one record. This field is non-editable.

Start

Enter, or use Lookup to select, the leave year that you want to include on the report or journal entry.

Reconciliation Fiscal Year *

Option

This option includes only one record. This field is non-editable.

Start

Enter, or use Lookup to select, the fiscal year that you want to include on the report or journal entry.

Posting Accounting Period

Option

This option includes only one record. This field is non-editable.

Fiscal Year (Start) *

Enter, or use Lookup to select, the fiscal year specific to the posting of the reconciliation journal entry.

Period (Start) *

Enter, or use Lookup to select, the period specific to the posting of the reconciliation journal entry.

Subperiod (Start) *

Enter, or use Lookup to select, the subperiod specific to the posting of the reconciliation journal entry.

Employee Salary Information

Effective Date *

Enter, or use Calendar Lookup to select, the effective date specific to the hourly rate and home organization, as identified in the Employee User Flow screen (People\Maintain\Employee).

* A red asterisk denotes a required field.

Table Information

Changes to this screen update the JE_HDR (Journal Entry Header) and JE_TRN (Journal Entry Transactions) tables.

The JE_HDR_HS and JE_TRN_HS may also be updated.

The following tables represent source and update tables:

GL_DETL (GL Detail), GL_POST_SUM (GL Posting Summary), FS_SUM (Financial Statements Summary)

The following are source tables whose data is evaluated as you execute this process:

Employee Leave Balance Table (EMPL_LV_BAL); this table contains the initialized beginning balances.

Employee Leave History (EMPL_LV_HIST); this table contains all leave taken or accrued by an employee through your last posting.

Employee Leave Accrual (EMPL_LV_ACCRL)

Basic Employee Info (EMPL)

Salary Info & History (EMPL_LAB_INFO)

Leave Type (LV_TYPE)

Organizations (ORG)

YTD Accrued Employee Leave History (EMPL_LV_HIST)

Top of Page