hello, how to import vendor bill with a tax group?...
# csvimports
m
hello, how to import vendor bill with a tax group??
n
What issue have you experienced ?
m
the problem is that i can't map the tax group field. I can only use the tax code field. Which is strange because in UI, I have to select the tax group and I don't have the possibility to select a tax code (this is for Canada)
n
this is sounding familiar. we recently migrated a Canada customer, let me see what we did.
1
we avoided the problem as the HST/GST/PST had been accounted on their original transactions and we therefore imported with a %0 tax rate. doesn't help you sorry
m
ok but when you imported, so you used a 0% tax code and not a tax group? is it this 0% tax code that allowed the system to determine the tax group?
n
We set the Tax Code as GST/HST 0%. Tax Group I need to check
message has been deleted
Have you tried mapping the Tax Group to the Tax Code on your CSV import?
a
I remember having to figure this out for a Canada use case and it was a nightmare. I set the Tax Group at 0% Non-Taxable & added the Tax Code: Non-Taxable and it allowed the import to go through after that. The addresses on Vendor record also were causing issues. This was from a demo account that NetSuite preloaded with records so everything was setup different. Hope that helps!