NSC platform sent single tax rate 5.0007, where two were expected. Auto-resolved to taxrate1: -1.9992999999999999 and taxrate2: 7 based on taxrate2 of 7 set by NetSuite.

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that NetSuite's tax calculation can be complex and may not always meet specific business requirements. The tax rate can vary depending on several factors, including the customer's location and the nexus setup. In the first thread, it's mentioned that NetSuite may not handle origin-based vs destination-based states differently when calculating sales tax. The tax calculation is based on the 'Ship To Address'. However, it's also mentioned that NetSuite might not perform this level of tax triangulation well. Some users have found success using third-party products like Avalara, AvaTax for more accurate tax calculations and filing. In the second thread, the discussion revolves around hardcoding tax rates in NetSuite. While it's technically possible to hardcode a tax rate, it's generally not recommended due to the potential for inaccuracies and the difficulty of maintaining such a setup. Instead, it's suggested to properly set up taxes so that the tax code is sourced correctly. However, it's also mentioned that the tax rate can be different depending on several variables, and it might be challenging to write all the logic yourself. The tax configuration in NetSuite can be complex, and it might be difficult to understand without a solid background in tax legislation. In conclusion, while NetSuite does provide tax calculation capabilities, it might not always meet specific business requirements due to its complexity and the variability of tax rates. It's recommended to properly set up taxes and consider using third-party products for more accurate tax calculations. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

s there a way to filter transactions based on the subsidiary? I’ve been trying unsuccessfully to locate the subsidiary field in the available field references.