Setting Up Salary File Import

Before importing your salary file, complete the following steps.

To set up Salary File Import:

1. Go to Customization > Lists, Fields, & Records > Other Record Fields.

2. Click New.

3. From the Record Type list, select Department.

4. In the Label field, enter Payroll Department.

5. In the ID field, enter _xx_payroll_dep (replace the xx with the company prefix).

6. Click Save.

   

7. Go to Setup > Company > Classifications > Departments.

8. Click New.

9. For each new department, in the Name and Payroll Department fields, enter matching values as shown in the following table.

   Internal ID	Name	Payroll Department
   9	Balance Sheet	אין מחלקה
   1	Business Development	Business Develop
   2	Customer Care	Customer Car
   3	General & Administrative	General & Admini
   10	HR	HR
   7	IT	IT
   5	Marketing	Marketing
   6	Research & Development	Research & Devel
   8	Sales	Sales

   Note:

   For אין מחלקה Payroll Department, in the Name field, ensure you enter either No Department or Balance Sheet and from the Subsidiary list, ensure you select IL Subsidiary.

   This is because NetSuite uses the value -NO DEPARTMENT- in reports if the department has no value, but for the salary file import, the value אין מחלק ה is required.

   

10. In the global search, search for IL Salary File Import Mappings.

11. On the IL Salary File Import Mappings List page, click New IL Salary File Import Mappings.

12. Add an entry for an account.

    1. In the Name field, enter Account.

    2. Ensure the Active and Is Source Mapping boxes are checked.

    3. From the System list, select שקלולי ת.

    4. In the Mapped Record field, enter Account.

    5. In the Mapped Record ID field, enter account.

    6. In the Mapped Lookup Field ID field, enter number.

    7. In the Journal Target Field ID field, enter account.

    8. Check the Show Stopper If Empty and Show Stopper If Lookup Missing boxes.

    9. In the Start Index field, enter 62.

    10. In the Length field, enter 8.

    11. Click Save.

13. On the IL Salary File Import Mappings List page, click New IL Salary File Import Mappings.

14. Add an entry for Department.

    1. In the Name field, enter Department.

    2. Ensure the Active and Is Source Mapping boxes are checked.

    3. From the System list, select שקלולי ת.

    4. In the Mapped Record field, enter Department.

    5. In the Mapped Record ID field, enter department.

    6. In the Mapped Lookup Field field, enter Payroll Department.

    7. In the Mapped Lookup Field ID field, enter CUSTRECORD_XX_PAYROLL_DEP.

    8. In the Journal Target Field ID field, enter department.

    9. Ensure the Show Stopper If Empty and Show Stopper If Lookup Missing boxes are not checked.

    10. In the Start Index field, enter 102.

    11. In the Length field, enter 17 or 16.

    12. Click Save.

General Notices