34 Set Up General Information

This chapter contains these topics:

34.1 Setting Up General Information

Setting up general information allows you to enter specific information about how your organization accounts for labour or processes payroll. This information consists of:

Information Description
Company constants You set up company constants to control the labour accounting and payroll processing for the employees of each company.
Business unit constants You set up business unit constants to define default information associated with a business unit.
Master pay cycles You set up master pay cycles to provide dates for each payroll of the year.
Denomination codes You set up denomination codes to define the various denominations used to pay employees who receive cash payments.
Execution control parameters You set up execution control parameters to specify the users who have the authority to execute and reset the various steps of the payroll cycle.
Fields for future data revisions You choose fields for future data revisions to activate data items in the employee master record that can be updated using the future data functions.

Setting up general information consists of the following tasks:

  • Setting Up Company Constants

  • Setting Up Business Unit Constants

  • Setting Up Master Pay Cycles

  • Setting Up a Denomination Code

  • Setting Up Execution Control Parameters

  • Choosing Fields for Future Data Revisions

  • Reviewing the Business Unit Constants Report

  • Reviewing the Master Pay Cycles Report

34.2 Setting Up Company Constants

You set up Payroll company constants to control the payroll processing for the employees of each company. You must set up default company constants before you can process a payroll. JD Edwards World recommends that you enter Payroll company constants when significant changes occur, such as the addition of a new company.

When you set up Payroll company constants, you set up the default company and each individual company. You enter information for Company 00000, the default company, to define the overall operating environment. You set up company constants for each of your companies for which you run payroll. If you use the JD Edwards World General Accounting system, you must set up separate company constants for that system.

Setting up company constants includes the following tasks:

  • Setting up the default company

  • Setting up an individual company

34.2.1 Before You Begin

  • Verify that the company has been added to the Company Constants table (F0010). Company constants are typically maintained by the Accounting department.

34.2.2 Setting Up the Default Company

Navigation

From Canadian Payroll Master (G77), enter 29

From Payroll Setup (G774), choose Payroll General Constants

From Payroll General Constants (G7741), choose Payroll Company Constants

You enter information for Company 00000, the default company, to define the overall operating environment. If you have multiple companies, the parameter settings for Company 00000 must include all of the possible variations that cover all of the companies you set up.

For instance, if one company requires integration with the Accounts Payable system, you must set up Company 00000 control parameters to reflect Accounts Payable integration. At the default company level, you can also indicate whether you want the Payroll or Time Accounting system to integrate with the JD Edwards World General Ledger system.

If you change the default company constants, the changes affect all other companies you set up.

To set up the default company

On Payroll Company Constants

Figure 34-1 Payroll Company Constants screen

Description of Figure 34-1 follows
Description of "Figure 34-1 Payroll Company Constants screen"

  1. For Company 00000, complete the following fields and click Add:

    • Company Number

    • Company Name

    • Company Address

    • City

    • State

    • Zip Code

    • County

  2. Complete the Company Number field and click Inquire.

    Figure 34-2 Payroll Company Constants screen

    Description of Figure 34-2 follows
    Description of "Figure 34-2 Payroll Company Constants screen"

  3. Complete the following fields:

    • Pay Cycle Control

    • Accelerated Submission

    • Tax Arrearage

    • Batch Control

    • Spending Account

    • Tip/Piece Processing

    • G/L Integration

    • A/P Integration

    • Employee Number Mode

    • Payroll Register Edit

    • Separate Check

    • Step Progression Process

    • Maximum Deferral Rate

    • Fiscal Year (Begin Mo)

  4. To identify the standard time and periods worked by salaried or auto employees, complete the following fields:

    • Hours/Day

    • Days/Week

    • Weeks/Year

    • Hours/Year

  5. If you have employees based in more than one country, complete the following fields:

    • International

    • Country Code

  6. If your company has employees based in Australia, complete the following field:

    • Annual Leave Hours

  7. Compete the Vertex Database Library field and click Add.

The Standard Interest Rate field is for future use and is inactive for this release.

Field Explanation
Pay Cycle Control A code specifying whether to incorporate execution control into the payroll cycle steps. Valid codes are:

Y – Yes. You must set up execution control, by version, to determine who can execute the steps within the payroll cycle.

