JOURNALIZE LABOR (PRE-PAYROLL)#
Processing Information#
Labor costs may be sent to the G/L system on a regular (daily, weekly, bi weekly etc.) or ‘on demand’ basis prior to the pay being calculated. Labor G/L processing (UPLG) takes place after the payroll batch has been entered into Personality system.The payroll batch can be generated by UPTR (from pay transactions), UPTG (system generated) or manually entered on the IPPH form. Labor G/L can process payroll batches that have been audited by the UPAUDT process or to optionally include un-audited pay lines to obtain labor costs on a timely basis.
For testing the G/L set up and balancing, it is recommended that Labor G/L be processed for one batch at a time.
Labor G/L may take place prior to auditing a batch (set the Include Unaudited Transactions lexicon to ‘Yes’) and Labor G/L may be run in update or trial mode (set the Trial lexicon to ‘Yes’).
If Labor G/L is run in trial mode (in order to check the results) and the G/L Interface (UPGLF) is run in update mode, the journal entries will be updated to permanent journal entries.
On the IDGA form, the G/L account must have the ‘Pre Payroll’ toggle on in order to be processed by Labor G/L. Labor G/L does not balance Gross to Net and Deductions. The earnings that are to be journalized will be balanced against the G/L Account that has been set up with the Labor Clearing account usage in the G/L Accounts (IDGA) form.
The process for running Labor G/L is as follows:
- UPAUDT
- to audit transactions to be journalized
- UPLG
- in Trial or Update mode
- RPGL
- to view results of UPLG
- UPGLF
- to create the interface file
- when run in Trial, use to test results
- when run in non-Trial if UPLG is not run in Trial mode, use to commit journal entries and mark the Pay Lines as ‘Journalized'
Report Parameters & Filters#
Report Parameters | |
---|---|
GL Company Code | Mandatory, 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. |
Batch Eligible | Optional, LOV Available, <Both> Transactions may be processed for batches that are marked eligible, not eligible or both. |
Person Code | Optional, LOV Available You may specify one or more employees for processing. |
As Of | Mandatory, Date, LOV Available The date up to which the transactions are to be journalized. This date is used to pick up all pay headers with a pay period end date up to and including this date. Then the pay lines are picked up if the pay line date is up to and including this date. |
Include Unaudited Transactions | Optional, Toggle If ‘On’, all pay lines including audited and un-audited transactions will be processed. This should be used if you have a large volume for UPLG and time does not permit UPAUDT to run prior to UPLG. If ‘Off’, only audited pay line will be processed. |
Trial | Optional, Toggle If ‘On’, the journal entries will be created with Journal Source = ‘Trial Labor G/L’. This allows RPGL report to print for verification and UPLG may be run again. If ‘Off’, the journal entries will be created with Journal Source = ‘Labor G/L’ and it cannot be removed unless the UPLGUNDO process is run. |
Exception Level | Mandatory, LOV Available You may increase the level of exception to user or utility levels for testing purposes only. |
Report Filters | |
---|---|
Entity | Optional and LOV Available Limits the process to the entity specified. You should select only one entity. |
Payroll | Optional and LOV Available The payroll code of the pays to be journalized. You should select only one payroll code. |
Batch Number | Optional, Multiple, and LOV Available Batch numbers for the specified entity and payroll are displayed on this list. You may select multiple batches. |
Person Code | Optional, LOV Available You may specify one or more employees for processing. |