Importing Predefined Tax Determination Settings for Colombia

To import the predefined tax determination settings for Colombia:

1. Go to Setup > Import/Export > Import CSV Records.

2. On the scan & upload CSV file step, do the following:

   1. In the Import Type field, select Custom Records.

   2. In the Record Type field, select Tax Determination Settings.

   3. In the Character Encoding field, select Unicode (UTF-8).

   4. In the CSV Column Delimiter field, select Semicolon.

   5. In the CSV File(s) field, choose if you're uploading one or multiple files.

   6. Click Select... and select one or multiple CSV files from your local storage.

   7. Click Next.

3. On the import option step, under Data Handling, choose Add.

4. Click Next.

5. On the field mapping step, if the mapping is not automatically populated, do the following:

   1. In the Your Fields pane, click on the name of a field from the CSV file.

   2. In the NetSuite Fields pane, click on the name of the corresponding NetSuite field.

   3. Repeat the previous two steps until you match all the CSV file fields to the NetSuite fields.

      Match the fields according to this chart:

      Your Fields	NetSuite Fields
      custrecord_fte_taxrate_l_taxrule	Tax Determination Rule
      custrecord_fte_taxrate_l_taxcode	Tax Code (Req)
      custrecord_fte_taxrate_p_rate	Rate (Req)
      custrecord_fte_taxrate_d_effective_from	Effective From (Req)

   4. Click Next.

6. (Optional) On the save mapping & start import step, enter the relevant mapping information.

   Mapping information can help you when you're tracking the import's progress, or if you want to edit or run the import again later. For more information, see Step Five Save Mapping & Start Import.

7. Click Save & Run.

   This saves and runs the import. A message confirms that the import process started.

8. Click Job Status to view the import status.

   Refresh the page until the status in the Status column states that the import is Completed.

Related Topics