Has anyone had the same issue we are having with the Colorado Retail Delivery Fee using NetSuite and Avalara? The $0.28 charge is calculated properly on our website, but when an order is synced or manually created in NetSuite, the fee is not applied.
When the customer orders on our website, it will charge them the $0.28 fee and they pay that on the total amount. When the order is then synced over to NetSuite, the total amount of the sales order is reduced by $0.28. This makes the order total amount $0.28 lower than the customer deposit.
Also, if an order is manually placed in NetSuite, the $0.28 RDF charge is not charged. We are using Avalara (AvaTax) on both our website and in NetSuite. We are not quite sure what needs to be done in NetSuite so it will calculate the RDF when an order is manually place. We also are not sure what needs done so when an order syncs from our website to NetSuite, it recognizes the RDF fee and shows it in the order total.
We reached out to Avalara, and their response to our ticket was:
"For the CO RDF to be calculated on a transaction, it must be added as a separate line item with tax code OF400000.
(https://knowledge.avalara.com/bundle/hvp1668662778044_hvp1668662778044/page/ACTION_NEEDED_Colorado_Retail_Delivery_Fee_begins_July_1_2022.html)
Avalara cannot reconfigure the data transfer process between Shopify and NetSuite. If Shopify is not able to pass the RDF line item to NetSuite then you would need to implement a solution within NetSuite to add the RDF line item where applicable."
Any help would be greatly appreciated!