JOURNALIZE PAYS (POST-PAYROLL)#

Processing Information#

Payroll actual costs may be sent to the G/L system after the pay cycle is closed. Payroll G/L process (UPGL) can be run on a per payrun basis or on demand basis, and should usually be run at the end of a month in order to send all journal entries of a fiscal period to the G/L system.
  • UPGL will generate journal entries by fiscal period according to the pay period of each pay.
  • During the UPGL run, you can pick up payruns that have not been journalized up to and including to the 'As of' date.
  • The ‘Post Payroll’ toggle on the IDGA form must be turned on for the G/L account in order to be journalised by UPGL.
  • Journal entries can be sent to the G/L system in summary and/or in details depending on the set up on IDGA form for each G/L account for 'Retain Detail' toggle. Then each G/L account on IDGA form can optionally turn on the toggle for 'Accrual Required', 'Inter Company Required'.)

The UPGL process may be run in ‘Trial’ mode to verify that the payroll is posting correctly and that there are no entries posted to the suspense account. This can be seen by running RPGL for the execution id generated.

The suspense account may be the result of incorrect set up. The user must correct the error and re-run UPGL until the journal entries are balanced, without a suspense account. The UPGL process may then be run in ‘non-Trial’ mode to permanently create the journal entries.

Only pay lines that are NOT marked as ‘Journalized’ (some may have been processed by Labor G/L-UPLG) will be journalized. Those items that have previously been journalized will be collectively indicated in a payroll clearing account.

The process for running Payroll G/L is as follows:

  • UPCLOZ
    • only pay headers that are closed may be journalized
  • UPGL
    • in Trial
  • RPGLP or RPGLX
    • to view results of UPGL
  • UPGLF
    • to create the interface file in Trial to test results
    • in non-Trial to commit journal entries and mark the Pay Header as ‘Journalized’

Report Parameters & Filters#

Report Parameters
GL Company CodeMandatory, LOV Available
General ledger company that the pays must be journalized for. As set up in the
IDGC form. Only one G/L company may be processed at a time.
As OfMandatory, Date, LOV Available
This field displays the date up to which payruns are to be journalized. This date is
used to derive the fiscal period and then to pick up all pay runs up to and including
this fiscal period.
TrialOptional, Toggle
If ‘ON’, the Journal Entries will be created with Journal Source = ‘Trial Payroll G/L’.
This allows RPGL to print for verification and UPGL may be run again.
If ‘OFF’, the Journal Entries will be created with Journal Source = ‘Payroll G/L’ and
it cannot be removed by the system.
Overriden GL DateOptional, LOV Available
This field allows you to specify an overridden GL Date for the UPGL run. This date
will be used as the GL effective date for all journal entries excluding the rejournalizing
pays. This should be used if you want to journalize some pays to a
different fiscal period instead of the Pay Header's original fiscal period.
E.g. a prior fiscal period is closed and some adjustments need to go into the current
fiscal period. This date will not be used for re-journalizing entries; the re-journalizing
GL entries will use the 'Re-journalize Date' prompt.
Re-Journalized OnlyOptional, LOV Available
This toggle indicates if UPGL should pick up the pay runs and pay headers that are
marked with Pay Run stage and Pay Header stage as 'To-be rejournalize' only. All
other stages will not be processed.
Re-Journalized DateOptional, LOV Available
This field allows you to specify an overridden GL Date for the re-journalized pay
headers. In one UPGL run, all pay headers for a qualified pay run will be processed
to include the pay headers with Pay Header Stage marked, 'To-be re-journalize',
unless the 'Re-journalize Only' toggle is ON. This date is used for the 'Re-journalize'
pay headers only, while the other pay headers are using either the 'Overridden GL
date' or the original Pay Header date to determine the fiscal period to be journalized.
Exception Level Mandatory, LOV Available
You may increase the level of exception for testing purposes only.

Report Filters
Trial Person CodeOptional, LOV Available
You may specify a list of employees for testing in Trial Run mode only. For a nontrial
run, all the employees for a payrun will be processed, even if you just specify a
few in this field.
EntityOptional and LOV Available
Limits the process to the entity specified. You should select only one entity.
PayrollOptional and LOV Available
The payroll code of the pays to be journalized. You should select only one payroll
code.
Pay Run NumberOptional, Multiple, and LOV Available
Pay run numbers for the specified entity and payroll are displayed on the LOV list.
You may select multiple pay run numbers.


Notes #

Click to create a new notes page