Sync province retail shipping tax to NetSuite

Comments

5 comments

  • David Gollom Strategic Partner
    Top Contributor
    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer
    Engaged

    Thanks. I'll put in a ticket.  The customer did not have the Province tax setup and the tax was captured on a variance line by the setup on the Order tab.  I would expect that all variances would be recorded in the variance fields even if the variance is corrected by an additional line. You still want to know why the variance is there so you can account for it properly. 

    0
  • Idriss Talainte Oulili Strategic Partner
    Engaged
    Celigo University Level 4: Legendary
    Awesome Follow-up
    Amazon-NetSuite IA Certification
    eBay-NetSuite IA Certification
    Salesforce-NetSuite IA Certification
    Shopify-NetSuite IA Certification
    Walmart-NetSuite IA Certification

     

    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 



    Saikumar Rachamalla
    Thanks

     

    0
  • Saikumar Rachamalla Docs Team Lead Principal Technical Writer

    David Gollom could you please raise a support ticket with additional details to understand if the customer has set up the NS non-inventory item to track as a separate line and is still calling that a variance or did the customer use the same NS item for both variance and shipping tax? 

    0
  • Saikumar Rachamalla Docs Team Lead Principal Technical Writer

    Hi Idriss Talainte Oulili

    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 to make the value ‘0’ after syncing the order. Let us know if this helps.

    Happy posting!

    0
  • David Gollom Strategic Partner
    Top Contributor
    Celigo University Level 4: Legendary
    Answer Pro
    Great Answer
    Engaged

    Hi - I have a customer dealing with the variances related to the Colorado tax.  The variance line is added on the orders however there's no variance recorded on the eTail sub tab of the order. The Order Total Variance and the Tax Variance are zero.  Shouldn't this variance also be recorded there for reporting purposes?? 

    0

Please sign in to leave a comment.