Info | ||||
---|---|---|---|---|
| : ||||
If you export the existing Pay components from NetSuite as a .csv then you should have everything you need for the import to auto map. Make sure you don't change the column headings or have a Total line at the bottom of the .csv |
Navigate to Payroll Admin>Payroll Setup>Import Payroll Admin > Payroll Setup > Import csv records
The import type would be "custom record" and the record type is "pay component"
1.
- The "internal id" of the existing pay component must be in your import file. The best way to do this is to export a list from NetSuite as a csv of the existing records.
You can then remove all other columns that don't need updating and only include the columns you want to change
...
...
- When you do the "IMPORT MAPPING OPTIONS" page you need to ensure:
...
- It is run as an "update" not "add"
...
- You use the correct form for the type of Pay component you are updating. EG. If you are updating allowances you use the "Allowances Pay component form"
...
- "Run server script and trigger workflows" is ticked.
- "Run server script and trigger workflows" is ticked.
...
- On the Field Mapping page
...
- Your columns from your CSV should auto map
- Your columns from your CSV should auto map
...
- On the final Page
...
- Add a name and "save and run"
- Add a name and "save and run"
...
- On the confirmation page
...
- Click the link to view the import status
...