# Colorado Tax - TaxRetailFee Not on the mappings

**URL:** https://connective.celigo.com/t/colorado-tax-taxretailfee-not-on-the-mappings/519
**Category:** Integration Apps
**Tags:** avalara, lookup, netsuite
**Created:** [March 2, 2023, 2:38pm UTC](https://connective.celigo.com/t/colorado-tax-taxretailfee-not-on-the-mappings/519 "2023-03-02T14:38:42Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![idrisstalainteoulili](https://avatars.discourse-cdn.com/v4/letter/i/eb9ed0/32.png) [@idrisstalainteoulili](https://connective.celigo.com/u/idrisstalainteoulili)
#### Post date: [March 2, 2023, 2:38pm UTC](https://connective.celigo.com/t/colorado-tax-taxretailfee-not-on-the-mappings/519/1 "2023-03-02T14:38:42Z")

</div>

Hey

Thanks for the new feature  
  
i did everything but when I want to customize the colorado tax to 0 because we want SO to call Avalara using only that **non-inventory item**  
(Colorado item) the **TaxRetailFee** it didn't show up in the mappings automatically I add manually when i add the **lookup** to 0 it didn't change that in Netsuite

 ![5301043caa20740200000001-75ef0a9286fd40119f857431eb1f7fe5.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/c/ca33f0b27bd949d81d4e74e56401e38751e336e5.png)

 ![5301043caa20740200000001-a6c5470e530845edbbb2a08d048ace26.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/1/100334ea0cfe0ef11482a9b9b5946f7feab11417.png)

**Thanks**

---

<div class="post-metadata">

### Author: ![sairachamalla](https://avatars.discourse-cdn.com/v4/letter/s/ecccb3/32.png) [@sairachamalla](https://connective.celigo.com/u/sairachamalla)
#### Post date: [March 3, 2023, 9:35am UTC](https://connective.celigo.com/t/colorado-tax-taxretailfee-not-on-the-mappings/519/2 "2023-03-03T09:35:16Z")

</div>

Hi @idrisstalainteoulili  
  
Using the **Map province retail shipping tax** setting, the override will only happen when the override value is not “ **0**". Also, the current implementation is not adding a line item in Netsuite if the price is " **0**". You can [write a custom script in NetSuite](https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N2933122.html) to make the value ‘ **0** ’ after syncing the order. Let us know if this helps.

Happy posting!