Import IPG File

This process allows you to load employee salary data that can then be imported to the FINANCIALS System. Before information can be imported, Cross-references must be set up in the IPG Payroll Interface Xref option in the browser's FINANCIALS System. These cross-references are used to translate information being sent from PeopleSoft to IPG to Mediaocean.

CLIENT REQUIREMENTS:

The import file must be in one of the following formats:

The file layout is provided by IPG and contains the following columns of information; however, some columns may be left blank. Columns are in the following order:

Column 1: Year (4 positions)

Column 2: Month (2 positions)

Column 3: Employee Name (10 positions)

Column 4: IPG Defined

Column 5: Mediaocean Employee ID (5 positions)

Column 6: IPG Defined

Column 7: Intercompany Flag (1 position)

Column 8: IPG Defined

Column 9: IPG Defined

Column 10: IPG Defined

Column 11: IPG Defined

Column 12: Expense Liability Code (2 positions)

Column 13: Earning Code (3 positions)

Column 14: IPG Defined

Column 15: Benefit Plan (6 positions)

Column 16: Deduction Code (6 positions)

Column 17: Deduction Class (1 position)

Column 18: IPG Defined

Column 19: IPG Defined

Column 20: Tax Class (1 position)

Column 21: Amount (15 positions) This amount must contain decimal places. Negative amounts are represented with a minus sign at the beginning of the amount. Example: -500.50

IMPORT PROCESS:

  1. Select FINANCIALS|Export/Import|IPG Import.

  2. Select the type of file you want to import. The import file must be in one of the following formats:

  1. Key the File Name you want to import or click <Browse> to display a list of files from which to choose.

  2. Click the Next icon next.gif. The following message displays: "Importing and parsing file". If errors are found, a message displays informing you to use the Audit Listing. An IPG Payroll Error report is generated and is used to identify errors in the import file and any cross-referencing errors. Refer to Possible Errors section: Since sensitive payroll information can be found on the report, it is always placed on HOLD status in your output queue. To print the report, it must be released for printing or you can view the report online. Cross-reference errors are identified and must be corrected using the IPG Payroll Interface Xref option before you can import data. Other errors may exist and they must be corrected on the spreadsheet before importing.

  3. After errors are corrected or if no errors were found, click the Next icon to display the IPG Pay Import grid. This grid displays all summarized journal entries in the import file along with the number of rows that were loaded. A Detail Pay Import Edit listing is generated and contains information that was collected and can be used to verify information in the import file. This report is also placed on HOLD status in your output queue and must be released for printing. Changes cannot be made on the IPG Pay Import grid that is displayed; therefore, if you want to make changes, they can be made only in Option 10, View/Edit Payroll Entries, on the PRRECL Menu.

  4. Click the Import icon import.gif to update the unposted journals file in PRODUCTION.

  5. If you do not have any changes to make in Option 10, View/Edit Payroll Entries, on the PRRECL Menu, you may select Option 11, Print Review List, then post journals through Option 12, Post IPG Payroll Journals.

Possible Errors

Below is a list of errors that may be listed on the IPG Payroll Error Report: