Error Importing Order Lines using Order Importer / Tax Issue

I have an issue using the Importer on orders. I have an import files that imports with out errors. I have verified that it matches the file spec for the import file. The problem is that I have the boolean for taxable set to false but when I import the records into imis it adds tax to the order. The products are set to be taxable in imis. The name records in imis also have a default tax authority. The importer should override this autocalculation of tax based on the value I specify in the import file. I have tried changing the boolean value to False, false, f and 0. But none of them made any difference. Can you please let me know if this is a bug of if some other value is required?

Dave

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Default tax authority

This behaviour is by design.
If the imported data doesn't indicate a tax authority, the import procedures will select TAX_AUTHOR_DEFAULT from Name_Fin where ID = the incoming Orders.BT_ID.

As you have indicated, your Name_Fin records have a default set so this default is used.

Taxable Field

What does the boolean for taxable do then in the import file?

Taxable boolean field in the OL line

Although this field is indicated as being used to override the product taxation status, the code will override this option and apply the Product.TAXABLE value to Order_Lines.TAXABLE unless the ID is marked as tax exempt.
A workaround might be to temporarily uncheck the product's taxable status.