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?
Monthly sales by ship-to state, including sales tax
Hello,
Ship-To-State may be added to a list of Invoices, generic inquiry (Sales Orders is shown here):
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/86b84f15-aa40-4114-8b5c-ee5a9c153314.png)
Here is the join from AR Invoice to ARShippingAddress table:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/3185800b-3ad0-4c98-9eb5-252ff92f22cc.png)
Laura
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.
hello
I agree with Bryan. Here is the join information to add Ship Via, Will Call, and Tax Zones to the same generic inquiry.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/374795d4-30a1-484f-9408-2abe8eb946f4.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/a1f20bd1-7d73-459c-9857-d6745fdfcb64.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/5be9241f-8754-4eeb-b34b-a17bc26428e7.png)
Laura
Thanks all for the replies! We’ll take a look at this and see if it will meet our client’s needs.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.