N – No. No execution control. The person who runs the first pre-payroll step must run all steps in the cycle. This is the default value.

Accelerated Submission A code that determines whether you can submit the pre-payroll, journal entries, and reports only steps of the payroll cycle simultaneously. Valid codes are:

Y – Yes. Allow accelerated submission.

N – No. Do not allow accelerated submission. Each payroll cycle step must be complete before you can submit the next payroll step from the menu. This is the default value.

Note: When accelerated submission is allowed, pre-payroll must run first. Also, the job queue specified for the pay cycle version must allow only one job to be active at a time.

Tax Arrearage (Y/N/O) A code that specifies whether calculated taxes are reduced and the method used if an employee's cheque is a negative amount. Codes are:

N – Do not perform any tax reductions. Overpayment processing (negative cheque adjustment) occurs after all deductions have been reduced according to their rules. This is the default code.

Y – Perform tax reductions. Overpayment processing (negative cheque adjustment) occurs after all deductions and taxes have been reduced according to their rules.

O – Perform tax reductions. Overpayment processing (negative cheque adjustment) occurs after taxes have been reduced but before type 2 deduction rules apply.

Batch Control A code that generates automatic verification of the totals entered for each batch.

Valid codes are:

Y Batch control on. A batch header control form appears when you select journal entries. You enter the total number of documents and the input total, which is the total currency amount you expect the batch to contain.

When you finish entering each batch, the following occurs:

The system displays the difference, if any, between the input totals and the totals you actually entered.

N Batch control off.

Spending Acct. (Y/N) A code that controls approval of batches for posting.

Valid codes are:

Y – Management approval is required. The system assigns a status code of Pending to each batch. You must manually change the status to Approved before the system will allow the batch to post to the general ledger.

N – Management approval is not required. The system automatically approves for posting all batches that do not have error conditions.

Tip/Piece A code that specifies whether to include tipped or piecework employees in payroll processing.

Valid values are:

N Company does not have tipped or piecework employees. This is the default value.

1 Company has tipped employees.

2 Company has piecework employees.

International (Y/N) A Yes/No field that specifies whether to use Canadian payroll processing. Valid codes are:

Y – Use Canadian payroll processing.

N – Use U.S. payroll processing. This is the default value.

Form-specific information

This field activates Canadian vocabulary overrides and fields on some employee forms. Enter Y in this field if you process payroll for Canadian employees.

When you activate international data, you must also use the Country Code field to specify whether the system displays Canadian information for this company.

G/L Integration Code that indicates how batches of payroll journals are posted to the General Ledger. Valid codes are:

A – Automatic. If batches are in balance and there are no errors, the system posts batches automatically during the final update step of the payroll cycle. This is the default value.

M – Manual. Each batch must be posted manually.

N – None. There is no General Ledger interface.

T – Time Accounting

Employee No. Mode This code identifies which form of the employee number displays on an inquiry screen. Valid values are:

1 – Display the eight-digit Address Book number. This is the default code.

2 – Display the nine-digit Social Security number.

3 – Display the eight-digit Additional Employee number preceded by a slash (/).

All forms of employee number remain valid. This code controls only what displays.

A/P Integration This field specifies the level of integration between the Payroll and the Accounts Payable systems. The system creates pro forma vouchers during the payroll journal entries step of the payroll cycle. The system creates actual vouchers during the final update step.

N – No integration

0 – Create vouchers for both DBAs and taxes that have been setup with A/P integration

1 – Create vouchers only for DBAs that have been setup with A/P integration

2 – Create vouchers only for taxes that have been setup with A/P integration

Separate Check (Y/N) This code indicates whether a separate cheque is generated for each Business Unit in which an employee has worked during the pay period. Valid values are:

N – Do not generate separate checks. This is the default value.

Y – When pre-payroll locks the time entry record, generate a unique cheque control number for each business unit's time entry record

Payroll Register Edit An error is always noted on the Payroll Register if Gross Pay minus taxes and deductions does not equal Net Pay. This field controls whether the error is treated as a "hard" or "soft" error.

Y – Hard error. You must correct the error and run Pre-Payroll again. This is the default code.

N – Soft error. The error is noted on the Payroll Register but Payroll Cycle processing can continue. You must make the necessary corrections after the Payroll Cycle is complete.

Because errors can occur during payroll cycle processing even when payments print correctly, JD Edwards World recommends that you set this field to Y. Typical errors include incomplete interim cheque information or tax areas not set up and therefore not printing.

Step Progression Process A code that specifies whether the system updates Step Progression History tables and the level of detail in which the update occurs. Valid values, based on the information in the Employee Master table (F060116) are:

1 – Update using Union, Job Type, and Job Step

2 – Update using Home Business Unit, Union, Job Type, and Job Step

N – Do not update the Step Progression History tables

For the system to apply step progression, you must also do the following:

  • Enter S in the Employee Class field on Employee Entry.

  • Enter Y in the Step Progression field on Additional Parameters in pre-payroll processing.

Maximum Deferral Rate The maximum percentage of pre-tax earnings that an employee is allowed to defer to a retirement plan. For example, to enter a rate of 12.75 percent, enter 12.75 in this field.
Hours/Day This field indicates the number of hours in a standard working day. This information may be used for automatic overtime computations and other scheduling purposes.
Days/Week The number of days in the work week. This number may be used (among other reasons) in the computation of automatic overtime.
Weeks/Year The number of work weeks in the year.

The number of bi-weekly, semi-monthly, and monthly periods in the year will be assumed to be 26, 24, and 12, respectively.

Hours/Year The number of work hours in the year. When you do not set your payroll company constants to use the Pay Grade Step table as the pay-rate source, the system uses this number to compute the hourly rate when you supply the annual salary (or to compute the annual salary when you supply the hourly rate).

When you set your constants to use the Pay Grade Step table as the pay rate source, the system uses the following sequence to search for the standard number of hours that it uses to calculate the salary or hourly rate per pay period:

  • Employee entry forms (this field)

  • Pay Grade Step table (hours per day multiplied by days per year)

  • Payroll company constants for the employee's company

  • Payroll company constants for the default company (company 00000)

  • Data dictionary

  • System default value of 2080 standard hours per year

Annual Leave Hours The standard number of hours generated as Annual Leave during automatic wage processing.
Country Code A user defined code 00/CN that determines the mode in which the payroll system runs.

Form-specific information

Valid codes are:

Blank U.S. payroll

CA – Canadian payroll

If you set the International field to Y, you must set the Country Code.

If you process Canadian payroll only, use CA as the Country Code.

If you process both Canadian and U.S. Payroll, use CA as the Country Code.

Fiscal Year (Begin Mo) The number of the month in which the payroll fiscal year begins.

Program-specific information

For the Canadian Payroll systems, this code must always be 01 (January). The government regulates the payroll fiscal year as January through December.

Vertex Database Library This is the library that contains the Vertex database.

Form-specific information

If you are using Vertex Payroll Tax software, you must complete this field.


34.2.3 Setting Up an Individual Company

Navigation

From Canadian Payroll Master (G77), enter 29

From Payroll Setup (G774), choose Payroll General Constants

From Payroll General Constants (G7741), choose Payroll Company Constants

You set up company constants for each of your companies for which you run payroll. When you set up an individual company or make changes to an existing company's name or address, the system automatically updates the Address Book system.

To set up an individual company

On Payroll Company Constants

Figure 34-3 Payroll Company Constants screen

Description of Figure 34-3 follows
Description of "Figure 34-3 Payroll Company Constants screen"

  1. Complete the following fields:

    • Company

    • Company Name

    • Company Address

    • Fiscal Year

  2. To identify the standard time worked by salaried or auto employees, complete the following fields:

    • Hours/Day

    • Days/Week

    • Weeks/Year

    • Hours/Year

  3. If you process Canadian or both U.S. and Canadian payroll, complete the following fields:

    • International

    • Country Code

34.3 Setting Up Business Unit Constants

Navigation

From Canadian Payroll Master (G77), enter 29

From Payroll Setup (G774), choose Payroll General Constants

From Payroll General Constants (G7741), choose Business Unit Constants

You set up business unit constants to define default information associated with a business unit to expedite time entry and automatically process payroll information, such as flat burden at the business unit level.

