We would like to map the Acumatica Entity Usage Type field in a Customer Profile to the analogous field in BigCommerce’s Customer table, so that we can set whether a customer is tax-exempt or taxable from Acumatica. We use Taxjar as our tax solution, and to set a customer as taxable such that the Tax integration between BigCommerce and Taxjar will work properly to recognize the tax status of a customer, we need to either leave the field blank or fill it with “TAXABLE”. Any value other than Taxable in the BigCommerce field will send a customer tax-exempt value when Bigcommerce does an API call to Taxjar for that customer.
If we sync the field as it stands now, the value for taxable in Acumatica in the Entity Usage Type is “Default”, which if entered in the BigCommerce field will make that customer exempt (opposite of what we want). Is there a way to either update the pick-list for entity usage types in Aculatica to add “TAXABLE”, or for us to use some sort of substitution in the connector between Acumatica and BigCommerce?
Best answer by smarenichView original