Error: "An error occurred importing the file [file name]. This happens on line Number: [#] Field Name: Bill to Sale Tax ID"

• Sales Tax ID begins with zeros
• Comma Separated Value (CSV) file will drop the leading zeros
• Sales Tax ID in CSV file does not match an existing Sales Tax ID in the database
• TAXCODE.DAT was not copied from old company's folder
• Duplicate Sales Tax ID and/or Sales Tax Agency ID
• Special characters in the Sales Tax ID and/or Sales Tax Agency ID

Note: If there are special characters in the Sales Tax ID and/or the Sales Tax Agency ID, then you will not be able to import the Bill to Sales Tax ID. The only workaround is to remove the Bill to Sales Tax ID column from the CSV file and uncheck Bill to Sales Tax ID on the Fields tab when importing.

Section 1: Leading zeroes in Sales Tax ID

• You will need to delete the existing Sales Tax ID that contains leading zeros and create one that does not lead with zeros
• In addition, you will need to modify the Bill to Sales Tax ID in the CSV file to match the new ID created
• Make sure you have copied all the required files from the old company's folder, including TAXCODE.DAT and TAXAUTH.DAT
• See DocLink: How can I rebuild my company without bringing over journal data?; follow Section 2, step 1

Section 2: Duplicate Sales Tax ID or Sales Tax Agency ID

If you have duplicate IDs for Sales Tax or Sales Tax Agency, you will need to delete and recreate your Sales Taxes and Sales Tax Agencies.

1. Click Maintain, Sales Taxes.
2. Select the option to Delete a sales tax or sales tax agency, and then click Next.
3. Select the appropriate taxes and/or tax agencies and click Delete at the bottom of the page.
4. Click Back.
5. Select Create a new sales tax, and then click Next.
6. Follow the steps to recreate your Sales Tax and Sales Tax Agencies making sure to use unique IDs for each.