Importing Predefined Tax Determination Rules for Colombia

To import the predefined tax determination rules 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 Rules.

   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, do the following:

   1. Under Data Handling, choose Add.

   2. Click Next.

4. 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
      Name	Name (Req)
      custrecord_fte_taxrules_l_itemcode	Item Code
      custrecord_fte_taxrules_l_taxregime_orig	Tax Regime of the Issuer
      custrecord_fte_taxrules_l_taxregime_dest	Tax Regime of the Receiver
      custrecord_fte_taxrules_t_city_ori	City of the Issuer
      custrecord_fte_taxrules_t_city_des	City of the Receiver
      custrecord_fte_taxrules_d_eff_from	Effective From (Req)

   4. Click Next.

5. (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.

6. Click Save & Run.

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

7. 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