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:
Spreadsheet (All cells must be Text Formatted Cells. Text Formatted Cells allow information to be displayed exactly as entered.)
Fixed Width Text File (.CSV file)
Delimited Text
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:
Select FINANCIALS|Export/Import|IPG Import.
Select the type of file you want to import. The import file must be in one of the following formats:
Excel Spreadsheet. (All cells must be Text Formatted Cells. Text Formatted Cells allow information to be displayed exactly as entered.)
Fixed Width Text File or .CSV file
Delimited Text
(Select either Common Delimiters or Custom Delimiter)
Key the File Name you want to import or click <Browse> to display a list of files from which to choose.
Click the Next icon .
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.
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.
Click the Import icon
to update the unposted journals file in PRODUCTION.
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:
Employee not found: No cross reference to the IPG employee code was entered in the External Employee Code field in the Employee Profile.
Cross Reference not found: IPG sent data for which there is no cross reference.
Employee not in balance: Debits and credits are not equal.
Office not in balance: Debits and credits are not equal.
Office already in permanent file for this period: Posting can only occur once.