Considerations for Spreadsheet Preparation

The import function in the JD Edwards EnterpriseOne software is designed to work with Microsoft Excel© spreadsheets, comma-separated values, or values from a clipboard.

When you prepare the spreadsheet, consider these factors:

• The system uses the same validations for data that you import that it uses for data that you enter manually. Therefore, verify that the values you want to import are valid values for the program. For all the system validates that the new records are not duplicates of existing records. The system performs programs, these additional validations:

  Program	Validations
  Setup Payroll Category	The system performs these validations: The value entered or imported for the Company field must exist in the Company Constants table (P0010). The value entered or imported for the Currency field must exist in the Currency Codes table (F0013).
  Payroll Category and Payroll Elements Relation	The system performs these validations: The value entered or imported for the Payroll Category ID field must exist in the F75C504 table. The value entered or imported for the Payroll Element ID field must exist in the F75C505 table.
  Setup Payroll Periods	The system validates that dates are entered in a valid format.
  Employee Payroll Details - China	The system performs these validations: The value entered in the Employee ID filed must exist in the Address Book Master table (F01012). The values entered in the Employee Name and Department ID fields must exist in the Employee Records Information table (F75C008). You use the Employee Record Information program (P75C008) to add information about each employee, including the department for the employee. See Setting Up and Generating the CNAO Shared Information XML File The value for the Employee Category field must exist in the Employee Category (75C/EC) UDC table. The values that you enter in the Legal Entity and Payroll Category Name fields must exist in the F75C504 table. Values for these fields must exist in the F75C502 table: Payroll Period Year Payroll Period Number

• The columns in the spreadsheet must be in the same order as the fields on the form in which you would manually enter data. For example, when you manually enter data in the Payroll Category and Payroll Elements Relation program, you enter data in the fields on the Payroll Category and Payroll Elements Relation form. You must list the values for the Payroll Category ID field in a column that precedes the column for the Payroll Element ID field.

  If you choose to leave an optional field blank, insert a blank column in the appropriate place in the spreadsheet.

• Consider preparing a spreadsheet with the values for only a few records before preparing a spreadsheet with all of the records that you need to import. Importing a few records initially enables you to verify that you have the data in the correct format and in the correct order in the spreadsheet.