WA state tax report change
It needs to show the total order amount per loc code and not total tax collected as these are the numbers WA state asks for. It needs to be order totals before shipping and tax but after coupons, etc.. I ended up running this SQL statement to get the info for last year.. select LineMessage,sum (ProductSubtotal) from acOrderItems, acOrders where acOrderItems.LineMessage is not null and acOrderItems.OrderID = ac_Orders.OrderID and OrderDate between '2012-01-01' and '2012-12-31' group by LineMessage
4
votes
Tim Yaskus
shared this idea
This feature is now available in Gold R8