When you set up a business unit, the system adds it to the General Accounting Business Unit Master table (F0006) if the business unit does not already exist in that table. In many companies, business units are set up in the JD Edwards World General Accounting system by the Accounting department.

You must use the General Accounting System and not the Payroll system to change any of the following information:

  • Level of detail

  • Posting edit code

  • Company number

  • Equipment rate code

34.3.1 Before You Begin

  • Review any existing business unit information

To set up business unit constants

On Business Unit Constants

Figure 34-4 Business Unit Constants screen

Description of Figure 34-4 follows
Description of "Figure 34-4 Business Unit Constants screen"

  1. Complete the following fields:

    • Business Unit Number

  2. Complete the following optional fields:

    • Job Address Number

    • Tax Area

    • Labor Loading Method

    • Burden Factor

    • Pay Cycle Group Code

The County Tax Number, County Code, Job Type, and Denomination Minimum fields are for future use and are inactive for this release.

Field Explanation
Labor Load Method A code indicating that flat burden is to be calculated. Valid codes are:

0 – Flat burden percentage will always be 1.000 and, therefore, the flat burden amount will equal zero. Basically, this means that there is no distribution.

1 – Flat burden percentage will always be greater than 1.000. Choose this option when distributing the percentage.

There are various places within the Payroll system where flat burden rules and percentages can be defined, such as:

Business Unit

Pay Rates table

Employee level

Burden Factor A multiplier to load direct labour costs with burden. For example, a factor of 1.32 loads every dollar of labour cost with 32 cents worth of burden.
Pay Cycle Group Code A user defined code (07/PG) that indicates a pay cycle group. If you enter a pay cycle group code here, the system processes only those timecards whose business unit has that pay cycle group assigned in the business unit constants. The type code explained below determines which business unit is used in the selection process.

This field and the accompanying Type field override the DREAM Writer home business unit selection. Employees must first be selected in the DREAM Writer Data Selection, then timecards for those employees are selected based on Pay Cycle Group Code and Type.


34.4 Setting Up Master Pay Cycles

Navigation

From Canadian Payroll Master (G77), choose [Menu Selection]

From Payroll Setup (G774), choose Payroll General Constants

From Payroll General Constants (G7741), choose Master Pay Cycles

You set up master pay cycles to provide dates for each payroll of the year. The system uses these dates during the pre-payroll step of the payroll cycle and for interim cheque processing. When you set up master pay cycles, you also minimize the risk of keying errors during pre-payroll because certain values have already been entered. Within a master pay cycle, you define the length of the pay periods as well as corresponding payment dates.

Master pay cycles allow you to define the following information:

  • Pay period ending dates

  • Identifiers for the pay period

  • Payment dates for each pay period

  • Withholding period indicators to determine the calculation of DBAs

  • Integrity period numbers for storing tips history

  • Standard hours per pay period for autopay

Setting up master pay cycles includes:

  • Setting up a master pay cycle for the current year

  • Setting up a similar master pay cycle for the next year

You set up a master pay cycle for the current year to run payroll cycles for the current year. You must set up a new master pay cycle each year. If you already have a master pay cycle for the current year, you can set up a pay cycle for the next year.

To simplify the setup process, you set up a master pay cycle for the next year that is similar to the current year's master pay cycle. You can duplicate a current cycle indicating whether you want to increment the pay period end dates for the new year. For example, if your company's pay period ends on the 15th of each month, you do not want to increment, or align dates. If your company always pays on the first and third Fridays of each month, you want to increment dates to account for the changed date in the new year.

34.4.1 Before You Begin

  • Set up user defined code 07/PY to define the names of the pay cycles.

  • Set up user defined code 07/PF. Ensure that the Special Handling Code field in the detail area (F4) of this UDC contains the default pay cycle code for each pay frequency.

To set up a master pay cycle for the current year

On Master Pay Cycles

Figure 34-5 Master Pay Cycles screen

