For all of you who are using Avalara/AVaTax, my accounting team gives me a Document Summary Reconciliation report from Avatax and has sked me to see if these numbers match up in Epicor and to write the a report they could run from Epicor for them. Has anyone wrote a report doing this?
I’ve been trying to a while now and I keep running into issue after issue.
I’ve written a few reports to reconcile Avatax and Epicor. I dont remember the report you have. Can you share the column headers? I dont need any of your data.
Customer Vendor Code, Document Date, Total Sales, Discount, Exempt/Non Taxable Sales, TAxable Sales, Tax Amount
the report is summary of sales and tax data by customer by date?
no invoice/document numbers?
Sorry, the first column is Document Code. As in Invoice numbers.
Do either of you know if there is some user guide or tech guide on how to set up avalara and epicor? I saw a configuration guide for company maintenance setup but I didn’t see things outlining anything else such as reports or exports, etc…
No, when we purchased Avalra we had someone help us set it up and then we tested it.
@tmcgrady is the person to reach out for tax setups. best advice I can give you is reach out to professional services. I’ve configured it a bunch of times, and it’s not to hard, but there is a lot to learn.
Thank you both @Will79 and @bderuvo ! Yeah I am trying to get it set up with them, but I like to have literature on it so I can read up on it and get an idea for myself before going into a consulting session.
The Alavara education process will get you up to speed quickly. They make you watch some training videos prior to consulting time, that is helpful.
@bderuvo Did you happen to write a report that was to reconcile the above AvaTax report with Epicor?
@Will79 I wrote this somewhere else and I dont have a copy.
looks like you need to write a baq to pull in the invchead table with a few linked subqueries.
Summarize the InvcDtl table ExtPrice+TotalMiscCharges and Discount Fields for sales and discounts.
Summarize the InvcTax table TaxAmt field. I think you can get taxable sales amount from here too.
Breaking out the Exempt sales is tricky because epicor doesnt store that data in invcdtl from avalara, the tax exempt field would need to manually maintained by your team. if you use the tax Exempt field, you could summarize the invcdtl table for only exempt.