Hello,
We have a scenario where our invoicing is done from Salesforce. We have integrated Salesforce with NetSuite so when the invoice is generated in SF - it is automatically recorded in NetSuite.
We are a Canadian company and we now have a situation where we are now collecting sales tax in several US states. We have implemented Avalara to handle tax when creating the quotes/orders/invoices in Salesforce. To accommodate for the application of tax by Avalara in SF - in the integration with NetSuite, we have automatically added a line item to the NetSuite invoice to capture the calculated US tax amount for each state (ie: we have created an item in NS for each state, mapped to a liability account - and the amount that Avalara calculates is posted as the line item amount for that line).
This is all working great - except when ARM is introduced. Since we have ARM implemented, those tax amounts are posted to deferred revenue (as expected) and then recognized immediately (ie: 'no deferral' rule). However, we are a CAD company so when the process is run to post journals - the US tax amounts in the liability accounts are converted and posted in CAD by the JE. These amounts should be in USD so that they can be revalued.
Looking for some creative ideas on we might be able to find a solution for this issue. We can't use direct revenue posting - since other line items are deferred.
Any thoughts/suggestions would be greatly appreciated.
Thanks,
Greg