Description of Figure 34-5 follows
Description of "Figure 34-5 Master Pay Cycles screen"

  1. Complete the following fields:

    • Pay Cycle Code

    • Date - Year

    • Year to Date Pay Period Number

    • Month

    • Ending Date

    • Check Date

    • Integrity Period

  2. Complete one of the following fields:

    • Pay Periods to Calculate Withholding - Weekly

    • Pay Periods to Calculate Withholding - Biweekly

    • Pay Periods to Calculate Withholding - Semimonthly

    • Pay Periods to Calculate Withholding - Monthly

    • Pay Periods to Calculate Withholding - Annually

    • Pay Periods to Calculate Withholding - Other

  3. Access the detail area.

    Figure 34-6 Master Pay Cycles screen (Detail area)

    Description of Figure 34-6 follows
    Description of "Figure 34-6 Master Pay Cycles screen (Detail area)"

  4. To set up standard hours for automatic pay employees, enter a standard number of hours to use for each pay frequency in one of the following fields:

    • Standard Hours - Weekly

    • Standard Hours - Biweekly

    • Standard Hours - Semimonthly

    • Standard Hours - Monthly

    • Standard Hours - Annually

    • Standard Hours - Other

Field Explanation
Pay Cycle Code A code that identifies the values for a master pay cycle.
Pay Period Number The number of the pay period from the beginning of the year. For instance, a monthly payroll cycle beginning in January has a total of 12 periods, with October being the 10th period.

Typical values are:

001-052 (Weekly Payroll Cycle)

001-026 (Biweekly Payroll Cycle)

001-024 (Semimonthly Payroll Cycle)

001-012 (Monthly Payroll Cycle)

001-004 (Quarterly Payroll Cycle)

001-001 (Annual Payroll Cycle)

Check Date The date associated with the various types of net pay instructions. This date can be related to a payroll cheque, a bank deposit advice, a payslip (cash), or a claim reimbursement.

Form-specific information

The date the cheque will be issued. Unless you use the Override Date Edits option:

  • This date must be greater than or equal to the Ending Date

  • Dates must be in ascending sequence throughout the year

Intgry The meaning of this field depends on the program from which you access the field:
  • Valid Master Pay Cycles (P069061) - A value that specifies the period bucket number in the Payroll Integrity table (F0620) to be updated. The Integrity Period Number specifies one of five periods in which the system stores the history. It does not determine the calculation of DBAs. If you run a multiple frequency payroll (such as salary with both weekly and biweekly employees), enter an unused Integrity Period Number. For example, for the first biweekly payroll of the month, use 2 because 1 was already used for the first weekly payroll.

  • Pay Cycle Control Parameters (P06210) - A value that designates whether the pre-payroll programs will calculate those benefits and accruals that are based on calendar month amounts (dollars/hours). If N, the system skips these benefit and accruals.


34.4.2 What You Should Know About

Topic Description
Determining rollover dates In addition to scheduling pay cycles, the Fiscal Anniversary Rollover program uses the dates you enter on the master pay cycle to determine when a benefit or accrual rolls over to the next year.

To set up a similar master pay cycle for the next year

On Master Pay Cycles

  1. Locate the pay cycle for the current year.

  2. Choose the Duplicate Cycle function.

    Figure 34-7 Duplicate Pay Cycle screen

    Description of Figure 34-7 follows
    Description of "Figure 34-7 Duplicate Pay Cycle screen"

  3. On Duplicate Pay Cycle, complete the following fields:

    • Pay Cycle Code

    • Year

    • Align Dates

Field Explanation
Align Dates (Y/N)? If you answer Y to Align Dates, the system increments the pay period ending dates by one day for the new cycle. If you enter N, the system creates the cycle with the same pay period ending dates as the current cycle.

The years must be only one apart in order for this function to work.

Companies who pay on the same date each month, for example on the 15th and 30th of each month, should set this field to N.


34.5 Setting Up a Denomination Code

Navigation

From Payroll Master, enter 29

From Payroll Setup (G774), choose Payroll General Constants

From Payroll General Constants (G7741), choose Denomination Code Revisions

You set up denomination codes to define the various denominations used to pay employees who receive cash payments. The system uses the information you define to produce payslips in the correct denomination and for a bill count on a cash disbursement report.

34.5.1 Before You Begin

  • Set up each domination value (face value of a bill or note) in user defined codes list 07/DN.

To set up a denomination code

On Denomination Code Revisions

Figure 34-8 Denomination Code Revisions screen

Description of Figure 34-8 follows
Description of "Figure 34-8 Denomination Code Revisions screen"

