We have a client who is using Avalara to process sales tax and they have requested a report or inquiry showing monthly sales by ship-to state that will allow them to audit Acumatica sales tax versus Avalara sales tax reports. Has anyone created anything like this?
Solved
Monthly sales by ship-to state, including sales tax
Best answer by bryanb39
I’d recommend adding a formula that checks to see if the order is Will Call or not. Will call would be the business address, non will call would be the destination state. You can get this from joining to the carriers table using ShipVia for the Join and then grabbing the isCommonCarrier field. Common Carrier would be taxed in the destination state.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.