Complete the following fields:

  • Country Code

  • Denomination Code

  • Denomination Value

Field Explanation
Denomination Code A code which identifies the type of currency to be processed.
Denomination Value The face value of the denomination (for example, 10 for a ten dollar bill or 1000 for a 1000 peso note). Each country generally has a unique set of denomination codes and each code has its own value.

34.6 Setting Up Execution Control Parameters

Navigation

From Payroll Master, enter 29

From Payroll Setup (G774), choose Payroll General Constants

From Payroll General Constants (G7741), choose Execution Control Parameters

You set up execution control parameters to specify the users who have the authority to execute the various steps of the payroll cycle. You can also specify who has authority to execute the reset features on a payroll ID.

Each payroll ID can have a unique set of control parameters. If the system finds no parameters for a specific ID, the system uses the parameters for ID 000. If no parameters exist for a specific payroll ID or for ID 000, the system processes payroll as if the execution control parameters are not activated. In this case, the person who runs the first step of the payroll cycle must run all steps in the cycle and reset options.

34.6.1 Before You Begin

  • Enter Y in the Pay Cycle Control field on Payroll Company Constants for Company 00000 to activate the execution control parameters. If the code in this field is N (the default), the user who runs the first step of the payroll cycle must run all steps in the cycle.

To set up execution control parameters

On Execution Control Parameters

Figure 34-9 Execution Control Parameters screen

Description of Figure 34-9 follows
Description of "Figure 34-9 Execution Control Parameters screen"

  1. Complete the following field:

    • Pre-Payroll

  2. In the fields which correspond to payroll cycle steps, enter the user ID of a maximum of five individuals authorized to complete each step and reset option.

Field Explanation
01 Payroll Cycle Steps: The defined user identification for the individual who may have access to the Payroll Processing step "Pre-Payroll". Valid values are:

Any user ID - Only that user has authority to run the particular payroll or reset step.

*All - All users have authority to run the particular payroll or reset step.

*USER - Only the user who ran the step has the authority to execute the step defined by *USER.


34.7 Choosing Fields for Future Data Revisions

Navigation

From Canadian Payroll Master (G77), enter 29

From Payroll Setup (G774), choose Payroll General Constants

From Payroll General Constants (G7741), choose Specify Future Data Fields

You choose fields for future data revisions to activate data items in the employee master that can be updated using the future data functions. For example, you activate the Marital Status field so that you can change an employee's marital status in the employee master using the Future Data function.

You cannot change the activation value of some fields.

To choose fields for future data revisions

On Specify Future Data Fields

Figure 34-10 Specify Future Data Fields screen

Description of Figure 34-10 follows
Description of "Figure 34-10 Specify Future Data Fields screen"

  1. Next to the data item that you would like to activate, enter a Y in the following field:

    • Yes/No

  2. To review the data item code associated with the data item description, access the detail area.

Figure 34-11 Specify Future Data Fields screen

Description of Figure 34-11 follows
Description of "Figure 34-11 Specify Future Data Fields screen"

34.8 Reviewing the Business Unit Constants Report

Navigation

From Canadian Payroll Master (G77), enter 29

From Payroll Setup (G774), choose Payroll General Constants

From Payroll General Constants (G7741), choose Business Unit Constants

You run the Business Unit Constants Print report to verify your entries on Business Unit Constants. The report lists detailed information about business units which is contained in both the Business Unit Master table and the Payroll Business Unit table. You can run this report any time.

Figure 34-12 Business Unit Constants report

Description of Figure 34-12 follows
Description of "Figure 34-12 Business Unit Constants report"

34.9 Reviewing the Master Pay Cycles Report

Navigation

From Canadian Payroll Master (G77), enter 29

From Payroll Setup (G774), choose Payroll General Constants

From Payroll General Constants (G7741), choose Master Pay Cycles Report

The Master Pay Cycles report lists the information you entered on Master Pay Cycles. The report includes the following:

  • Year

  • Pay cycles by month and periods within each month

  • Standard number of hours included in each pay period

Review this report to verify that the information you entered during system setup is correct.

Figure 34-13 Master Pay Cycles report

Description of Figure 34-13 follows
Description of "Figure 34-13 Master Pay Cycles report"